You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Philipp Kraus <ph...@tu-clausthal.de> on 2013/11/17 19:56:38 UTC
mySQL connector error
Hello,
I'm new with Tomcat, so I hope for some help. I try to run www.icescrum.org on my Tomcat 7 on Ubuntu 12.04 with OpenJDK.
I have installed Tomcat with apt-get and also I have installed the libmysql-java package. On starting Tomcat it reports on
a stacktrace log, that the mySQL connector is not found (java.lang.ClassNotFoundException: "com.mysql.jdbc.Driver").
So I have try to create a symlink in Tomcats lib dir to the jar file and try to modify the properties of the search paths:
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 two 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
How can I create a working IceScrum with mySQL and a shared mySQL connector?
Thanks a lot
Phil
Re: mySQL connector error
Posted by Christopher Schultz <ch...@christopherschultz.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Phillip,
On 11/17/13, 1:56 PM, Philipp Kraus wrote:
> Hello,
>
> I'm new with Tomcat, so I hope for some help. I try to run
> www.icescrum.org on my Tomcat 7 on Ubuntu 12.04 with OpenJDK. I
> have installed Tomcat with apt-get and also I have installed the
> libmysql-java package. On starting Tomcat it reports on a
> stacktrace log, that the mySQL connector is not found
> (java.lang.ClassNotFoundException: "com.mysql.jdbc.Driver"). So I
> have try to create a symlink in Tomcats lib dir to the jar file and
> try to modify the properties of the search paths:
>
> 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 two
> 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
>
> How can I create a working IceScrum with mySQL and a shared mySQL
> connector?
Can you post a copy/paste of the *somplete* output from "ps aux" from
your Tomcat process? It will show all the paths used.
Also, what does "ls -l /usr/share/tomcat7/lib/mysql-*.jar" show?
What about "ls -l /usr/share/java/mysql*.jar"?
Package-managed Java-related packages are usually a complete mess.
You're going to hear a lot of suggestions (including from myself) that
you abandon that mess and install everything yourself. You are likely
to get more updated versions, too, which is nice.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.15 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iQIcBAEBCAAGBQJSilviAAoJEBzwKT+lPKRYFg8QAKa6cFcBofbla/83qHPdquXa
00YDerswDtn3B7Fk9A8+Bjg4/rcVHxb45EChg2apirxd8hish4JLrslcj2FCywG1
QCZOnfV3ubRvFOFjO6Kk1jSjb8n8MZXUUz9G/9Vt/+EsxhTNrn9W5ojLivtqs2vU
L5NoH8G9nGhiwIXvYZRY5/tb0p1paIppIn4+UyJKsP2+fwV0N/YrFPeoGHjk9Yg4
aMy4JRRlY+tdmiS0vDUHw+652CaxJAOszgi3nZi6GZK2dfCRkB+INOTMmMk9ekN2
vyFtmDvYmyT6ugY+FF1WA1z4jXIzpLSQTdjun2VOakBxVX6/VIKtgN7gG0OM1SrC
PuAGqP71i518Wp1+MAN5bGD2ND3Fw46mJ9V9bfUunZyeWP7WNNSJlpykW0LCtWPO
9HVGhRsrKS7rkRq+JCFJ+VTQcknQJaPEblR3KQxsrqsHsIbzumQ3GNsU7L1m5mfj
UF8+xNW8OMjNGUcaK5stmFW6JuPHSir93h9gIs5RXQ3GWz/p3VC2W8F9hXR0AQG9
wti9yYHWNqtkQ7ZLZDSCj8EMv67JIF659dHPG8Lj/7wiqDDDg8j/yOMmQ5j7hXxr
LOSq1qQPzIYbJsKiOEEGjfm9itDkHEiPatsU8Dc6gq8NK0cTOu5qxvPRZgGUfyxI
uwy+iZ/ncEYaERr/4a54
=SJET
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: mySQL connector error
Posted by ישראל מלאכי <al...@gmail.com>.
Hi Phil
try to add Class.forName("com.mysql.jdbc.Driver");
to your code
Israel
On Sun, Nov 17, 2013 at 8:56 PM, Philipp Kraus <
philipp.kraus@tu-clausthal.de> wrote:
> Hello,
>
> I'm new with Tomcat, so I hope for some help. I try to run
> www.icescrum.org on my Tomcat 7 on Ubuntu 12.04 with OpenJDK.
> I have installed Tomcat with apt-get and also I have installed the
> libmysql-java package. On starting Tomcat it reports on
> a stacktrace log, that the mySQL connector is not found
> (java.lang.ClassNotFoundException: "com.mysql.jdbc.Driver").
> So I have try to create a symlink in Tomcats lib dir to the jar file and
> try to modify the properties of the search paths:
>
>
> 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 two 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
>
> How can I create a working IceScrum with mySQL and a shared mySQL
> connector?
>
> Thanks a lot
>
> Phil
>
>