Bug 56974

Summary: jdbc-pool validation query defaultAutoCommit status
Product: Tomcat Modules Reporter: denuwanthi <denuwanthi.hasanthika>
Component: jdbc-poolAssignee: Tomcat Developers Mailing List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Linux   

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