From: | "Barry Lind" <blind(at)xythos(dot)com> |
---|---|
To: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: types used for JDBC BLOB and CLOB? |
Date: | 2004-08-23 19:32:59 |
Message-ID: | 03E7D3E231BB7B4A915A6581D4296CC6978CE1@NSNOVPS00411.nacio.xythos.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Marc,
The answer is it depends, but if they intend to use the jdbc BLOB/CLOB
interface it is server side LargeObjects, not bytea. However you can
use bytea, but then you need to use the get/setXXXStream() interfaces.
Thanks,
--Barry
-----Original Message-----
From: Marc G. Fournier [mailto:scrappy(at)postgresql(dot)org]
Sent: Monday, August 23, 2004 11:52 AM
To: Barry Lind
Cc: Marc G. Fournier; pgsql-jdbc(at)postgresql(dot)org
Subject: RE: [JDBC] types used for JDBC BLOB and CLOB?
'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
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2004-08-23 22:06:44 | Re: types used for JDBC BLOB and CLOB? |
Previous Message | Marc G. Fournier | 2004-08-23 18:51:50 | Re: types used for JDBC BLOB and CLOB? |