Skip site navigation (1) Skip section navigation (2)

Re: [JDBC] The bytea datatype and JDBC

From: "Dave Cramer" <Dave(at)micro-automation(dot)net>
To: <pgsql-general(at)postgresql(dot)org>, Gunnar Rønning <gunnar(at)polygnosis(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [JDBC] The bytea datatype and JDBC
Date: 2001-06-15 17:53:33
Message-ID: 00b401c0f5c4$18946f30$0201a8c0@INSPIRON (view raw or whole thread)
Lists: pgsql-generalpgsql-jdbc

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>
To: <pgsql-general(at)postgresql(dot)org>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
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 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...
> regards,
>         Gunnar
> --
> Gunnar Rønning - gunnar(at)polygnosis(dot)com
> Senior Consultant, Polygnosis AS,
> ---------------------------(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, WaltDate: 2001-06-15 21:24:17
Subject: RE: No suitable driver
Previous:From: Gunnar RønningDate: 2001-06-15 16:02:46
Subject: The bytea datatype and JDBC

pgsql-general by date

Next:From: Eric RidgeDate: 2001-06-15 18:04:42
Subject: RE: Indexing varchar[]'s
Previous:From: Dariusz PietrzakDate: 2001-06-15 16:21:36
Subject: Re: CLUSTER. (fwd)

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group