1 Reply Latest reply on May 19, 2005 10:26 PM by genman

    could not post message greater than 10kb on to a durable top

    mehercharan


      Hi All,
      I need a help from u guys.
      I have a posting Xml messages to jms topic as a durable subscription.
      Messages less than 8kb size are persisted property and consumed. Messages than 10kb cannot be posted . I am using Oracle thin driver

      How do i insert large messages . Please help me out.
      its giving the following stack trace:


      Stack Trace:

      22:31:35,015 WARN [JBossManagedConnectionPool] Exception destroying ManagedConn
      ection org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEven
      tListener@18eabf6[state=DESTROYED mc=org.jboss.resource.adapter.jdbc.local.Local
      ManagedConnection@1b7a553 handles=0 lastUse=1116522010046 permit=true trackByTx=
      false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePoo
      l@1c71508 context=org.jboss.resource.connectionmanager.InternalManagedConnection
      Pool@135d18b]
      org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (ja
      va.sql.SQLException: Io exception: Connection reset by peer: socket write error)

      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkExc
      eption(BaseWrapperManagedConnection.java:572)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(
      BaseWrapperManagedConnection.java:276)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.do
      Destroy(InternalManagedConnectionPool.java:535)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.re
      turnConnection(InternalManagedConnectionPool.java:317)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BaseP
      ool.returnConnection(JBossManagedConnectionPool.java:552)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.returnMan
      agedConnection(BaseConnectionManager2.java:455)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$BaseConne
      ctionEventListener.connectionErrorOccurred(BaseConnectionManager2.java:816)
      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnection
      EventListener.connectionErrorOccurred(TxConnectionManager.java:596)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.broadcas
      tConnectionError(BaseWrapperManagedConnection.java:349)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.connecti
      onError(BaseWrapperManagedConnection.java:334)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(Wrap
      pedConnection.java:790)
      at org.jboss.resource.adapter.jdbc.WrappedStatement.checkException(Wrapp
      edStatement.java:823)
      at org.jboss.resource.adapter.jdbc.WrappedStatement.close(WrappedStateme
      nt.java:79)
      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:3
      8)
      at org.jboss.mq.server.SelectorPersistentQueue.addMessage(SelectorPersis
      tentQueue.java:69)
      at org.jboss.mq.server.JMSTopic.addMessage(JMSTopic.java:333)
      at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationMa
      nager.java:402)
      at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationMa
      nager.java:378)
      at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerI
      nterceptorSupport.java:136)
      at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecu
      rityInterceptor.java:153)
      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.uil2.ServerSocketManagerHandler.handleMsg(ServerSocke
      tManagerHandler.java:86)
      at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.j
      ava:356)
      at org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:377)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExec
      utor.java:748)
      at java.lang.Thread.run(Thread.java:536)
      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:272)
      ... 27 more



      Thanks and regards,
      Meher charan.p