0 Replies Latest reply on May 11, 2005 6:59 AM by vin jain

    org.jboss.resource.JBossResourceException: Could not....

    vin jain Newbie

      Hi,

      We are in an performance testing phase of our product.
      So , while testing for multiple user we got this exception.

      org.jboss.resource.JBossResourceException: Could not create connection; - nested
      throwable: (java.sql.SQLException: Io exception: Connection refused(DESCRIPTION
      =(TMP=)(VSNNUM=153092352)(ERR=12519)(ERROR_STACK=(ERROR=(CODE=12519)(EMFI=4)))))
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c
      reateManagedConnection(LocalManagedConnectionFactory.java:161)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.cr
      eateConnectionEventListener(InternalManagedConnectionPool.java:508)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.ge
      tConnection(InternalManagedConnectionPool.java:207)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BaseP
      ool.getConnection(JBossManagedConnectionPool.java:534)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManage
      dConnection(BaseConnectionManager2.java:396)
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedCo
      nnection(TxConnectionManager.java:299)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
      onnection(BaseConnectionManager2.java:448)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio
      nManagerProxy.allocateConnection(BaseConnectionManager2.java:838)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Wrapp
      erDataSource.java:102)

      We, are using Oracle9i and the parameters in init.ora file are :
      open_cursors = 250
      processes = 200
      transactions = 200
      sessions = 200

      I have given Min Pool Size as 50 and Max-pool-size as 200 in deploy/*DS.xml.

      After doin all this also we dont have any solution.

      Any help would be Great..
      thanks in advance..
      jainy