XSU catch exception on Weblogic 6.1
Problem Description
We have encountered the following exception during calling XSU delete process under Weblogic application on Windows 2000 Professional SP2 machine.
Error Stack
weblogic.jdbc.rmi.SerialConnection:
oracle.xml.sql.OracleXMLSQLException: weblogic.jdbc.rmi.SerialConnection
at oracle.xml.sql.dml.OracleXMLSave.saveXML(OracleXMLSave.java:2088)
at oracle.xml.sql.dml.OracleXMLSave.deleteXML(OracleXMLSave.java:1686)
at smartics.rop.arch.db.helper.XSUUtilities.XMLDelete(XSUUtilities.java:251)
at smartics.rop.arch.db.TranHandler.doDelete(TranHandler.java:306)
at smartics.rop.arch.db.TranHandler.handleTran(TranHandler.java:227)
at smartics.rop.arch.db.helper.ProcessRequestHandler.execute(ProcessRequestHandler.java:342)
at smartics.rop.arch.db.DBSyncSess.SyncDB(DBSyncSess.java:170)
at smartics.rop.arch.db.DBSyncBean.SyncData(DBSyncBean.java:215)
at smartics.rop.arch.trial.servlet.DBSyncServlet.service(DBSyncServlet.java:120)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:265)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2495)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2204)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
Technical Detail
The Database connection is lookup from Weblogic JNDI DataSource. And the connection will pass to XSU to do the delete processing.
This problem only happens when using DataSource lookup from weblogic JNDI.
It works fine on using direct jdbc connection.
Background Info
OS & Software Version:
Windows 2000 Professional SP2
Weblogic Application Server 6.1 SP1
XML-SQL Utility (XSU) packaged in Oracle 8i (8.1.7)