Re: [jdbc-pool] Validation query leaves transaction open

2016-08-15 Thread John Huss
< ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > John, > > On 8/11/16 3:33 PM, John Huss wrote: > > I have verified that in version 8.0.36 of tomcat jdbc the > > validation query functionality does not commit the transac

Re: [jdbc-pool] Validation query leaves transaction open

2016-08-12 Thread John Huss
In every database I have used every query requires a transaction. Often they will start them automatically if you don't do it explicitly. On Fri, Aug 12, 2016 at 4:13 AM Jose MarĂ­a Zaragoza <demablo...@gmail.com> wrote: > 2016-08-11 21:33 GMT+02:00 John Huss <johnth...@gmail.com&

[jdbc-pool] Validation query leaves transaction open

2016-08-11 Thread John Huss
I have verified that in version 8.0.36 of tomcat jdbc the validation query functionality does not commit the transaction it starts in order to run the validation query, which can cause an open transaction for a very long time (possibly until the database crashes). This seems to be especially