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 flat)
Thread:
Lists: pgsql-generalpgsql-jdbc
Gunnar,

You should check the README file in the jdbc directory of the source. There
is some discussion about BLOB's in it.

Dave
----- 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
support
> 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
JDBC
> 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 :
> http://jakarta.apache.org/turbine/howto/postgres-howto.html
>
> I don't like this approach as it may break other usages of OID, so hence
my
> desire to use bytea to get something that works.
>
> Turbine is a quite large and nice web app framework in Java, and it would
be
> 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, 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

Responses

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-2014 The PostgreSQL Global Development Group