Probleme when sending large messages
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
