I'm not a MySQL user, but I really don't think you should EVER put anything directly in the JRE directory. It should go either in your Tomcat lib or better yet (if application specific) in your WEB-INF/lib directory.
-----Original Message----- From: Paul Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 11:57 AM To: [EMAIL PROTECTED] Subject: URGENT, Tomcat & MySQL problems Hi guys, I am getting the following error: javax.servlet.ServletException: No suitable driver at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp l.java:457) at org.apache.jsp.ivf_0005fclinic_0005fsearch$jsp._jspService(ivf_0005fclinic_0 005fsearch$jsp.java:145) .......... and I believe that I have the driver installed in the correct place. I am running Tomcat 4.0 with MySQL 3.23.43 with Redhat Linux 7.1. I placed the 'mm.mysql-2.0.4-bin.jar' file in /usr/java/jdk1.3.1/jre/lib/ext directory (as instructed by some solutions in the mailing list) but the driver still will not work. In my 'server.xml' file I have the following Realm defined : <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" connectionName="website" connectionPassword="user" driverName="org.gjt.mm.mysql.Driver" connectionURL="jdbc:mysql://linuxsvr.hfea.gov.uk/dba" userTable="user" userNameCol="User" userCredCol="Password"/> In my .jsp page the extract where the exception occurs is : String MM_centres_web_database_DRIVER = "org.gjt.mm.mysql.Driver"; String MM_centres_web_database_USERNAME = "website"; String MM_centres_web_database_PASSWORD = "user"; String MM_centres_web_database_STRING = "jdbc:mysql://linuxsvr.hfea.gov.uk/dba"; // end // HTML // begin [file="/Connections/centres_web_database.jsp";from=(10,2);to=(14,2)] out.write("\r\n\r\n\r\n\r\n "); // end // HTML // begin [file="/ivf_clinic_search.jsp";from=(2,58);to=(3,0)] out.write("\r\n"); // end // begin [file="/ivf_clinic_search.jsp";from=(3,2);to=(12,0)] Driver DriverRecordset1 = (Driver)Class.forName(MM_centres_web_database_DRIVER).newInstance(); Connection ConnRecordset1 = DriverManager.getConnection(MM_centres_web_database_STRING,MM_centres_web_da tabase_USERNAME,MM_centres_web_database_PASSWORD); PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT * FROM DBA.region_pg"); ResultSet Recordset1 = StatementRecordset1.executeQuery(); boolean Recordset1_isEmpty = !Recordset1.next(); boolean Recordset1_hasData = !Recordset1_isEmpty; Object Recordset1_data; int Recordset1_numRows = 0; // end I have completely run out of ideas as to why this exception is occuring, I would be very grateful for any suggestions as my manager is breathing down my neck! Thanks again, Paul ____________________________________________________________ Nokia Game is on again. Go to http://uk.yahoo.com/nokiagame/ and join the new all media adventure before November 3rd.
