Hi everybody,
pls help me in resolving this.
first i downloaded n installed the mysql-connector-java-3.1.13.zip ,sql server 5.0 and tomcat 5.0.28.Then to connect them i copyied the mysql-connector-java-3.1.13-bin.jar into two place
1: in the (C:\TOMCAT\Tomcat 5.0\common\lib) and
2:in the (C:\j2sdk_nb\j2sdk1.4.2\jre\lib\ext)
now let me also tell you that my tomcat installation is proper as i checked it for the file in root directory of tomcat(index.jsp)..it also works for other jsp files of mine which doesnt include MySQL connection.
Just to check the MySQL connection with jsp in tomcat i tried out one simple code where
1:I created a database named register in mysql server 5.0(using mysql command-line-client) in which i created a table named users(name,password,message)
2.now in my first jsp file that is db-login.jsp(the user has to enter a username and password) through a html form...which then is forwarded to the next page that is db-result.jsp where it will compare the name and password both from the users table in it matches then it will display the correspondin welcome message else it will ask to loginagain ..that is back to db-login jsp
IS IT RIGHT TO SAVE OUR JSP FILES /FOLDERS DIRECTLY INTO THE ROOT DIRECTORY OF TOMCAT
Attached with this, is my code and the error that i get from that.
plss resolve my problem with the db-result.jsp
thanx in advance.
,-- my jsp codes--
//code for db-login.jsp//
<%@ page language="java" contentType="text/html" errorPage="errorpage.jsp" %>
<html>
<head>
<title>login</title>
</head>
<body>
<%if(session.getAttribute("welcome")!=null)
{%>
<h3><%=session.getAttribute("welcome")%></h3>
<%}
else
{%>
please log in below to continue...
<form method="post"
action="<%=response.encodeURL("db-result.jsp")%>">
<table>
<tr>
<td>Name:</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>Password:</td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="log in"></td>
</tr>
</table>
</form>
<%}%>
</body>
</html>
///code for db-result.jsp//
<%@page language="java" contentType="text/html"
import="java.sql.*"%>
<html>
<head><title>login</title></head>
<body>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/register?user=shraddha&password=04shetty");
Statement Stmt=conn.createStatement();
ResultSet RS=Stmt.executeQuery("SELECT message FROM users WHERE name='" + request.getParameter("name") + "' AND password=PASSWORD('" +request.getParameter("password")+"')");
String message =null;
while(RS.next())
{
message=RS.getString(1);
}
RS.close();
Stmt.close();
conn.close();
%>
<%if (message!=null){
session.setAttribute("welcome",message);%>
<h3>your login has succeeded.thank you.</h3>
<%}
else{%>
<h3>your login has failed ,please try again.</h3>
<%}%>
<a href="<%=response.encodeURL("db-login.jsp") %>">
continue...</a>
</body>
</html>
/--database that i created using mysql--/
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.22-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| footydb |
| mysql |
| register |
| test |
+--------------------+
5 rows in set (0.38 sec)
mysql> use register;
Database changed
mysql> show tables;
+--------------------+
| Tables_in_register |
+--------------------+
| users |
+--------------------+
1 row in set (0.00 sec)
mysql> select * from users;
+-------+-------------------------------------------+-------------------+
| name | password | message |
+-------+-------------------------------------------+-------------------+
| guest | *11DB58B0DD02E290377535868405F11E4CBEFF58 | welcome stranger! |
| mike | *97EA1C051452E335A13C26602BC66194EDC17677 | hi mike! |
| linda | *1B72E7E7ECBD70C9C8881BD0F9ECA0D76D2FB26B | greetings linda! |
+-------+-------------------------------------------+-------------------+
3 rows in set (0.45 sec)
mysql>
----error that i encounter while executin db-result.jsp------
javax.servlet.ServletException: Access denied for user 'shraddha'@'localhost' (using password: YES)
org.apache.jasper.runtime.PageContextImpl.doHandle PageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:758)
org.apache.jsp.db_002dresult_jsp._jspService(db_00 2dresult_jsp.java:85)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
root cause
java.sql.SQLException: Access denied for user 'shraddha'@'localhost' (using password: YES)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2975)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:798)
com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 3700)
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:12 03)
com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2568)
com.mysql.jdbc.Connection.<init>(Connection.java:1 485)
com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:266)
java.sql.DriverManager.getConnection(DriverManager .java:512)
java.sql.DriverManager.getConnection(DriverManager .java:193)
org.apache.jsp.db_002dresult_jsp._jspService(db_00 2dresult_jsp.java:49)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
please everyone i know this is just my beginning in jsp.but i will b very thankfull to u all if u step in to help in resolvin this problem.
jdbc:sql:tomcat connectivity
