Take a look at the list thread "Would like to know" > -----Original Message----- > From: Paul Davies [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 23, 2001 4:40 PM > To: [EMAIL PROTECTED] > Subject: Followup detail (Tomcat Mysql execption) > > > Hi guys, > I am getting the following error: > > javax.servlet.ServletException: No suitable driver > at > org.apache.jasper.runtime.PageContextImpl.handlePageException( > PageContextImpl.java:457) > at > org.apache.jsp.ivf_0005fclinic_0005fsearch$jsp._jspService(ivf > _0005fclinic_0005fsearch$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_database_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 > back! > 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. > > ============================================================== > ============= > To unsubscribe: mailto [EMAIL PROTECTED] with body: > "signoff JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set > JSP-INTEREST DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com >
=========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
