Harpreet which driver you are using ?
Shone Sadler
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
H.COM> cc: (bcc: ashwani.kalra/Polaris)
Sent by: A Subject: Re: Inserting BLOB in Oracle
mailing list for
Enterprise
JavaBeans
development
<[EMAIL PROTECTED]
A.SUN.COM>
02/28/2003 10:58
PM
Please respond to
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".
This e-Mail may contain proprietary and confidential information and is sent for the
intended recipient(s) only.
If by an addressing or transmission error this mail has been misdirected to you, you
are requested to delete this mail immediately.
You are also hereby notified that any use, any form of reproduction, dissemination,
copying, disclosure, modification,
distribution and/or publication of this e-mail message, contents or its attachment
other than by its intended recipient/s is strictly prohibited.
Visit Us at http://www.polaris.co.in
