Thanks everyone. I think I've got the "no sutible driver" thing fixed. Now there's an SQL exception being thrown. Could be a programmer thing... I'm going to get with our developers tomorrow to see if we can't get to the bottom of this. Thanks again.
I actually found a pretty good page put together for OSX: http://developer.apple.com/internet/macosx/tomcat2.html It's actually pretty useful for anyone running tomcat. Also the mm.mysql README was pretty helpful to: http://sourceforge.net/docman/display_doc.php?docid=8968&group_id=15923 Thx again! -Steve -----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 >
