| Author |
Hide log error
|
Jaime Amat
Greenhorn
Joined: Feb 03, 2006
Posts: 1
|
|
Hi all, I am using WS 5 with a DataSource that connects to a Oracle DDBB. The DDBB is shut down every night to do a backup. Our application has to call a PL from the DDBB every 15 seconds. During the time the DDBB is shutdown due to this backup, I get in the log the following trace: [2/02/06 18:43:23:812 CET] 344902 FreePool E J2CA0046E: El m�todo createManagedConnctionWithMCWrapper ha obtenido una excepci�n al crear la ManagedConnection para el recurso jdbc/aire, generando ResourceAllocationException. Excepci�n original: com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a PooledConnection from the DataSource. at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:251) at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:172) at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:182) at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:663) at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:189) at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:503) at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1106) at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:897) at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1065) at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:560) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:374) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:205) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:296) at aire.bbdd.ConnectionPool.getConexionActual(ConnectionPool.java:61) at aire.bbdd.ConexionActual.<init>(ConexionActual.java:31) at aire.batch.Engine.chequeaProcesos(Engine.java:68) at aire.batch.Engine.start(Engine.java:135) at aire.batch.Engine.run(Engine.java:53) at java.lang.Thread.run(Thread.java:512) ---- Begin backtrace for nested exception java.sql.SQLException: Excepci�n de E/S: The Network Adapter could not establish the connection at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:109) at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:643) at java.security.AccessController.doPrivileged(Native Method) at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:688) at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:189) at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:513) at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1169) at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:974) at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1122) at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:601) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:460) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:233) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:296) at aire.bbdd.ConnectionPool.getConexionActual(ConnectionPool.java:66) at aire.bbdd.ConexionActual.<init>(ConexionActual.java:32) at aire.batch.Engine.chequeaProcesos(Engine.java:104) at aire.batch.Engine.start(Engine.java:137) at aire.batch.Engine.run(Engine.java:55) at java.lang.Thread.run(Thread.java:514) at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:601) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:460) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:233) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:296) at aire.bbdd.ConnectionPool.getConexionActual(ConnectionPool.java:66) at java.lang.Thread.run(Thread.java:514) Next Linked Exception: java.sql.SQLException: Excepci�n de E/S: The Network Adapter could not establish the connection at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:109) at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:643) at java.security.AccessController.doPrivileged(Native Method) at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:688) at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:189) at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:513) at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1169) at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:974) at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1122) at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:601) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:460) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:233) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:296) at aire.bbdd.ConnectionPool.getConexionActual(ConnectionPool.java:66) at aire.bbdd.ConexionActual.<init>(ConexionActual.java:32) at aire.batch.Engine.chequeaProcesos(Engine.java:104) at aire.batch.Engine.start(Engine.java:137) at aire.batch.Engine.run(Engine.java:55) at java.lang.Thread.run(Thread.java:514) at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:601) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:460) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:233) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:296) at aire.bbdd.ConnectionPool.getConexionActual(ConnectionPool.java:66) at java.lang.Thread.run(Thread.java:514) [2/02/06 18:43:24:031 CET] 344902 ConnectionMan E J2CA0020E: El gestor de agrupaciones de conexiones no ha podido asignar una conexi�n gestionada: javax.resource.spi.ResourceAllocationException: Caught ResourceException thrown during creation of the ManagedConnection. at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1122) at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:601) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:460) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:233) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:296) at aire.bbdd.ConnectionPool.getConexionActual(ConnectionPool.java:66) at aire.bbdd.ConexionActual.<init>(ConexionActual.java:32) at aire.batch.Engine.chequeaProcesos(Engine.java:104) at aire.batch.Engine.start(Engine.java:137) at aire.batch.Engine.run(Engine.java:55) at java.lang.Thread.run(Thread.java:514) at aire.batch.Engine.run(Engine.java:55) at java.lang.Thread.run(Thread.java:514) . This is ok because the DDBB is shutdown, and it is not possible to get a connection from the DDBB. I would like to hide this trace. For this I have located the line where this log is displayed: try { dataSource.getConnection(); => The log is displayed } catch (Exception e) { ... => Then it enters in this part of the code } So I am not able to hide this log!!! Does anyone how I could hide this log? Tnak you very much in advance. Regards, Jaime
|
 |
 |
|
|
subject: Hide log error
|
|
|