Sql Exception when sending messages
nollario Sep 24, 2003 8:06 AMHi!
I receive the following exceptions when sending messages to a queue. Any ideas how to fix this?
Thanks
Christian
15:57:03,437 ERROR [STDERR] java.sql.SQLException: JZ0C0: Verbindung wurde bereits geschlossen.
15:57:03,437 ERROR [STDERR] at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:549)
15:57:03,437 ERROR [STDERR] at com.sybase.jdbc2.jdbc.SybConnection.checkConnection(SybConnection.java:2101)
15:57:03,437 ERROR [STDERR] at com.sybase.jdbc2.jdbc.SybConnection.rollback(SybConnection.java:1054)
15:57:03,437 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.rollback(LocalManagedConnection.java:116)
15:57:03,437 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.rollback(TxConnectionManager.jav
a:859)
15:57:03,437 ERROR [STDERR] at org.jboss.tm.TransactionImpl.rollbackResources(TransactionImpl.java:1647)
15:57:03,437 ERROR [STDERR] at org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:449)
15:57:03,437 ERROR [STDERR] at org.jboss.tm.TxManager.rollback(TxManager.java:263)
15:57:03,437 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager$TransactionManagerStrategy.endTX(PersistenceManager.java:174)
15:57:03,437 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:715)
15:57:03,437 ERROR [STDERR] at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:39)
15:57:03,437 ERROR [STDERR] at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:133)
15:57:03,437 ERROR [STDERR] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:409)
15:57:03,437 ERROR [STDERR] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:385)
15:57:03,437 ERROR [STDERR] at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:135)
15:57:03,437 ERROR [STDERR] at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:162)
15:57:03,437 ERROR [STDERR] at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:234)
15:57:03,437 ERROR [STDERR] at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:137)
15:57:03,437 ERROR [STDERR] at org.jboss.mq.il.oil.OILServerILService$Client.run(OILServerILService.java:253)
15:57:03,437 ERROR [STDERR] at java.lang.Thread.run(Thread.java:534)
15:57:03,437 WARN [JBossManagedConnectionPool] ResourceException cleaning up ManagedConnection:org.jboss.resource.JBossResourceException: C
ould not cleanup: ; - nested throwable: (java.sql.SQLException: JZ0C0: Verbindung wurde bereits geschlossen.)
15:57:03,437 INFO [JBossManagedConnectionPool] Exception destroying ManagedConnection
org.jboss.resource.JBossResourceException: Could not cleanup: ; - nested throwable: (java.sql.SQLException: JZ0C0: Verbindung wurde bereits
geschlossen.)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.cleanup(BaseWrapperManagedConnection.java:195)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:225)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:394)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnectionPool.java:270)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool.returnConnection(JBossManagedConnectionPool.java:701)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection(BaseConnectionManager2.java:464)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TxRemover.afterCompletion(TxConnectionManager.
java:669)
at org.jboss.tm.TransactionImpl.doAfterCompletion(TransactionImpl.java:1325)
at org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:451)
at org.jboss.tm.TxManager.rollback(TxManager.java:263)
at org.jboss.mq.pm.jdbc2.PersistenceManager$TransactionManagerStrategy.endTX(PersistenceManager.java:174)
at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:715)
at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:39)
at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:133)
at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:409)
at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:385)
at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:135)
at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:162)
at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:234)
at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:137)
at org.jboss.mq.il.oil.OILServerILService$Client.run(OILServerILService.java:253)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: JZ0C0: Verbindung wurde bereits geschlossen.
at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:549)
at com.sybase.jdbc2.jdbc.SybConnection.checkConnection(SybConnection.java:2101)
at com.sybase.jdbc2.jdbc.SybConnection.getTransactionIsolation(SybConnection.java:1356)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.cleanup(BaseWrapperManagedConnection.java:188)
... 21 more
15:57:03,453 WARN [OILServerILService] Client request resulted in a server exception:
org.jboss.mq.SpyJMSException: Could not store message: 0 msg=0 hard NOT_STORED PERSISTENT queue=QUEUE.A priority=4 hashCode=26461030; - nest
ed throwable: (java.sql.SQLException: JZ006: IOException: com.sybase.jdbc2.jdbc.SybConnectionDeadException: JZ0C0: Verbindung wurde bereits
geschlossen. wurde abgefangen)
at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:704)
at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:39)
at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:133)
at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:409)
at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:385)
at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:135)
at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:162)
at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:234)
at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:137)
at org.jboss.mq.il.oil.OILServerILService$Client.run(OILServerILService.java:253)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: JZ006: IOException: com.sybase.jdbc2.jdbc.SybConnectionDeadException: JZ0C0: Verbindung wurde bereits gesc
hlossen. wurde abgefangen
at com.sybase.jdbc2.jdbc.ErrorMessage.createIOEKilledConnEx(ErrorMessage.java:775)
at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:816)
at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3479)
at com.sybase.jdbc2.tds.Tds.cancel(Tds.java:1528)
at com.sybase.jdbc2.tds.Tds.cancel(Tds.java:1457)
at com.sybase.jdbc2.jdbc.SybStatement.doCancel(SybStatement.java:595)
at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1739)
at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1685)
at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:104)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:308)
at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:742)
at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:689)