My Oracle Support Banner

Facing "Could Not Open Connection" While Running Batches (Doc ID 2466756.1)

Last updated on AUGUST 19, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing - Version and later
Information in this document applies to any platform.


We have an issue with batch executions in our environment failing from time to time with this exception - "org.hibernate.exception.GenericJDBCException: Could not open connection". Threadpool worker log is attached. What we observed is that when framework puts more than 5 connections in connection pool and does not use them for a certain length of time(30 minutes), the framework throws this exception.

We were able to replicate this with both "on_close" and "after_transaction" property value for hibernate.connection.release_mode. The amount of connections in connection pool we see(11) is way below the maximum amount for that pool(300). We were able to fix the problem by using jdbc/ucp driver version and we see a pause and invalid connections being dropped from the pool but no exceptions.
So we would like to know whether ORMB is compatible with jdbc/ucp driver version so that we can continue using it to avoid this exception and subsequent batch failures.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.