Is this path included in your classpath or in one of the .loaders in the
catalina.properties file?
/opt/tomcat/latest/lib/mysql-connector-java-5.1.47-bin.jar
Dream * Excel * Explore * Inspire
Jon McAlexander
Asst Vice President
Middleware Product Engineering
Enterprise CIO | Platform Services | Middleware | Infrastructure Solutions
8080 Cobblestone Rd | Urbandale, IA 50322
MAC: F4469-010
Tel 515-988-2508 | Cell 515-988-2508
jonmcalexan...@wellsfargo.com
This message may contain confidential and/or privileged information. If you are
not the addressee or authorized to receive this for the addressee, you must not
use, copy, disclose, or take any action based on this message or any
information herein. If you have received this message in error, please advise
the sender immediately by reply e-mail and delete this message. Thank you for
your cooperation.
-----Original Message-----
From: Barry Kimelman <crhistopher.p...@gmail.com>
Sent: Monday, July 13, 2020 3:22 PM
To: Tomcat Users List <users@tomcat.apache.org>
Subject: tomcat can't find suitable driver for mysql
my system is ubuntu 20.04
I am running tomcat 9.0.37
I can run java based mysql programs from the terminal command line with no
problems
I have installed tomcat under /opt/tomcat/latest under /opt/tomcat/latest/lib I
have installed the jar file for mysql
-rw-r--r-- 1 root root 1007505 Jul 13 10:54
/opt/tomcat/latest/lib/mysql-connector-java-5.1.47-bin.jar
In my build.xml I have the following lines
131 <property name="catalina.home" value="/opt/tomcat/latest"/>
186 <!-- Include all elements that Tomcat exposes to applications -->
187 <fileset dir="${catalina.home}/bin">
188 <include name="*.jar"/>
189 </fileset>
190 <pathelement location="${catalina.home}/lib"/>
191 <fileset dir="${catalina.home}/lib">
192 <include name="*.jar"/>
193 </fileset>
However after I compile and install the application, when I try to run it my
application traps the following error
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost/qwlc?autoReconnect=true&useSSL=false
What am I missing ? Why can't my tomcat app find the mysql class ?
==================
Barry Kimelman
Winnipeg, Manitoba, Canada
