Hi -
Has anyone seen the following 'Connection is closed' issue with the JDBC adapter? (This was an outbound adapter.) Once it happens it just keeps happening and happening, it doesn't appear that the datasource is purged or anything. I can't determine root cause and it certainly doesn't happen every time. It happened this morning after being fairly idle overnight.
Additionally, an inbound JDBC adapter that shared the same DataSource stopped polling last night, and I'm assuming it was for the same reason.
Any tips?
-jb
[code]
Caused by: com.ibm.websphere.sca.ServiceUnavailableException: javax.resource.ResourceException: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.: caused by: javax.resource.ResourceException: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
at com.ibm.ws.sca.internal.j2c.J2CMethodBindingImpl.invoke(J2CMethodBindingImpl.java(Compiled Code))
at com.ibm.ws.sca.internal.j2c.J2CInterfaceBindingImpl.invoke(J2CInterfaceBindingImpl.java(Compiled Code))
at com.ibm.ws.sca.internal.j2c.handler.J2CImportHandler.invokeDynamicImport(J2CImportHandler.java(Compiled Code))
at com.ibm.ws.sca.internal.j2c.handler.J2CImportHandler.processMessage(J2CImportHandler.java(Compiled Code))
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessageWithPCI(MessageDispatcherImpl.java(Compiled Code))
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessage(MessageDispatcherImpl.java(Compiled Code))
at com.ibm.ws.sca.internal.message.impl.ManagedMessageImpl.process(ManagedMessageImpl.java(Compiled Code))
... 88 more
Caused by: javax.resource.ResourceException: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
at com.ibm.j2ca.jdbc.JDBCDBOperationHandler.createPreparedStatement(JDBCDBOperationHandler.java(Compiled Code))
at com.ibm.j2ca.jdbc.JDBCDBOperationHandler.executeSQL(JDBCDBOperationHandler.java(Compiled Code))
at com.ibm.j2ca.jdbc.commands.JDBCCreateCommand.execute(JDBCCreateCommand.java(Compiled Code))
at com.ibm.j2ca.extension.commandpattern.Command.execute(Command.java(Compiled Code))
at com.ibm.j2ca.extension.commandpattern.Interpreter.executeWithChildren(Interpreter.java(Compiled Code))
at com.ibm.j2ca.extension.commandpattern.Interpreter.execute(Interpreter.java(Inlined Compiled Code))
at com.ibm.j2ca.jdbc.JDBCInteraction.execute(JDBCInteraction.java(Compiled Code))
... 95 more
Caused by: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.runtimeXIfNotClosed(WSJdbcConnection.java:2432)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
... 102 more
[/code]