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 > > -- "Ever tried. Ever failed. No matter. Try Again. Fail again. Fail better." - Samuel Beckett
