This discussion is archived
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 Newbie
Currently Being Moderated

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)

.>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points