-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

John,

On 7/25/20 11:25, John Dale wrote:
> We've wrapped my connection pool interface in a Factory.  Can you
> confirm how the current request's thread is used by JDBC
> connection pooling to MySQL?

Are you using Tomcat to manage your DataSource resource? For example:

Context ctx = new InitialContext();

DataSource ds =
(DataSource)ctx.lookup("java:/comp/env/jdbc/myDataSource");

Connection conn = ds.getConnection();

?

If you have written your own datasource factory, then when you call
ctx.lookup(), you will be getting the DataSource object returned by
your factory when your web application starts.

If you make calls to DataSource.getConnection,
Connection.prepareStatement, etc. everything is done in the current
thread. If you use Tomcat's tomcat-pool or DBCP2, the only things that
happen outside of the current request-processing thread are the
background maintenance tasks such as checking for abandoned connections.

Does that answer your question?

- -chris
-----BEGIN PGP SIGNATURE-----
Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/

iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAl8e+8oACgkQHPApP6U8
pFihVQ/9H1gtRafA2J5+m0WtgsM7SGVnzbBnPsHpu6Fu58Z+7qK5Ds4sx1OVLoZq
PlZa33mZ73MzaLJ5fQh7CI6/dKdl+k6Vst5gkejV+sWvmWnKZuA5t+8+emxecgVg
aYU08BLQeblLMqPUp9gjYpaoqgFgpe6EYkE8zQIY63nWAp30yHUW45QPMm0vdtAM
gNnUEAHgggMSyTwvrqFlBwxjDJThe4WUS934wg+VsS4CyUvtkg0i97DMoS1FWabH
Ipaw7//XKdT63MXI25gJHvo8D3Tu0OPAWJGoqWycFuO6iOpz9gijctnYfWawOOaX
6JvBGH3hYdf2W/qisnnklI6Ips8sSuwwBKzTPcB1ZJGptyJnavi2/LULxqgsE+AY
yQGCcj4JFgpf65qOrwo4bBzVS3U+kc+VB9AjUoNQBSyLMmoiq+/8OFx83yT+g/Fr
Qt34+b28W49TOzF4v7KFmSVPBlJ40pQIgS7R04RD5aPeNqYkVn0BUmav05q4fTe+
lp3nAcRCfpJMG3T4TDTtHH24xT2WeC3+wyhOyP3QlsYML8yMO6MGOfYCW6wN0jlM
muZMCHYlnkZ+xZqaQ9GU6qqL2WhClf8v9Xjw/ppClSr+D8Cx4JXdTKXhO9QUKb0j
TyvkHD35UwGcDlQduqyiUQb5tpOC2Ym5vjsZFbmTwbZeKE39zmk=
=gT2X
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to