T E Schmitz <[EMAIL PROTECTED]> writes:
>Hello,
>I searched the archive to find out whether there are any issues with
>PostgreSQL BLOBs but most of the recent postings seem to be Oracle
>specific; so excuse the rather unspecific question:
>Does anybody have any experience with using Torque/PostgreSQL/BLOBs? I
>need to store small jpg files (15KB).
Do you really need BLOBs? I'd suggest that you use "BINARY":
<table name="IMAGE_DATA">
<column name="IMAGE_DATA_ID" required="true" primaryKey="true" type="BIGINT"
javaType="object"/>
<column name="IMAGE_DATA_LAST_CHANGE" required="true" type="TIMESTAMP" size="0"
javaName="LastChange"/>
<column name="IMAGE_DATA_LAST_USER" required="true" size="64" type="VARCHAR"
javaName="LastUser"/>
<column name="IMAGE_DATA_DATA" required="true" type="BINARY" javaName="ImageData"/>
<id-method-parameter name="sequence_name" value="table_sequencer" />
</table>
Works fine with PostgreSQL and my Images are a "bit" bigger (1-5 MBytes).
Regards
Henning
--
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen INTERMETA GmbH
[EMAIL PROTECTED] +49 9131 50 654 0 http://www.intermeta.de/
RedHat Certified Engineer -- Jakarta Turbine Development -- hero for hire
Linux, Java, perl, Solaris -- Consulting, Training, Development
"Fighting for one's political stand is an honorable action, but re-
fusing to acknowledge that there might be weaknesses in one's
position - in order to identify them so that they can be remedied -
is a large enough problem with the Open Source movement that it
deserves to be on this list of the top five problems."
-- Michelle Levesque, "Fundamental Issues with
Open Source Software Development"
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
