-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Chris and Keiichi,
On 10/17/17 5:31 PM, Chris Cheshire wrote: > On Tue, Oct 17, 2017 at 3:44 AM, Keiichi Fujino > <kfuj...@apache.org> wrote: >> Hi >> >> You have set >> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory". In other >> words, you do not use (tomcat)DBCP, you are using Tomcat >> jdbc-pool. > > That's what I meant sorry. Was comparing to commons-dbcp and went > dyslexic on the acronyms. > >> >> In DBCP, the default of rollbackOnReturn attribute is true. >> However, in Tomcat jdbc-pool, the default of rollbackOnReturn( >> and commitOnReturn ) attribute are false. >> >> see: >> http://commons.apache.org/proper/commons-dbcp/configuration.html >> http://tomcat.apache.org/tomcat-8.5-doc/jdbc-pool.html >> >> > > Now that explains it entirely. Thank you so much! > > Part of this is me failing to RTFM entirely, and then part is the > nature of configuration references - if you don't know what you are > looking for it is easy to miss important details. It would be > helpful if that page explained some of the fundamental differences > from a usage perspective (not just implementation improvements) but > that's another story. I didn't realize that these two libraries had different default semantics. IMO, Tomcat's jdbc-pool behaves _correctly_ in that it doesn't issue an unnecessary ROLLBACK on every connection returned to the pool. - -chris -----BEGIN PGP SIGNATURE----- Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQJRBAEBCAA7FiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlnyMUcdHGNocmlzQGNo cmlzdG9waGVyc2NodWx0ei5uZXQACgkQHPApP6U8pFij4w//Q5tGBgwdcXsT9k/V Raop4RalDLSeJNhTDY2FIMpDNHnvcq45BrOqkO3GhukyuNxpn/aJrUsE6ucbXN/3 jeb32JDEJ5f8FK5A6t9ZCeEG84p5BNDEfQUJEJQA5G67tBrhYzGfbW0t4X4qMyuM l/xrVBLVP9JCLdjWUg/VnTyYhNKZGkIHYXzX5QtmZtjTRH+OBzCTuTT4B54WhkWM MIFn5WYXxOnP6/+nR4f4rcV8VPKiJOoYuTv+dxt/Ih4IiGPNh+xUIzNS+lCTiagK rsWDq51pqkH05nHdJTZ2+aZJEs/mFWXaCyjU3BOvIEPaUKaBJgjxjGBrIL1Tb/a9 jVEU3WrRJ3jNSNGYeN9kBfaL2dtB4W/H1btk1WAu39IuAdD/ZEcr8VgyIbteP6ar StHXm2g5xt88X8ndgIo/2jdZisZ8LBNFksZ5yMXRuJckw3FN/YeLzHbe3gbPFXtv K4xMFlI8OZFqr89EuNzzQjsris0gy6k3EFfQGz5tJDK7yiTNIEBfQbjGj9eFyYoA 7V2f7HvUIVmiNnRpCdg0CihdOypzIrXAZePOYTJGzkER0pUlGqt4ue4+6o5i8GSf lap1sScK7Q6FiOGAvtQ3ZE+WMXvUFqGrs//O0pIi67KwXXHu+WsDV7av1BupZ0/F hFkomQ3hHYAJoDoEJJHkn7jRXpY= =zG27 -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org