Sometimes with certain JDBC Drivers you must do a
Class.forName("driver").newInstance() for it to load properly.
Brian
-----Original Message-----
From: Steve Madonna [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 27, 2002 3:04 PM
To: 'Tomcat Users List'
Subject: RE: mySQL/JDBC/Tomcat4 documentation
Right at line 2 in your code is were we are having trouble. Apparenlty our
code is written the same way, but it still doesn't seem like the JDBC driver
has loaded:
java.sql.SQLException: org.gjt.mm.mysql.Driver
The driver is in the WEB-INF/lib/ directory.
Is there a config file that needs to allow permissions for this?
-----Original Message-----
From: DingHui [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 26, 2002 6:34 PM
To: Tomcat Users List
Subject: Re: mySQL/JDBC/Tomcat4 documentation
The following code demonstrate how to initilize MYSQL JDBC driver.
try {
Class.forName("org.gjt.mm.mysql.Driver");
} catch (ClassNotFoundException e) {
System.out.println(e);
}
try {
Connection con =
DriverManager.getConnection("jdbc:mysql://localhost/mydata", "username",
"password");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT NAME FROM TEST");
// Display the SQL Results
while(rs.next()) {
System.out.println(rs.getString("NAME"));
}
// Make sure our database resources are released
rs.close();
stmt.close();
con.close();
}catch (SQLException se) {
// Inform user of any SQL errors
System.out.println("SQL Exception: " + se.getMessage());
se.printStackTrace(System.out);
}
----- Original Message -----
From: "Steve Madonna" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 27, 2002 8:38 AM
Subject: mySQL/JDBC/Tomcat4 documentation
> Anyone know were I can get some documentation on installing
> mm.mysql-2.0.4-bin.jar file? I keep getting that "not sutible driver"
error
> everyone keeps talking about.
>
> Thx in advance.
>
> -Steve
>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
