Le 18/04/2014 13:53, Daniel Mikusa a écrit : > > Another option you might try would be to set “rollbackOnReturn" to “true”. > That is supposed to instruct the pool to rollback an open transactions when > the connection is returned to the pool. I haven’t tried it, but it seems like it would work here. > Ok, I tested, and you were absolutely right: rollbackOnReturn does the trick.
Moreover, notice that have 'select 1 from rtelre; commit;' as a validationQuery works on Postgresql, but is categorically refused by Oracle... So using rollbackOnReturn=true works and is more portable. Thanks. nb: adding a ; as suggest by Tim does not change anything. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
