Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> oracle BLOB and java.sql.Blob
Hi everybody,
i get trouble using the supplying standard package of oracle 8.1.7 for
jdbc2.0 support! , i'm trying to write a standard code that could be
available for any database, and i don't want to use oracle BLOB
datype,but instead the standard Blob java datatype..
here is the code i'm trying to execute, is it correct? can somebody
write to me please, a sample code with Blob instead of BLOB?:
db = DBBroker.getInstance().getConnection();
con = db.getConnection();
stmt = con.createStatement();
...
java.sql.Blob blob =(java.sql.Blob) rset.getBlob("FILE_ATTACHMENT");
OutputStream outstream =
(OutputStream)blob.setBinaryStream(blob.position(blob,1));
......
----END of code
the application has a problem when executing the second instruction
(OutputStrem......)
thank you very mauch for your help
otto
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Othman HADDAD INET: ohaddad_at_neomalogic.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Tue May 27 2003 - 09:09:45 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).