pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Clob support in jdbc
2+ messages / 2 participants
[nested] [flat]

* Clob support in jdbc
@ 2000-07-15 18:18  Matt Fair <matt@netasol.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Matt Fair @ 2000-07-15 18:18 UTC (permalink / raw)
  To: pgsql-interfaces

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Clob support in jdbc
@ 2000-07-16 08:35  Peter Mount <peter@retep.org.uk>
  parent: Matt Fair <matt@netasol.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Mount @ 2000-07-16 08:35 UTC (permalink / raw)
  To: Matt Fair <matt@netasol.com>; pgsql-interfaces

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
>




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-07-16 08:35 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-07-15 18:18 Clob support in jdbc Matt Fair <matt@netasol.com>
2000-07-16 08:35 ` Peter Mount <peter@retep.org.uk>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox