THIS WORKS NOW!
Thanks a lot.
I'm so fascinated about the great possibilities of servlets :)
I've thousands of ideas to implement.
-----Ursprungliche Nachricht-----
Von: Doug Fields [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 30. April 2001 17:43
An: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Betreff: Re: Tomcat and MySQL
I have MySQL working fine with the driver you mention below (version 2.0.4)
by putting the library for it (the jar file) into the WEB-INF/lib
directory, where it belongs.
If it doesn't work for you there, you can try the $TOMCAT_HOME/lib
directory. Some things (like JCE 1.2.1) only will work from there due to
problems in tomcat.
I use Tomcat 3.2.1.
Doug
At 04:54 AM 4/30/2001, Robert Wohlgemuth wrote:
>Hi to all!
>
>I use Tomcat together with mysql to store my data.
>I wrote an servlet at school that uses an Oracle Database to store and
>retrieve data. It worked fine. So I wanted to use this servlet at home too.
>I changed the JDBC driver but now i get in the tomcat.log file an
exception.
>The source of the exception is, that i cn't connect to my database. in my
>tomcat.log - file i found this entry:
>
>2001-04-30 10:50:05 - Ctx( /examples ): Exception in: R( /examples +
>/servlet/Navigation + null) - java.lang.NoClassDefFoundError:
>org/gjt/mm/mysql/Driver
> at JDBCAdapter.<init>(JDBCAdapter.java:48)
> at Navigation.doGet(Navigation.java:35)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
> at org.apache.tomcat.core.Handler.service(Handler.java:286)
> at
> org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
> at
>org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:7
9
>7)
> at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
> at
>org.apache.tomcat.service.connector.JNIConnectionHandler.processConnection(
J
>NIConnectionHandler.java:167)
> at
> org.apache.tomcat.service.JNIEndpoint.service(JNIEndpoint.java:162)
>
>Before i had some other errors. I change the classpath that the mysql-jdbc
>driver is also in it. And now the error mentioned above occours.
>Is this a problem of my classpath and why does the exception writes:
>org/gjt/mm/my.... an not org.gjt.mm.my.....?
>
>I know this is not a problem of tomcat, but I think many of you use the
>mysql database with java.
>Perhaps someone can help me.
>
>Thanks in advance,
> Robert