PDA

Click to See Complete Forum and Search --> : Clobs & Blobs?


CornedBee
Sep 23rd, 2004, 11:52 AM
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

Andy_Hollywood
Sep 24th, 2004, 09:34 AM
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...

CornedBee
Sep 24th, 2004, 09:39 AM
That might work...