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

Re: types used for JDBC BLOB and CLOB?

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: Barry Lind <blind(at)xythos(dot)com>
Cc: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>,pgsql-jdbc(at)postgresql(dot)org
Subject: Re: types used for JDBC BLOB and CLOB?
Date: 2004-08-23 18:51:50
Message-ID: 20040823154713.X4215@ganymede.hub.org (view raw or flat)
Thread:
Lists: pgsql-jdbc
'k, I believe what the client is wanting to know is what the storage type 
would be on the backend, that the would BLOB/CLOB map to ... bytea?

On Mon, 23 Aug 2004, Barry Lind wrote:

> Marc,
>
> If you are specifically talking about the JDBC types BLOB and CLOB those
> classes use the server LargeObject interface.  If you are speaking
> generically about support for large objects then the jdbc driver
> supports the bytea datatype for the get/setBinaryStream() methods.  So
> the answer is "it depends", on how you use the driver.  The specifics
> for supporting binary objects are documented in a section on this topic
> in the postgresql jdbc driver documentation chapter.
>
> Thanks,
> --Barry
>
> -----Original Message-----
> From: Marc G. Fournier [mailto:scrappy(at)postgresql(dot)org]
> Sent: Monday, August 23, 2004 8:44 AM
> To: pgsql-jdbc(at)postgresql(dot)org
> Subject: [JDBC] types used for JDBC BLOB and CLOB?
>
>
> Just been asked this, and I'm not sure of the answer ... based on
> reading the docs on bytea, I'm assuming that it is such, but can someone
> please confirm?
>
> Thanks ...
>
> ----
> Marc G. Fournier           Hub.Org Networking Services
> (http://www.hub.org)
> Email: scrappy(at)hub(dot)org           Yahoo!: yscrappy              ICQ:
> 7615664
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org           Yahoo!: yscrappy              ICQ: 7615664

In response to

pgsql-jdbc by date

Next:From: Barry LindDate: 2004-08-23 19:32:59
Subject: Re: types used for JDBC BLOB and CLOB?
Previous:From: Barry LindDate: 2004-08-23 16:04:13
Subject: Re: types used for JDBC BLOB and CLOB?

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