Derby: Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!
book
Article ID: 107144
calendar_today
Updated On:
Products
CA Application TestCA Continuous Application Insight (PathFinder)
Issue/Introduction
My Registry is not coming. Getting this error in registry.log.
2018-07-17 20:49:18,744Z (13:49) [main] ERROR com.itko.lisa.utils.JpaUtil - Exception raised checking table existence: 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 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.allTablesExist(JpaUtil.java:599) at com.itko.lisa.utils.JpaUtil.<init>(JpaUtil.java:490) at com.itko.lisa.utils.JpaUtil.getDradisUtil(JpaUtil.java:406) at com.itko.lisa.dradis.comm.JpaUtilWrapper.getAnnotations(JpaUtilWrapper.java:24) at com.itko.lisa.dradis.comm.DradisCommContext.doEnterpriseDashboardHandshake(DradisCommContext.java:133) at com.itko.lisa.coordinator.TestRegistryImpl.initialize(TestRegistryImpl.java:280) at com.itko.lisa.coordinator.TestRegistryImpl.<init>(TestRegistryImpl.java:239) at com.itko.lisa.coordinator.TestRegistryImpl.main(TestRegistryImpl.java:2163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.exe4j.runtime.LauncherEngine.launch(Unknown Source) at com.install4j.runtime.launcher.UnixLauncher.main(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
Environment
Release: Component: ITKOTF
Cause
Properties to target Derby were not set in dradis.properties or site.properties file.
You can also get this error if the Derby database is full.
Resolution
In the dradis.properties set
dradis.db.internal.enabled=true
In the site.properties set:
lisadb.internal.enabled=true
Restart Both Enterprise Dashboard and Registry.
Was then able to see both Enterprise Dashboard and Registry to come up.