Luis,
Thanks very much. I'll have a look.
Cheers,
-Richard
On 3/26/2019 1:43 AM, Luis Rodríguez Fernández wrote:
Hello Richard,
In my experience the best is to "start simple". I would have a look at the
apache tomcat doc [1], configure your pool with a minimal setup and test.
Everything depends on your application workload, how your queries looks
like, etc, so I am afraid that there are no "silver bullets" in this
domain.
Hope it helps,
Luis
[1]
https://tomcat.apache.org/tomcat-8.5-doc/jndi-datasource-examples-howto.html
El lun., 25 mar. 2019 a las 19:15, Richard Huntrods (<huntr...@nucleus.com>)
escribió:
<sigh> It's time to update my application to use "real" (i.e. current
best practices) data connection pooling.
My application is Java Servlets, no beans, no JSP. Database is MySQL.
System etc. details:
Ubuntu live server 18.04.2, built March 6, 2019.
MySQL - latest installed via 'apt-get install mysql-server' after system
build.
OpenJVM - 11? - again, latest version installed via 'apt-get install
default-jdk' at same time.
Tomcat 8.5.39 - just updated the same day it came out.
This system has been running in production since the early 2001's. OS
has changed over the years from Sun Solaris 8.x to Solaris 10.x and now
to Ubuntu 18.04 (server). Java has been updated over the years as well,
as has Tomcat and MySQL. Through all that the system works quite perfectly.
Except... there are occasional hangs that implicate the 'home grown'
data connection pool. I wrote this by hand (in Java) back in 2001
because there was nothing much available back then. Since it kept
working, I didn't have the time/inclination to change over the years.
But the latest connector (mysql-connector-java-8.0.15.jar, a.k.a.
"com.mysql.cj.jdbc.Driver" is giving me some hiccups. I thought rather
than trying to debug my own connection pool, it was time to switch over
to a proper "modern" supported connection pooling system.
Which brings me to my question.
Would the community please weigh in on the BEST tutorials / documents
regarding creating a Tomcat/MySQL database connection pool for Servlets
(not JSP or beans) with some good code examples and server.xml examples?
I've already done some extensive internet searches, but when you are
doing something for the first time it's hard to tell the difference
between "really really good" and "blogger who has not really tried it".
Thanks very much in advance.
-Richard
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
