Service Virtualization

javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!

Error Code: 0

    at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:517)

    at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:188)

    at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:277)

    at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294)

    at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:272)

    at com.itko.lisa.utils.JpaUtil.getEm(JpaUtil.java:1240)

    at com.itko.lisa.test.data.TestDataGenerator.ensureTestDataExists(TestDataGenerator.java:269)

    at com.itko.lisa.test.data.TestDataGenerator.getBuiltinPatterns(TestDataGenerator.java:255)

    at com.itko.lisa.coordinator.TestRegistryImpl.getBuiltInPatterns(TestRegistryImpl.java:3505)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

    at java.lang.reflect.Method.invoke(Unknown Source)

    at com.itko.lisa.net.RemoteMethodExec.execute(RemoteMethodExec.java:57)

    at com.itko.lisa.net.ServerRequestHandler.processRMIMessage(ServerRequestHandler.java:432)

    at com.itko.lisa.net.ServerRequestHandler.access$300(ServerRequestHandler.java:67)

    at com.itko.lisa.net.ServerRequestHandler$4.run(ServerRequestHandler.java:355)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask.run(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!

Error Code: 0

    at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:309)

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

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

    at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:584)

    at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206)

    at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:488)

    ... 21 more

Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!

    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)

    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:689)

    at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)

    at com.itko.lisa.utils.db.LisaWrappedDataSource.getConnection(LisaWrappedDataSource.java:32)

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

    ... 25 more

Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.

    at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1418)

    at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:606)

    at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:526)

    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:755)

    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:682)

    ... 28 more

Is this error on a fresh install or have you been using this env for some time and just started seeing these errors?

Also what database is this and version?

Just started seeing this error ..no clue why .

I believe I've seen a similar issue in the version you're using when the workstation doesn't have connectivity to the LISA database. In case the database is on a separate machine, can you verify that you're able to ping the IP of the machine where the database is installed, this may help confirm it's the same issue

Are you able to open the Lisa console & check the database connectivity under reports tab?

Please provide a screenshot of the same.

Is this the same error that RohanDoshi described in https://communities.ca.com/message/241834467? Unless it is, please elaborate about the differences? As mentioned in the other issue, this appears to be a DB connectivity problem, which can have multiple reasons. Among those are false DB user IDs, wrong password, host names that cannot be resolved by a name service (DNS), wrong/blocked port numbers, outdated/missing JDBC drivers. Please verify that your DB configuration in site.properties on the registry server is correct, and that the registry starts without any DB connectivity errors logged in registry.log. Consult the 7.5 Administration guide for correct setup of the DB connection. If the issue still occurs, I'd recommend to open a ticket with CA support. However, please bear in mind that LISA 7.5 went EOS on 12/15/15, 7.5.1 will reach EOS on 04/15/16 and 7.5.2 will reach EOS on 06/01/16 (http://www.ca.com/us/support/ca-support-online/product-content/status/support-life-cycle/indexes/devtest-solutions-release-and-support-lifecycle-dates.aspx?id=%7BB93A8BB5-DF34-4488-8985-5CD4BA81C9F5%7D).