2 Replies Latest reply: Jul 30, 2013 9:49 PM by 1e7b01e9-49c9-4d0c-bb0e-ec6c0608ded8 RSS

    Facing problem with JDBC connection

    1e7b01e9-49c9-4d0c-bb0e-ec6c0608ded8

      Hi All,

       

      We are facing problem with JDBC connections in our production systems. We have configured for a datasource following connection pool values,

      Initial Capacity:30

      Maximum Capacity:50

      Minimum Capacity:30

       

      But we are seeing only Active connections as 0 or 1 even when we restart or reset the datasource.

      We have tried dbping telnet and pinging the database for which we have got success, Even when we test the datasource, It is going fine. But we are getting stuck threads with these connections because of no response. I am posting the JDBC stack trace below which is observed in server logs followed by stuck threads,

       

      ####<29-Jul-2013 06:04:22 o'clock BST> <Warning> <JDBC> <URL> <Server_name> <[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1375074262567> <BEA-001153> <Forcibly releasing inactive/harvested connection "[weblogic.jdbc.wrapper.JTAConnection_weblogic_jdbc_wrapper_XAConnection_oracle_jdbc_driver_LogicalConnection-OraOSBMetaXADataSource-IOS01U-6, oracle.jdbc.driver.LogicalConnection@200e200e]" back into the data source connection pool "OraOSBMetaXADataSource-IOS01U", currently reserved by: java.lang.Exception

              at weblogic.jdbc.common.internal.ConnectionEnv.setup(ConnectionEnv.java:356)

              at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:364)

              at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:471)

              at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:363)

              at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:125)

              at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:77)

              at weblogic.jdbc.jta.DataSource.getXAConnectionFromPool(DataSource.java:1751)

              at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1515)

              at weblogic.jdbc.jta.DataSource.getConnectionInternal(DataSource.java:478)

              at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:462)

              at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:512)

              at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:498)

              at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491)

              at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:123)

              at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)

              at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:330)

              at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:293)

              at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:565)

              at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1508)

              at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:305)

              at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:579)

              at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)

              at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)

              at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253)

              at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)

              at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)

              at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.cursorSelectAllRows(DatasourceCallQueryMechanism.java:75)

              at org.eclipse.persistence.queries.CursoredStreamPolicy.execute(CursoredStreamPolicy.java:64)

              at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:408)

              at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1081)

              at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)

              at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1040)

              at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:392)

              at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2831)

              at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)

              at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)

              at oracle.tip.adapter.db.inbound.DestructivePollingStrategy.poll(DestructivePollingStrategy.java:456)

              at oracle.tip.adapter.db.InboundWork.runOnce(InboundWork.java:747)

              at oracle.tip.adapter.db.InboundWork.run(InboundWork.java:620)

              at oracle.tip.adapter.db.inbound.InboundWorkWrapper.run(InboundWorkWrapper.java:43)

              at weblogic.work.ContextWrap.run(ContextWrap.java:41)

              at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)

              at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

              at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

      .>