Derby: Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!
Article ID: 107144
Updated On:
Products
CA Application Test
Service Virtualization
CA Continuous Application Insight (PathFinder)
CA Service Virtualization (DevTest / LISA / VSE / Application Test)
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
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
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.
You can also get this error if the Derby database is full.
Environment
Release:
Component: ITKOTF
Component: ITKOTF
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.
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.
Feedback
Powered by
