tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andy Eastham" <andy.east...@gliant.com>
Subject RE: Mysql and Tomcat
Date Mon, 15 Apr 2002 08:11:40 GMT
Gareth,

What are the errors?

We're running mysql under Tomcat and our corresponding code is:
            Class.forName("org.gjt.mm.mysql.Driver").newInstance();
            this.connection = DriverManager.getConnection("jdbc:mysql://" +
this.databaseHost +":" + this.databasePort + "/" + this.databaseName +
"?user=" + this.databaseUsername + "&password=" + this.databasePassword);

This works fine, but I guess it's more likely a class loading problem you're
having.  I'd check that mysql.jar is under Tomcat/common/lib.  We've also
got jdbc2_0-stdext.jar there, although I'm not sure this is required any
more.

Andy

> -----Original Message-----
> From: Lawrence, Gareth [mailto:G.R.Lawrence@massey.ac.nz]
> Sent: 15 April 2002 05:53
> To: 'Tomcat Users List'
> Subject: Mysql and Tomcat
>
>
> Greetings All,
>
> Just when I though everything was sweet I'm having a nasty
> problem.  I'm running:
> Debian Linux, Tomcat 4.0.3, Mysql, Ant, MM JDBC driver.
>
> Basically I've set everything up sweet and when I run a test file
> from the command line (java test.class) I get a connection to the
> database no problems.  Unfortunately when I try and do the same
> thing through a servlet loaded onto Tomcat I get grief!!!  See below
> I get two errors outputted in the browser window, the second one
> could be caused by the first :-)
>
> If anyway has any ideas about this, please let me know this is a
> desperate one :-(((
>
> Thanks heaps and heaps,
>
> Gareth
>
> Code:
>
>     try {
>         //Registering the MySQL JDBC Driver
>         Class.forName("org.gjt.mm.mysql.Driver").newInstance();
>     }
>         catch (Exception E) {
>         out.println("<p>Exception: Created Driver</p>");
>         System.err.println("Unable to load driver.");
>         E.printStackTrace();
>     }
>
>     try {
>         //create variable url containing connecting value
>         String url="jdbc:mysql://localhost/weblearn";
>         //Create Connection Object from java.sql.*
>         Connection Conn = DriverManager.getConnection(url, "root", "");
>     }
>         //Exceptions if something went wrong
>         catch (SQLException E) {
>         out.println("<p>SQL Exception</p>");
>     }
>
>
>



--
To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>


Mime
View raw message