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.

 

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

4 REPLIES 4
Highlighted
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

Highlighted
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.

Highlighted
Adventurer

Re: EnterpriseDB with Tomcat JDBC connection pool

Hi,

 

Can you please help with the problem?

Highlighted
EDB Team Member

Re: EnterpriseDB with Tomcat JDBC connection pool

Dear User,

 

Thank you for the update and sorry for the delay.

 

Could you please share us a small reproducible test case so that I can check locally implementing the same?

 

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks