Bug 56974 - jdbc-pool validation query defaultAutoCommit status
Summary: jdbc-pool validation query defaultAutoCommit status
Status: NEW
Alias: None
Product: Tomcat Modules
Classification: Unclassified
Component: jdbc-pool (show other bugs)
Version: unspecified
Hardware: PC Linux
: P2 normal (vote)
Target Milestone: ---
Assignee: Tomcat Developers Mailing List
Depends on:
Reported: 2014-09-12 09:01 UTC by denuwanthi
Modified: 2014-09-12 09:01 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description denuwanthi 2014-09-12 09:01:24 UTC
I would like to know wether the validation query made by jdbc pool is done in defaultAutoCommit=true mode.
Because, it seems like after the validation query, it is not committed. So, when we try to do some other operation we get an error : "Cannot change transaction isolation level in the middle of a transaction"
Thus, we have to forcefully commit the validation query, by making defaultAutoCommit=true in our datasource configuration.
Any insight on this is much appreciated.