1 Reply Latest reply on Mar 15, 2006 12:03 PM by Joan Horta Tosas

    Accessing BLOB from oracle.

    ab cd Newbie

      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.

        • 1. Re: Accessing BLOB from oracle.
          Joan Horta  Tosas Novice

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