JBossMQ and Oracle JMS Persistence
allosan Mar 2, 2005 3:42 AMHi all,
i'm usiong jboss 3.2.3 and i'm trying to set JBossMQ to use Oracle 9i instead of Hypersonic SQL as DB for jms persistence. I put oracle-jdbc2-service.xml in deploy/jms and changed the line
true
in conf/jboss-service.xml.
When the server startup all is right, it creates the table in the oracle db, but as soon as it has to write in those tables i receive this warn and then this error:
2005-03-02 09:39:58,483 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Exception destroying ManagedConnection
org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: Io exception: Connection reset by peer: socket write error)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:546)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:252)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:502)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnectionPool.java:326)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.returnConnection(JBossManagedConnectionPool.java:508)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection(BaseConnectionManager2.java:436)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$BaseConnectionEventListener.connectionErrorOccurred(BaseConnectionManager2.java:778)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionErrorOccurred(TxConnectionManager.java:615)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.broadcastConnectionError(BaseWrapperManagedConnection.java:325)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.connectionError(BaseWrapperManagedConnection.java:310)
at org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:793)
at org.jboss.resource.adapter.jdbc.WrappedStatement.checkException(WrappedStatement.java:802)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:328)
at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:783)
at org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1210)
at org.jboss.mq.server.MessageCache.saveToStorage(MessageCache.java:393)
at org.jboss.mq.server.MessageReference.makeSoft(MessageReference.java:250)
at org.jboss.mq.server.MessageCache.validateSoftReferenceDepth(MessageCache.java:328)
at org.jboss.mq.server.MessageCache.addInternal(MessageCache.java:127)
at org.jboss.mq.server.MessageCache.add(MessageCache.java:97)
at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:144)
at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:407)
at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:383)
at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:136)
at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:162)
at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:270)
at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:136)
at org.jboss.mq.il.jvm.JVMServerIL.addMessage(JVMServerIL.java:137)
at org.jboss.mq.Connection.sendToServer(Connection.java:1243)
at org.jboss.mq.SpySession.sendMessage(SpySession.java:732)
at org.jboss.mq.SpyQueueSender.internalSend(SpyQueueSender.java:118)
at org.jboss.mq.SpyQueueSender.send(SpyQueueSender.java:68)
at it.aica.syncServer.BaseMDB.sendMessage(BaseMDB.java:95)
at it.aica.syncServer.testUP.TestUpMDB.buildMessage(TestUpMDB.java:53)
at it.aica.syncServer.testUP.TestUpMDB.onMessage(TestUpMDB.java:26)
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:324)
at org.jboss.ejb.MessageDrivenContainer$ContainerInterceptor.invoke(MessageDrivenContainer.java:460)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
at org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor.invoke(MessageDrivenInstanceInterceptor.java:62)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:240)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
at org.jboss.ejb.plugins.RunAsSecurityInterceptor.invoke(RunAsSecurityInterceptor.java:90)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.MessageDrivenContainer.internalInvoke(MessageDrivenContainer.java:374)
at org.jboss.ejb.Container.invoke(Container.java:700)
at org.jboss.ejb.plugins.jms.JMSContainerInvoker.invoke(JMSContainerInvoker.java:824)
at org.jboss.ejb.plugins.jms.JMSContainerInvoker$MessageListenerImpl.onMessage(JMSContainerInvoker.java:1114)
at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:256)
at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:633)
at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:433)
at org.jboss.mq.SpySession.run(SpySession.java:298)
at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:180)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:732)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Io exception: Connection reset by peer: socket write error
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:704)
at oracle.jdbc.driver.OraclePreparedStatement.privateClose(OraclePreparedStatement.java:489)
at oracle.jdbc.driver.OraclePreparedStatement.close(OraclePreparedStatement.java:396)
at oracle.jdbc.driver.OracleConnection.close_statements(OracleConnection.java:2369)
at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1448)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:248)
... 57 more
2005-03-02 09:39:58,503 ERROR [STDERR] java.sql.SQLException: Io exception: Connection reset by peer: socket write error
2005-03-02 09:39:58,503 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
2005-03-02 09:39:58,503 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
2005-03-02 09:39:58,503 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
2005-03-02 09:39:58,503 ERROR [STDERR] at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1416)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.rollback(LocalManagedConnection.java:118)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.rollback(TxConnectionManager.java:832)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.tm.TransactionImpl.rollbackResources(TransactionImpl.java:1664)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:458)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.tm.TxManager.rollback(TxManager.java:264)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager$TransactionManagerStrategy.endTX(PersistenceManager.java:174)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1235)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.server.MessageCache.saveToStorage(MessageCache.java:393)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.server.MessageReference.makeSoft(MessageReference.java:250)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.server.MessageCache.validateSoftReferenceDepth(MessageCache.java:328)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.server.MessageCache.addInternal(MessageCache.java:127)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.server.MessageCache.add(MessageCache.java:97)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:144)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:407)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:383)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:136)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:162)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:270)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:136)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.il.jvm.JVMServerIL.addMessage(JVMServerIL.java:137)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.Connection.sendToServer(Connection.java:1243)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.SpySession.sendMessage(SpySession.java:732)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.SpyQueueSender.internalSend(SpyQueueSender.java:118)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.SpyQueueSender.send(SpyQueueSender.java:68)
2005-03-02 09:39:58,503 ERROR [STDERR] at it.aica.syncServer.BaseMDB.sendMessage(BaseMDB.java:95)
2005-03-02 09:39:58,503 ERROR [STDERR] at it.aica.syncServer.testUP.TestUpMDB.buildMessage(TestUpMDB.java:53)
2005-03-02 09:39:58,503 ERROR [STDERR] at it.aica.syncServer.testUP.TestUpMDB.onMessage(TestUpMDB.java:26)
2005-03-02 09:39:58,503 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2005-03-02 09:39:58,503 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2005-03-02 09:39:58,503 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2005-03-02 09:39:58,503 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.ejb.MessageDrivenContainer$ContainerInterceptor.invoke(MessageDrivenContainer.java:460)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor.invoke(MessageDrivenInstanceInterceptor.java:62)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:240)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.ejb.plugins.RunAsSecurityInterceptor.invoke(RunAsSecurityInterceptor.java:90)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.ejb.MessageDrivenContainer.internalInvoke(MessageDrivenContainer.java:374)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:700)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.ejb.plugins.jms.JMSContainerInvoker.invoke(JMSContainerInvoker.java:824)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.ejb.plugins.jms.JMSContainerInvoker$MessageListenerImpl.onMessage(JMSContainerInvoker.java:1114)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:256)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:633)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:433)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.mq.SpySession.run(SpySession.java:298)
2005-03-02 09:39:58,503 ERROR [STDERR] at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:180)
2005-03-02 09:39:58,503 ERROR [STDERR] at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:732)
2005-03-02 09:39:58,503 ERROR [STDERR] at java.lang.Thread.run(Thread.java:534)
Someone can tell me where is the problem?
Thanks all!