Sending database Clob data via RMI

[nsb]

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 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.

 

[Marko Lahma]

How about just sending just the underlying byte[] as return value to the
client? Really doesn't get much more efficient unless you use
compression etc.

-Marko