Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.help > #2854

Re: Tomcat7 on Ubuntu 12.04 does not load mySQL JDBC Connector

Show all headers | View raw

On 16/11/13 07:25, Philipp Kraus wrote:
> Hello,
>
>
> I try to install in an Ubuntu 12.04 a Tomcat7 with mySQL JDBC. So I have
> run apt-install for tomcat and libmysql-java, but I get always:
>
>
> java.lang.ClassNotFoundException: "com.mysql.jdbc.Driver"
>
>
> in my logs. In the catalina.properties the loading pathes are defined with
>
>
> common.loader=${catalina.base}/lib,${catalina.base}/lib/*.jar,${catalina.home}/lib,${catalina.home}/lib/*.jar,/var/lib/tomcat7/common/classes,/var/lib/tomcat7/common/*.jar
>
> server.loader=/var/lib/tomcat7/server/classes,/var/lib/tomcat7/server/*.jar
>
> shared.loader=/var/lib/tomcat7/shared/classes,/var/lib/tomcat7/shared/*.jar
>
>
> The JDBC mySQL Jar is stored under /usr/share/java with twi symlinks, I
> have tried to create a symlink from Tomcats lib dir
> (/usr/share/tomcat7/lib) to ../../java/mysql.jar
>
> but the mySQL is also not loaded.
>
> The CATALINA_HOME is set to /usr/share/tomcat7 and the CATALINA_BASE is
> /var/lib/tomcat7, so imho it should be worked
>
>
> I try to run http://www.icescrum.org/ with mySQL support.
>
>
> Can anybody help me please with a useful idea to create a working mySQL
> JDBC driver in my Tomcat7?
>
>
> Thanks a lot

Ubuntu 12.04 LTS
apache-tomcat-7.0.42
jdk1.7.0_45

Yea, this can be a bit of a PITA sometimes if you are relying on 
container managed connection pools as the container needs to find the 
jar before a web app that uses it is fully loaded, at least this is what 
I have figured out anyway.

I have the following directory structure
/opt/apache-tomcat-7.0.42/

I copied mysql-connector-java-5.1.22-bin.jar
into /opt/apache-tomcat-7.0.42/lib

I restarted the server and it all just works
no sym links and no fancy obscure directory structure scattered across 
the file system.

Try it, it might be what you are looking for.


-- 
Lipska the Kat©: Troll hunter, sandbox destroyer,
treacherous feline and farscape dreamer of Aeryn Sun
GNU/Linux user #560883 - http://www.linuxcounter.net

Back to comp.lang.java.help | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Tomcat7 on Ubuntu 12.04 does not load mySQL JDBC Connector Philipp Kraus <philipp.kraus@flashpixx.de> - 2013-11-16 08:25 +0100
  Re: Tomcat7 on Ubuntu 12.04 does not load mySQL JDBC Connector lipska the kat <"lipskathekat at yahoo dot co dot uk"> - 2013-11-17 09:49 +0000
    Re: Tomcat7 on Ubuntu 12.04 does not load mySQL JDBC Connector Philipp Kraus <philipp.kraus@flashpixx.de> - 2013-11-17 11:30 +0100
      Re: Tomcat7 on Ubuntu 12.04 does not load mySQL JDBC Connector lipska the kat <"lipskathekat at yahoo dot co dot uk"> - 2013-11-17 14:36 +0000

csiph-web