Re: types used for JDBC BLOB and CLOB?

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

'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