1 Reply Latest reply on Jan 8, 2004 8:03 AM by Adrian Brock

    Probleme when sending large messages

    axene Newbie

      hi,

      I have a problem when sending too large JMS messages... It seems to block when the message is persisted by Jboss 3.2.2 in my oracle database.
      I use Oracle 8.i with the thin oracle 9.0.1.4 driver.

      With short messages, It runs perfectly !!!!

      The error trace is:

      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:541)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:245)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:476)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnectionPool.java:323)
      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:603)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.broadcastConnectionError(BaseWrapperManagedConnection.java:318)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.connectionError(BaseWrapperManagedConnection.java:303)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:791)
      at org.jboss.resource.adapter.jdbc.WrappedStatement.checkException(WrappedStatement.java:767)
      at org.jboss.resource.adapter.jdbc.WrappedStatement.close(WrappedStatement.java:56)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:790)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:730)
      at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:44)
      at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:145)
      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.oil.OILServerILService$Client.run(OILServerILService.java:253)
      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:187)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:229)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:342)
      at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1438)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:241)
      ... 23 more
      08:53:42,237 ERROR [STDERR] java.sql.SQLException: Closed Connection
      08:53:42,237 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:187)
      08:53:42,237 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:229)
      08:53:42,237 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:292)
      08:53:42,237 ERROR [STDERR] at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1364)
      08:53:42,237 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.rollback(LocalManagedConnection.java:117)
      08:53:42,237 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.rollback(TxConnectionManager.java:820)
      08:53:42,237 ERROR [STDERR] at org.jboss.tm.TransactionImpl.rollbackResources(TransactionImpl.java:1660)
      08:53:42,237 ERROR [STDERR] at org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:454)
      08:53:42,237 ERROR [STDERR] at org.jboss.tm.TxManager.rollback(TxManager.java:264)
      08:53:42,237 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager$TransactionManagerStrategy.endTX(PersistenceManager.java:174)
      08:53:42,237 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:756)
      08:53:42,237 ERROR [STDERR] at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:44)
      08:53:42,237 ERROR [STDERR] at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:145)
      08:53:42,237 ERROR [STDERR] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:407)
      08:53:42,237 ERROR [STDERR] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:383)
      08:53:42,237 ERROR [STDERR] at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:136)
      08:53:42,237 ERROR [STDERR] at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:162)
      08:53:42,237 ERROR [STDERR] at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:270)
      08:53:42,237 ERROR [STDERR] at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:136)
      08:53:42,237 ERROR [STDERR] at org.jboss.mq.il.oil.OILServerILService$Client.run(OILServerILService.java:253)
      08:53:42,237 ERROR [STDERR] at java.lang.Thread.run(Thread.java:534)
      08:53:42,237 WARN [OILServerILService] Client request resulted in a server exception:
      org.jboss.mq.SpyJMSException: Could not store message: 5 msg=4 hard NOT_STORED PERSISTENT queue=QUEUE.OutputSolQueue priority=4 hashCode=22263156; - nested throwable: (java.sql.SQLException: Io exception: Connection reset)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:745)
      at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:44)
      at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:145)
      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.oil.OILServerILService$Client.run(OILServerILService.java:253)
      at java.lang.Thread.run(Thread.java:534)
      Caused by: java.sql.SQLException: Io exception: Connection reset
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:187)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:229)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:342)
      at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2044)
      at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1950)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2591)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:452)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:321)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:783)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:730)
      ... 10 more
      08:53:42,487 WARN [OILServerILService] Connection failure (1).
      java.net.SocketException: Connection reset
      at java.net.SocketInputStream.read(SocketInputStream.java:168)
      at java.io.BufferedInputStream.fill(BufferedInputStream.java:183)
      at java.io.BufferedInputStream.read(BufferedInputStream.java:201)
      at java.io.ObjectInputStream$PeekInputStream.peek(ObjectInputStream.java:2133)
      at java.io.ObjectInputStream$BlockDataInputStream.readBlockHeader(ObjectInputStream.java:2313)
      at java.io.ObjectInputStream$BlockDataInputStream.refill(ObjectInputStream.java:2380)
      at java.io.ObjectInputStream$BlockDataInputStream.read(ObjectInputStream.java:2452)
      at java.io.ObjectInputStream$BlockDataInputStream.readByte(ObjectInputStream.java:2601)
      at java.io.ObjectInputStream.readByte(ObjectInputStream.java:845)
      at org.jboss.mq.il.oil.OILServerILService$Client.run(OILServerILService.java:210)
      at java.lang.Thread.run(Thread.java:534)
      



      Many thanks,
      AX