2 Replies Latest reply on Jan 19, 2005 6:28 AM by Pablo Javier Santa Cruz Cosp

    Blob update issue in 3.2.1

    Vinaydath Shivaprasad Newbie

      Hi,
      When i try to update a blob object in the Oracle 8i database, query is not updating anything. It works fine for reading but update is what is giving me lot of problem. The BLOB is a XML String.

      I am using the following piece of code. The worst part is that it does not throw any error. It just does not update anything in to the database. This code is working fine in WL7.0

      The XML printout is fine. I checked on the format.


      /* Update the Workflow XML into the DB */
      con = getConnection();
      con.setAutoCommit(true);
      str = "update T_WFL_WORKFLOW_INSTANCE set C_WWI_WORKFLOW_XML_INSTANCE=? "
      +"where C_WWI_WORKFLOW_INSTANCE_ID="
      + Integer.parseInt(strWorkflowInstanceId.substring(2));
      InputStream fin = BlobUtility.getInputStreamFromDom(doc);
      if (fin == null) {
      eCRMSuiteLogger.debug("fin is null");
      } else {
      eCRMSuiteLogger.debug("fin is not null");
      }

      stmt = con.prepareStatement(str);
      System.out.println("Size of the XML being updated:"+fin.available());
      stmt.setBinaryStream(1, fin, fin.available());
      stmt.execute();
      stmt.close();
      releaseConnection(con);



      -Vinay