[jboss-jira] [JBoss JIRA] (JBJCA-1314) Log datasource name in warn message when Network Adapter fails to establish connection with database.

[Jesper Pedersen (JIRA)]

     [ https://issues.jboss.org/browse/JBJCA-1314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesper Pedersen updated JBJCA-1314:
-----------------------------------
    Issue Type: Task  (was: Feature Request)
      Priority: Minor  (was: Major)
        Labels:   (was: jboss l)


> Log datasource name in warn message when Network Adapter fails to establish connection with database.
> -----------------------------------------------------------------------------------------------------
>
>                 Key: JBJCA-1314
>                 URL: https://issues.jboss.org/browse/JBJCA-1314
>             Project: IronJacamar
>          Issue Type: Task
>          Components: Core
>         Environment: Red Hat JBoss Enterprise Application Platform 
>            Reporter: Lin Gao
>            Assignee: Lin Gao
>            Priority: Minor
>             Fix For: WildFly/IronJacamar 1.3.3.Final, 1.2.7.Final
>
>
> When there's following log statement in "server.log":
> {code}
> 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
> {code}
> With the above warn message how to figure which DB connection could not be established with out testing connection using CLI or management console.  



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)