Accessing BLOB from oracle.

[ram78]

My Database was Oracle and i was using Blobs previously i was using weblogic in that using weblogic.jdbc.vendor.oracle.OracleThinBlob i was able to insert and get the Blob how can i do with Jboss 4.0.3 SP1.Any help will be very greatful.

[raist_majere]

If you have the JDBC 3 driver for Oracle, then you can use J2SE 1.4 java.sql.Blob Following is the code I use in an app to insert a new blob into an existing record (before this insertion the blob i think was null in that record).

Statement st = null;
ResultSet rs = null;
try {
 conn.setAutoCommit(false);
 st=conn.createStatement();
 st.executeUpdate("update estadistica set fitxer=empty_blob() where id_estadistica="+idEstadistica);
 st.close();
 st=conn.createStatement();
 rs=st.executeQuery("select fitxer from estadistica where id_estadistica="+idEstadistica);
 if (rs.next()) {
 rs.getBlob("FITXER").setBytes(1,bytes);
 }
 conn.commit();
} catch ...