Re: Inserting BLOB in Oracle

[Shone Sadler]

If you are executing this within an application server and using a
datasource you will often get a ClassCastException because (depending on
the appserver/driver) the Application server does not give you direct
access to the actual Oracle JDBC objects.  Instead you deal with wrapper
classes that the app server uses for pooling.  I believe we had an issue
with this at one time within Weblogic and simply used reflection to
execute the getBinaryOutputStream(), which the wrapper class implemented
as well. Not a perfect work around.


Shone

-----Original Message-----
From: Harpreet Mittar [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 28, 2003 10:17 AM
To: [EMAIL PROTECTED]
Subject: Re: Inserting BLOB in Oracle
Importance: High


Thanx for the sample, but i have tried this.

It throws a ClassCastException exactly at the place where i try to cast
java.sql.Blob to oracle.sql.BLOB
Any inputs as to where i could be going wrong ?

Thanx..




                    "Szabolcs Nagy"
                    <[EMAIL PROTECTED]        To:
<[EMAIL PROTECTED]>
                    OLOGY.com>                        cc:
                                                      Subject:     RE:
Inserting BLOB in Oracle
                    02/28/2003 08:38 PM







I hope, it helps you...

Szabolcs



public void saveFile(String fileName, byte[] fileContent) {

Statement stmt = null;
Connection conn = null;
ResultSet rset = null;

try {
  conn = getConnection();

  stmt = conn.createStatement();
  stmt.execute("insert into ATTACHEDFILES (filename, filecontent) values
(' " + filename + "', EMPTY_BLOB())");

  String blobTrick = "select fileContent from ATTACHEDFILES where
filename = " + fileName;
  rset = stmt.executeQuery(blobTrick);
  if (rset.next()) {
    BLOB blob =
(BLOB)rset.getBlob(1);//((OracleResultSet)rset).getBLOB(1);
    OutputStream out = blob.getBinaryOutputStream();
    out.write(fileContent);
    out.close();
  }
}
catch (Exception e) {
  //handle exception
}
finally {
  try { if (stmt != null) stmt.close(); }
  catch (Exception e) {}
  try { if (conn != null) conn.close(); }
  catch (Exception e) {}
  }
}

Hi,
It would be of great help if somebody could share sample code for
inserting
a BLOB into Oracle through weblogic.

Thanx and Regards,
Harpreet.

==========================================================================To 
unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".