Unable to connect to my Oracle or EMR database after .43 upgrade.

Question

I am receiving the following error on my Oracle database connections after .43 upgrade was completed.

Wrapped com.qvera.qie.exception.NoResultsException: org.apache.tomcat.jdbc.pool.PoolExhaustedException: [processor-20160607054037.291-1] Timeout: Pool empty. Unable to fetch a connection in 60 seconds, none available[size:100; busy:100; idle:0; lastwait:60000].

Answer 1

QIE .43 enhanced the way we open database connections. For Oracle this means the OJDBC5 driver is not compatible.

To correct this update to the Oracle JBDC6 jar file. 

1. Download the OJDBC6 driver.

2. Copy the .jar file to the "C:\programdata\qie\lib" directory

3. Go to system configuration and uncheck the OJDBC5.jar file.

4. Check the new ojdbc6.jar file.