"java.sql.SQLException: Connection closed" Exception Thrown in Engine Logs when SQLQuery Component is Used (Doc ID 1351525.1)

Last updated on APRIL 17, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.