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: "Kumar.K.R" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 30, 2003 10:50 PM
Subject: Directive
> Hi,
>
> I want a simple but good definition of a Directive in jsp.
>
> Thanx and Regards,
>
> KR Kumar
>
> ===========================================================================
> 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
