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
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3862283#3862283
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3862283
-------------------------------------------------------
The SF.Net email is sponsored by: Beat the post-holiday blues
Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
