That is in the build, but not in the operational files.
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 4:08 PM
To: Tomcat Users List <users@tomcat.apache.org>
Subject: Re: tomcat can't find suitable driver for mysql
But what about the lines
191 <fileset dir="${catalina.home}/lib">
192 <include name="*.jar"/>
193 </fileset>
in the build.xml file ? Aren't those supposed to expose all the JAR files under
the tomcat lib directory to all apps ?
On Mon, Jul 13, 2020 at 3:49 PM <jonmcalexan...@wellsfargo.com.invalid>
wrote:
> 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
>
--
==================
Barry Kimelman
Winnipeg, Manitoba, Canada
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
