tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: tomcat can't find suitable driver for mysql
Date Mon, 13 Jul 2020 22:04:26 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Barry,

On 7/13/20 16:21, Barry Kimelman wrote:
> 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

Tomcat establishes its own CLASSPATH and applications hosted on Tomcat
behave according to the servlet spec with respect to where libraries
must be located.

> 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

That should be sufficient. How are you launching Tomcat?

> In my build.xml I have the following lines

Your build.xml is not relevant, unless it is physically copying files
somewhere, or bundling them into your WAR file.

> 131   <property name="catalina.home" value="/opt/tomcat/latest"/>
> However after I compile and install the application, when I try to
> run it my application traps the following error

How do you launch Tomcat and/or your application?

> 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 ?

How are you configuring your application for JDBC access? Using a
<Resource> in META-INF/context.xml foor your application?

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

iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAl8M2mgACgkQHPApP6U8
pFjKiA/+Kkxc2zdlIFj7hXi/wZIRcQM7jmQfs1WA6xujWXxPEnfCK24AuknMwt/w
KOKDjK65Q+WTlPIxe2Kh6+oMpMbCAnIWfqLs0oM7r/aUAvMvuw3qaEbeuPgGwcJx
7Kh746Hfx4qnmsaFYx6bD8GA2K+343mTH6QlWnV/F7EeILiNA6gPhMms/FAl7R1G
pVjYaXsPQU4+vwEsakGLmJpqF5I9BqejwaVDYVyALa+u1C4dyqk2N6MxVv/KsifB
p/I1TY281mjzGRXRS9WE9TksRAJ3S5PtAs1GIlXZVGbfNLc+Zlt6uIYwia+5Oi0G
vZtJzE8pIpq/Q+/DswwtumtwocfiHlsYhIezdmVNYnJnwXTRoBxz3JEOb4cYN07D
duii9T+AtACHGaTLXYFWX71XAqwrNw67MbEhi4ex9Ajrk0Qx8s6le9EyKQNI9Wpz
TrjyjbsvQzXcTANsPTF4o23IQIhc+VuAKJsTlyucvKVCUUx4AS1lTKmBH7zgVr3S
/CDmwF/PYrBWCEv2D+iQqhAQ7uc/cK7Fp3mwIpc+oWzIA+ART93ktuEP5lKYiNHE
JFDxO5wpK2HFv/dMpf2HFqEDprP9dMS2M8kZRFGKSoDDVTS25YyH7WM//ID1RU9J
4LFcSR7qek/1My7HYpPZFctey+eI/OAbwB3JlyV2QMNRs8CwH8E=
=Wcma
-----END PGP SIGNATURE-----

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


Mime
View raw message