Reinstalling the OS is a bit overkill, the error message you are getting has nothing to do with installation. Try using this driver instead, follow the instructions and everything will work fine.
http://mmmysql.sourceforge.net/
Brian
Mikil wrote:
Thank you to all of you for the prompt reply and apologies for the belated response from me.
I just started from fresh i.e. re-intsalled redhat 9 OS and all other relevant tools. I still get the same error.
Below are the codes that I am using to connect to the mysql db through JSP.
<html> <head> <title>Database Access</title> </head> <%@ page import="java.sql.*" %> <body>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
// java.sql.Connection conn;
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:8080/test?user=blah&pass word=blah");
Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("SELECT * FROM User_Login");
// ResultSet rs = stmt.setFetchSize(Integer.MIN_VALUE);
while (rs.next()) { String userID = rs.getString("user_id"); String userName = rs.getString("user_name"); String userPassword = rs.getString("user_pwd");
out.print("<tr>"); out.print("<td>" + userID + "</td>"); out.print("<td>" + userName + "</td>"); out.print("<td>" + userPassword + "</td>"); }
conn.close(); %> </table> </body> </html>
Hope this helps to you to help him.
Rgds & thanks
Mikil
----- Original Message ----- From: "Erik Beijnoff" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 26, 2003 6:17 PM Subject: Re: [Shameless Plug] Servlets and JavaServer Pages; the J2EE Web Tier
It's a bit difficult to solve the problem without the code, but a wild, but rather qualified quess is that your db drivers are residing in a place where the cannot be found by the JVM, or that you haven't registered them properly. The error message implies that. But like I said, without any of your code your question is impossible to answer.
Regards Erik Beijnoff
-----Ursprungligt meddelande----- Från: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED] För Mikil Skickat: 26 November 2003 10:01 Till: [EMAIL PROTECTED] Ämne: Re: [Shameless Plug] Servlets and JavaServer Pages; the J2EE Web Tier
Hi to everyone who comes across this mail.
I am trying to implement a web application using jsp and sevrlet on os linux redhat 9, java ver 1.4.2_05, apache tomcat server ver 4.1.27, mysql ver 3.23.54 std and mysql_connector_java_3.0.9stable.
I am able to execute jsp and servlets, but get an error while I try to access the DB. The error says "no suitable driver". But I checked all documents related to this matter, according to which it is correct.
Will be glad and thankful if someone is able to resolve this.
Thanks.
Mikil
======================================================================== === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com 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 archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com 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 archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com 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 archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
