cancel
Showing results for 
Search instead for 
Did you mean: 

EnterpriseDB with Tomcat JDBC connection pool

Highlighted
Adventurer

EnterpriseDB with Tomcat JDBC connection pool

How compatible is EnterpriseDB with Tomcat JDBC connection pool?

We have a scenario where while using normal JDBC the queries (SELECT) are executed fine but when using Tomcat JDBC connection pool, it throws many exceptions.

JDK Version - 8

Tomcat version - 8.0

EDB Jar - edb-jdbc18.jar

Tomcat jdbc PoolProperties: 

maxActive=50
maxAge=3600000
maxIdle=10
maxWait=1000
minEvictableIdleTimeMillis=300000
minIdle=0
numTestsPerEvictionRun=3
testOnBorrow=true
testOnConnect=false
testOnReturn=true
testWhileIdle=false
timeBetweenEvictionRunsMillis=-1
validationInterval=30000
validationQuery=SELECT  1
validationQueryTimeout=3
whenExhaustedAction=2

 Exceptions are like:

com.edb.util.PSQLException: The query returned no result.
java.lang.IllegalStateException: Received resultset tuples, but no field structure for them

 

com.edb.util.PSQLException: Instead of the expected command state BEGIN, ROLLBACK was received.

 

2 REPLIES
EDB Team Member

Re: EnterpriseDB with Tomcat JDBC connection pool

Hi,

 

Could you tell which version of EPAS you are using? And any chance you have also tried to reproduce the same example in the community PostgreSQL with the community JDBC drivers? Or this application is migrated from ORACLE hence you are not able to test this on community version?

 

The reason for checking this is, I want to verify if this issue occurs specifically using the EPAS and EPAS JDBC drivers or it occurs in the community version as well.

 

Regards

Ankit Shukla

Adventurer

Re: EnterpriseDB with Tomcat JDBC connection pool

Hi,

The server used is "EnterpriseDB 9.3.11.33, compiled by Visual C++ build 1600, 64-bit"

EDB Jar - edb-jdbc18.jar

JDK Version - 8

Tomcat version - 8.0

 

Thanks.