Bug 56974 - jdbc-pool validation query defaultAutoCommit status
Summary: jdbc-pool validation query defaultAutoCommit status
Status: RESOLVED FIXED
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
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-09-12 09:01 UTC by denuwanthi
Modified: 2019-10-01 14:58 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

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.

Thanks,
Denuwanthi.
Comment 1 Mark Thomas 2019-10-01 14:58:30 UTC 
See https://github.com/apache/tomcat/pull/170