2 Replies Latest reply: Aug 9, 2012 12:47 AM by NEFTALY GARCIA RSS

    [JBossManagedConnectionPool] Throwable while attempting to get a new connection oracle

    NEFTALY GARCIA Newbie

      After one week that jboss is working, its crash down, sending the next exception: Software jboss5.0 jdk1.6 ojdbc14.jar

          WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
          org
      .jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: Connection reset)
          at org
      .jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
          at org
      .jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
          at org
      .jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)
          at org
      .jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:267)
          at org
      .jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:622)
          at org
      .jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
          at org
      .jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
          at org
      .jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
          at org
      .jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
          at org
      .jboss.resource.adapter.jdbc
      .WrapperDataSource.getConnection(WrapperDataSource.java:89)
          at com
      .genexus.db.driver.GXConnection.connectJDBCDataSource(Unknown Source)
      ........  
          Caused
      by: java.sql.SQLException: Io exception: Connection reset
          at oracle
      .jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
          at oracle
      .jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
          at oracle
      .jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
          at oracle
      .jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
          at oracle
      .jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
          at oracle
      .jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
          at oracle
      .jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
          at oracle
      .jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
          at org
      .jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:207)
         
      ... 58 more

      Oracle-ds.xml:

       

       

      - <datasources>

       

       

      - <local-tx-datasource>

       

      <jndi-name>ppacfp</jndi-name>

        <connection-url>jdbc:oracle:thin:@xx.x.xx.xxx:xxx:nodo</connection-url>

        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

        <user-name>pacfp</user-name>

        <password>PASSWORD</password>

        <connection-property name="fixedString">true</connection-property>

        - <metadata>

       

      <type-mapping>Oracle9i</type-mapping>

       

      </metadata>

      </local-tx-datasource>

      </datasources>