Clobs & Blobs?

How would I create a java.sql.Clob or java.sql.Blob from Scratch? I can't find anything in the docs about how to obtain them aside from ResultSet.getBlob and ResultSet.getClob, which require that I have a compatible ResultSet, which I don't have.

Thanks in advance

I believe that the java.sql.Clob and Blob are interfaces, so you can create your own instances of them.

However i don't know if these clobs and blobs would actually work in someelses database, you'd hope so, but i don't know for sure..

I know we had problems with the Blobs returned by an Oracle Driver we were using and we managed to erpair it byt wrapping the Oracle Blob implementation with one of our own, so i know some things are possible....

Andy...

That might work...