Getting error while integrating with Oracle database

Hi Guys,

I’m getting below error while I’m trying to access web page http://localhost:9000/.

Error Details

[info] p.a.d.DefaultDBApi - Database [default] initialized at jdbc:oracle:thin:@XXXXXX.prg-dc.XXX.com:1521/esbtest
[info] application - Creating Pool for datasource ‘default’
[info] p.a.d.HikariCPConnectionPool - datasource [default] bound to JNDI as DefaultDS
[error] c.z.h.p.PoolBase - HikariPool-1 - Failed to execute isValid() for connection, configure connection test query (oracle.jdbc.driver.T4CConnection.isValid(I)Z).
[error] c.z.h.p.PoolBase - HikariPool-1 - Failed to execute isValid() for connection, configure connection test query (oracle.jdbc.driver.T4CConnection.isValid(I)Z).
[error] c.z.h.p.PoolBase - HikariPool-1 - Failed to execute isValid() for connection, configure connection test query
[error] c.z.h.p.PoolBase - HikariPool-1 - Failed to execute isValid() for connection, configure connection test query (oracle.jdbc.driver.T4CConnection.isValid(I)Z).
[warn] o.h.e.j.e.i.JdbcEnvironmentInitiator - HHH000342: Could not obtain connection to query metadata : HikariPool-1 - Connection is not available, request timed out after 30001ms.
[warn] o.h.d.Oracle9Dialect - HHH000063: The Oracle9Dialect dialect has been deprecated; use either Oracle9iDialect or Oracle10gDialect instead
[warn] o.h.d.OracleDialect - HHH000064: The OracleDialect dialect has been deprecated; use Oracle8iDialect instead
[error] c.z.h.p.PoolBase - HikariPool-1 - Failed to execute isValid() for connection, configure connection test query (oracle.jdbc.driver.T4CConnection.isValid(I)Z).

[warn] Canceling execution…
[error] c.z.h.p.PoolBase - HikariPool-1 - Failed to execute isValid() for connection, configure connection test query (oracle.jdbc.driver.T4CConnection.isValid(I)Z).

[warn] Canceling execution…
[error] c.z.h.p.PoolBase - HikariPool-1 - Failed to execute isValid() for connection, configure connection test query (oracle.jdbc.driver.T4CConnection.isValid(I)Z).
[error] o.h.h.s.i.IdTableHelper - Unable obtain JDBC Connection
java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:697)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
at org.hibernate.internal.SessionFactoryImpl$1.obtainConnection(SessionFactoryImpl.java:459)
at org.hibernate.hql.spi.id.IdTableHelper.executeIdTableCreationStatements(IdTableHelper.java:67)
at org.hibernate.hql.spi.id.global.GlobalTemporaryTableBulkIdStrategy.finishPreparation(GlobalTemporaryTableBulkIdStrategy.java:125)
at org.hibernate.hql.spi.id.global.GlobalTemporaryTableBulkIdStrategy.finishPreparation(GlobalTemporaryTableBulkIdStrategy.java:42)
at org.hibernate.hql.spi.id.AbstractMultiTableBulkIdStrategyImpl.prepare(AbstractMultiTableBulkIdStrategyImpl.java:88)
[error] c.z.h.p.PoolBase - HikariPool-1 - Failed to execute isValid() for connection, configure connection test query (oracle.jdbc.driver.T4CConnection.isValid(I)Z).

application.Conf

This is the main configuration file for the application.

db {
#default.driver = org.h2.Driver
#default.url = “jdbc:h2:mem:play”
default.driver = oracle.jdbc.driver.OracleDriver
default.url = “jdbc:oracle:thin:@XXXXX.prg-dc.XXX.com:1521/esbtest”
default.username = UserName
default.password = “Password”

Provided for JPA access

default.jndiName=DefaultDS
}

Point JPA at our database configuration

jpa.default=defaultPersistenceUnit

Number of database connections

db connections = ((physical_core_count * 2) + effective_spindle_count)

fixedConnectionPool = 9

Set Hikari to fixed size

play.db {
prototype {
hikaricp.minimumIdle = {fixedConnectionPool} hikaricp.maximumPoolSize = {fixedConnectionPool}
}
}

Job queue sized to HikariCP connection pool

database.dispatcher {
executor = “thread-pool-executor”
throughput = 1
thread-pool-executor {
fixed-pool-size = ${fixedConnectionPool}
}
}

Appreciate your support in advance.

Thank you.