"java.sql.SQLException: Connection closed" Exception Thrown in Engine Logs when SQLQuery Component is Used
(Doc ID 1351525.1)
Last updated on JULY 18, 2024
Applies to:
Oracle Business Process Management Suite - Version 10.3.2 and laterInformation in this document applies to any platform.
Symptoms
The following error is thrown when the SQL query object with the query
"select CUSTOMERUSER.SYSTEM_DETAIL_SEQ.NEXTVAL as val from dual" is executed
java.sql.SQLException: Connection closed
at weblogic.jdbc.wrapper.JTAConnection.getXAConn(JTAConnection.java:187)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:64)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:92)
at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:482)
at fuego.jdbc.FaultTolerantConnection.prepareStatement(FaultTolerantConnection.java:553)
at fuego.sqlquery.Query.prepareStatement(Query.java:168)
at fuego.sqlquery.Query.getData(Query.java:51)
at fuego.sqlquery.SQLQueryObject$ResultSetIterator.<init>(SQLQueryObject.java:245 )
at fuego.sqlquery.SQLQueryObject.buildIterator(SQLQueryObject.java:213)
at fuego.sqlquery.SQLQueryObject.iterator(SQLQueryObject.java:161)
at fuego.util.ArrayUtils.collectionIterator(ArrayUtils.java:145)
at xobject.DBComponents.RequestSystemDetails.updateSysteminfotoDB(RequestSystemDetails.xcdl:22)
at customer.CustomerProcess.Default_1_0.Instance.CIL_createAccessRequest(Instance.xcdl:173)
at customer.CustomerProcess.Default_1_0.Instance.CIL_createAccessRequest(Instance.xcdl)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at fuego.server.execution.EngineExecutionContext.invokeMethodAsCil(EngineExecutio
nContext.java:1091)
... 102 more
.
.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |