java.sql.SQLException: ORA-01407:

Hello,
I am updating the BLOB in Oracle and using setBinaryStream(1,stream,length)
I get the following error. It happens in some cases only....

---java.sql.SQLException: ORA-01407: cannot update ("SCHEMA"."BLOB"."BLOB") to NULL

here is the code I used to get the stream
********************************
ByteArrayOutputStream byteStream = new ByteArrayOutputStream();
ObjectOutputStream objStream = new ObjectOutputStream(byteStream);
objStream.writeObject(obj);
objStream.flush();
System.out.println("objStream"+objStream.toString());
System.out.println("byteStream-------------------"+byteStream.toString());
byte[] byteArray = (byte[])(byteStream.toByteArray());
ByteArrayInputStream stream = new ByteArrayInputStream(byteArray);

Hi Surya,

I think you are missing a couple of steps, and maybe have a couple backwards (or maybe you didn't post all of your code???). I cannot see where you are defining your blob locator, nor the information that you plan on sending.

If you could post all of your code that pertains to the blob, I bet we could get you up and running in no time!

Here is some code I found on Sun's forum, commented with step-by-step instructions:

BLOB blob;
    File binFile;
    FileInputStream instream;
    OutputStream outstream;
    try {
      //Set AutoCommit to OFF - required by BLOB locking mechanism.
      conn.setAutoCommit(false);
      //Create a statement.
      Statement stmt = conn.createStatement();
      //Insert an empty BLOB locator.
      stmt.execute("INSERT INTO MEDIA_STORE VALUES('THX','DVD-VOB',empty_blob())");
      //Execute the query and lock the BLOB row.
      ResultSet rset = stmt.executeQuery("SELECT MDATA FROM MEDIA_STORE WHERE MNAME='THX' FOR UPDATE");
      rset.next();
      //Get the BLOB locator.
      blob = ((OracleResultSet)rset).getBLOB(1);
      //Get the large binary media file.
      binFile = new File("D:\\THX.VOB");
      instream = new FileInputStream(binFile);
      //Insert to the BLOB from an output stream.
      outstream = blob.getBinaryOutputStream();
      //Read the input stream and write the output stream by chunks.
      byte[] chunk = new byte[blob.getChunkSize()];
      int i=-1;
      System.out.println("Loading");
      while((i = instream.read(chunk))!=-1) {
         outstream.write(chunk,0,i); System.out.print('.');
      }
      //Close the input and output stream.
      instream.close();
      outstream.close();
      //Close the statement.
      stmt.close();
    }
    catch(SQLException e) {
      e.printStackTrace();
    }

You need to import part of the oracle.sql package.

I hope this helps.

Jules

Surya,
Pardon me if I am stating the obvious, but according to the error message you have posted, column BLOB, in table BLOB, owned by user SCHEMA is a mandatory (or "not null") column, and you are trying to set it to null.

Good Luck,
Avi.

thanks for your help !

Your thread was greatly helpfull.