Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> oracle BLOB and java.sql.Blob

oracle BLOB and java.sql.Blob

From: Othman HADDAD <ohaddad_at_neomalogic.com>
Date: Tue, 27 May 2003 06:09:45 -0800
Message-ID: <F001.005A32C4.20030527060945@fatcity.com>


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

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue May 27 2003 - 09:09:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US