maryamsaedi91
جمعه 31 خرداد 1392, 10:10 صبح
سلام دوستان من در اجراي صفحه jsp كه به ديتابيس sqlserver 2008 متصله يه مشكل دارم
زمان اجرا اين خطا رو ميده كسي ميتونه بهم كمك كنه چرا اين خطا رو ميده.
من با neatbeans7.2 و jdk 1.6 و jdbc4
صفحه jsp يه چنين كدي داره:
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*" contentType="text/html"%>
<%--
Document : membershow
Created on : May 6, 2013, 9:55:19 PM
Author : saedi
--%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%
Class.forName("com.microsoft.sqlserver.jdbc.SQLSer verDriver");
String connectionUrl = "jdbc:sqlserver://localhost:1433;" +
"databaseName=member;";
Connection con=DriverManager.getConnection(connectionUrl);
Statement st=con.createStatement();
st.executeQuery("select * from member");
ResultSet rs=st.getResultSet();
st.close();
con.close();
%>
<tabel cellpadding="15" border="1" style="background-color: #ffffcc">
<tr>
<td> Password </td>
<td> User Name </td>
<td> Email </td>
<%while(rs.next()){%>
<tr>
<td><%=rs.getString("pass")%></td>
<td><%=rs.getString("name")%></td>
<td><%=rs.getString("email")%></td>
</tr>
<tr>
<td> <input type="checkbox" name="del" value=<%=rs.getString("pass")%> /> </td>
</tr>
</tabel>
<%}%>
</body>
</html>
.................................................. ..................
خطايي كه ميده اينه:
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: javax.servlet.ServletException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. ClientConnectionId:d89bad6f-807a-47cf-aae9-ca003e4a844e
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:549)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:455)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)
org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:393)
root cause
javax.servlet.ServletException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. ClientConnectionId:d89bad6f-807a-47cf-aae9-ca003e4a844e
org.apache.jasper.runtime.PageContextImpl.doHandle PageException(PageContextImpl.java:911)
org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:840)
org.apache.jsp.index_jsp._jspService(index_jsp.jav a:136)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)
org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:393)
root cause
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. ClientConnectionId:d89bad6f-807a-47cf-aae9-ca003e4a844e
com.microsoft.sqlserver.jdbc.SQLServerException.ma keFromDatabaseError(SQLServerException.java:216)
com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF (tdsparser.java:254)
com.microsoft.sqlserver.jdbc.TDSParser.parse(tdspa rser.java:84)
com.microsoft.sqlserver.jdbc.SQLServerConnection.s endLogon(SQLServerConnection.java:2908)
com.microsoft.sqlserver.jdbc.SQLServerConnection.l ogon(SQLServerConnection.java:2234)
com.microsoft.sqlserver.jdbc.SQLServerConnection.a ccess$000(SQLServerConnection.java:41)
com.microsoft.sqlserver.jdbc.SQLServerConnection$L ogonCommand.doExecute(SQLServerConnection.java:222 0)
com.microsoft.sqlserver.jdbc.TDSCommand.execute(IO Buffer.java:5696)
com.microsoft.sqlserver.jdbc.SQLServerConnection.e xecuteCommand(SQLServerConnection.java:1715)
com.microsoft.sqlserver.jdbc.SQLServerConnection.c onnectHelper(SQLServerConnection.java:1326)
com.microsoft.sqlserver.jdbc.SQLServerConnection.l ogin(SQLServerConnection.java:991)
com.microsoft.sqlserver.jdbc.SQLServerConnection.c onnect(SQLServerConnection.java:827)
com.microsoft.sqlserver.jdbc.SQLServerDriver.conne ct(SQLServerDriver.java:1012)
java.sql.DriverManager.getConnection(DriverManager .java:582)
java.sql.DriverManager.getConnection(DriverManager .java:207)
org.apache.jsp.index_jsp._jspService(index_jsp.jav a:81)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)
org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:393)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.27 logs.
--------------------------------------------------------------------------------
Apache Tomcat/7.0.27
ممنون ميشم اگه كمكم كنيد
من تو jsp زياد وارد نيستم:ناراحت:
با تشكر
زمان اجرا اين خطا رو ميده كسي ميتونه بهم كمك كنه چرا اين خطا رو ميده.
من با neatbeans7.2 و jdk 1.6 و jdbc4
صفحه jsp يه چنين كدي داره:
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*" contentType="text/html"%>
<%--
Document : membershow
Created on : May 6, 2013, 9:55:19 PM
Author : saedi
--%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%
Class.forName("com.microsoft.sqlserver.jdbc.SQLSer verDriver");
String connectionUrl = "jdbc:sqlserver://localhost:1433;" +
"databaseName=member;";
Connection con=DriverManager.getConnection(connectionUrl);
Statement st=con.createStatement();
st.executeQuery("select * from member");
ResultSet rs=st.getResultSet();
st.close();
con.close();
%>
<tabel cellpadding="15" border="1" style="background-color: #ffffcc">
<tr>
<td> Password </td>
<td> User Name </td>
<td> Email </td>
<%while(rs.next()){%>
<tr>
<td><%=rs.getString("pass")%></td>
<td><%=rs.getString("name")%></td>
<td><%=rs.getString("email")%></td>
</tr>
<tr>
<td> <input type="checkbox" name="del" value=<%=rs.getString("pass")%> /> </td>
</tr>
</tabel>
<%}%>
</body>
</html>
.................................................. ..................
خطايي كه ميده اينه:
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: javax.servlet.ServletException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. ClientConnectionId:d89bad6f-807a-47cf-aae9-ca003e4a844e
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:549)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:455)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)
org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:393)
root cause
javax.servlet.ServletException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. ClientConnectionId:d89bad6f-807a-47cf-aae9-ca003e4a844e
org.apache.jasper.runtime.PageContextImpl.doHandle PageException(PageContextImpl.java:911)
org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:840)
org.apache.jsp.index_jsp._jspService(index_jsp.jav a:136)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)
org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:393)
root cause
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. ClientConnectionId:d89bad6f-807a-47cf-aae9-ca003e4a844e
com.microsoft.sqlserver.jdbc.SQLServerException.ma keFromDatabaseError(SQLServerException.java:216)
com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF (tdsparser.java:254)
com.microsoft.sqlserver.jdbc.TDSParser.parse(tdspa rser.java:84)
com.microsoft.sqlserver.jdbc.SQLServerConnection.s endLogon(SQLServerConnection.java:2908)
com.microsoft.sqlserver.jdbc.SQLServerConnection.l ogon(SQLServerConnection.java:2234)
com.microsoft.sqlserver.jdbc.SQLServerConnection.a ccess$000(SQLServerConnection.java:41)
com.microsoft.sqlserver.jdbc.SQLServerConnection$L ogonCommand.doExecute(SQLServerConnection.java:222 0)
com.microsoft.sqlserver.jdbc.TDSCommand.execute(IO Buffer.java:5696)
com.microsoft.sqlserver.jdbc.SQLServerConnection.e xecuteCommand(SQLServerConnection.java:1715)
com.microsoft.sqlserver.jdbc.SQLServerConnection.c onnectHelper(SQLServerConnection.java:1326)
com.microsoft.sqlserver.jdbc.SQLServerConnection.l ogin(SQLServerConnection.java:991)
com.microsoft.sqlserver.jdbc.SQLServerConnection.c onnect(SQLServerConnection.java:827)
com.microsoft.sqlserver.jdbc.SQLServerDriver.conne ct(SQLServerDriver.java:1012)
java.sql.DriverManager.getConnection(DriverManager .java:582)
java.sql.DriverManager.getConnection(DriverManager .java:207)
org.apache.jsp.index_jsp._jspService(index_jsp.jav a:81)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)
org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:393)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.27 logs.
--------------------------------------------------------------------------------
Apache Tomcat/7.0.27
ممنون ميشم اگه كمكم كنيد
من تو jsp زياد وارد نيستم:ناراحت:
با تشكر