Blob update issue in 3.2.1

[svdath]

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

[anil.saldhana]

Vinay,
it may be an issue with the driver being used. Have you tried with newer versions of the JDBC driver for Oracle?

Also, here is a link that talks about storing/retrieving blobs using JDBC.

http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1105496344:633417&page=ibp_iclient_blob

Also the JDBC doc shows you how to store a blob:
http://java.sun.com/j2se/1.4.2/docs/guide/jdbc/blob.html

Try it out.

[pablojavierpy]

Also, make sure you are not using Thin driver (use the OCI one), otherwise it would not work with large BLOBs.