why dont u check the sample code which is given in weblogic server 7.0 (I hope u r using that one.)
$WL_HOME\samples\server\src\examples\ejb20\blobClob > -----Original Message----- > From: A mailing list for Enterprise JavaBeans development > [mailto:[EMAIL PROTECTED] Behalf Of Harpreet Mittar > Sent: Friday, February 28, 2003 8:47 PM > 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".
