JDBC - sending Clob data via RMI

From: nsb (nsb12834_at_yahoo.co.uk)
Date: 10/05/03


Date: Sun, 05 Oct 2003 20:25:44 +0200

Hello,

I have queried a CLOB column from my database, using JDBC getClob().
Now I need to send this data back to a waiting client JVM, via RMI.

But the Clob type is not Serializable, so it can't be done directly.
The CLOB is a potentially large piece of data (up to, say 10Mb), so I'd prefer
to send the data back directly as some sort of stream, without making a
temporary local copy each time.

Can anyone advise the best / most efficient way to do this?

TIA,
nsb.