I added CLOB/BLOB interface implementations into the JDBC2.0 driver for 7.0
so they should work.
Stream support isn't yet available but if you read your stream into a byte[]
array, then feed it to PreparedStatement then it will work . JDBC can handle
arrays <-> Blobs but not streams yet.
Peter
--
Peter T Mount peter@retep.org.uk, peter@retepdigital.com, me@petermount.com
Homepage: http://www.retep.org.uk Contact details @ http://petermount.com
PostgreSQL JDBC: http://www.retep.org.uk/postgres/
Java PDF generator: http://www.retep.org.uk/pdf/
----- Original Message -----
From: Matt Fair <matt@netasol.com>
To: <pgsql-interfaces@postgresql.org>
Sent: Saturday, July 15, 2000 7:18 PM
Subject: [INTERFACES] Clob support in jdbc
> Hello,
> I need to be able to store product information in a database. The
> product information includes descriptions that can be 4000 +
> characters. I have tried setAsciiStream() in the jdbc but it is not
> supported. It there any way I can store this information?
> Thank you,
> Matt Fair
>