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
