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
