You should check the README file in the jdbc directory of the source. There
is some discussion about BLOB's in it.
----- Original Message -----
From: "Gunnar Rønning" <gunnar(at)polygnosis(dot)com>
Sent: Friday, June 15, 2001 12:02 PM
Subject: [JDBC] The bytea datatype and JDBC
> I saw Tom Lane mentioning the bytea datatype as the way to do BLOBs for
> tables, but I cannot find anything on it in the documentation and
> it is not supported by the JDBC driver as far as I can see.
> Where can I get information about it, so I can go on with implementing
> for it ?
> Is there any performance differences between using BLOB/OID and bytea ?
> I cannot use the OID approach with the application in question as it is
> an JDBC app(Turbine from jakarta.apache.org) that relies on asking the
> driver for the datatype. Doing this for an OID column does ofcourse return
> integer while you in some instances would like it to return varbinary.
> The Turbine people recommend this patch :
> I don't like this approach as it may break other usages of OID, so hence
> desire to use bytea to get something that works.
> Turbine is a quite large and nice web app framework in Java, and it would
> nice to see more Turbine users go from mysql to pgsql. But this issue is
> a showstopper for a lot of the people trying...
> Gunnar Rønning - gunnar(at)polygnosis(dot)com
> Senior Consultant, Polygnosis AS, http://www.polygnosis.com/
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
In response to
pgsql-jdbc by date
|Next:||From: Skidmore, Walt||Date: 2001-06-15 21:24:17|
|Subject: RE: No suitable driver|
|Previous:||From: Gunnar Rønning||Date: 2001-06-15 16:02:46|
|Subject: The bytea datatype and JDBC|
pgsql-general by date
|Next:||From: Eric Ridge||Date: 2001-06-15 18:04:42|
|Subject: RE: Indexing varchar's |
|Previous:||From: Dariusz Pietrzak||Date: 2001-06-15 16:21:36|
|Subject: Re: CLUSTER. (fwd)|