Uploaded image for project: 'IronJacamar'
  1. IronJacamar
  2. JBJCA-1314

Log datasource name in warn message when Network Adapter fails to establish connection with database.

    XMLWordPrintable

Details

    Description

      When there's following log statement in "server.log":

      WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (JCA PoolFiller) IJ000610: Unable to fill pool: javax.resource.ResourceException: Could not create connection
              at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:331)
              at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:288)
              at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:834) [ironjacamar-core-impl-1.0.28.Final-redhat-1.jar:1.0.28.Final-redhat-1]
              at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.fillToMin(SemaphoreArrayListManagedConnectionPool.java:775) [ironjacamar-core-impl-1.0.28.Final-redhat-1.jar:1.0.28.Final-redhat-1]
              at org.jboss.jca.core.connectionmanager.pool.mcp.PoolFiller.run(PoolFiller.java:97) [ironjacamar-core-impl-1.0.28.Final-redhat-1.jar:1.0.28.Final-redhat-1]
              at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_80]
      Caused by: java.sql.SQLRecoverableException: I/O-Fehler: The Network Adapter could not establish the connection
              at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:517)
              at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:557)
              at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:233)
              at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:29)
              at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:556)
              at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:303)
              ... 5 more
      Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
              at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:389)
              at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:431)
              at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:882)
              at oracle.net.ns.NSProtocol.connect(NSProtocol.java:267)
              at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1625)
              at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:365)
              ... 10 more
      

      With the above warn message how to figure which DB connection could not be established with out testing connection using CLI or management console.

      Attachments

        Activity

          People

            rhn-engineering-lgao Lin Gao
            rhn-engineering-lgao Lin Gao
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: