search cancel

Registry log shows database connection error and the registry cannot be started.

book

Article ID: 255020

calendar_today

Updated On:

Products

Service Virtualization

Issue/Introduction

After migrating from Oracle to Postgres the following error is shown in the registry.log: 
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!

Also the Registry seems to be trying to connect to the Derby database: 

DEBUG com.itko.lisa.utils.db.ConnectionPoolManager - getUrl for pool name common returning jdbc:derby://hostname:1528/database/lisa.db;create=true

Environment

Release : 10.7.2

Resolution

The site.properties file had a the property "dradis.db.url" where it should have had the "lisadb.pool.common.url".
After correcting that, the registry service started without error:

lisadb.pool.common.url=jdbc:postgresql://hostname:5432/plisa?sslmode=require&currentSchema=devtest