Hi 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!
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3868458#3868458
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3868458
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
