maryamsaedi91
یک شنبه 26 خرداد 1392, 20:00 عصر
سلام دوستان من در اجراي صفحه jsp كه به ديتابيس sql متصله يه مشكل دارم
زمان اجرا اين خطا رو ميده كسي ميتونه بهم كمك كنه چرا اين خطا رو ميده.
صفحه 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.SQLServerDriver");
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: java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:522)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:416)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:390)
root cause
java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304)
com.microsoft.sqlserver.jdbc.SQLServerDriver.conne ct(SQLServerDriver.java:1011)
java.sql.DriverManager.getConnection(DriverManager .java:579)
java.sql.DriverManager.getConnection(DriverManager .java:243)
org.apache.jsp.membershow_jsp._jspService(membersh ow_jsp.java:75)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:390)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
--------------------------------------------------------------------------------
Apache Tomcat/6.0.18
....................................
من يه ديتابيس هم تو sql به اسم member ساختم
اگه كسي ميتونه بهم كمك كنه خيلي واجبه حتما يابد درست كنم ممنون
زمان اجرا اين خطا رو ميده كسي ميتونه بهم كمك كنه چرا اين خطا رو ميده.
صفحه 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.SQLServerDriver");
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: java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:522)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:416)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:390)
root cause
java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304)
com.microsoft.sqlserver.jdbc.SQLServerDriver.conne ct(SQLServerDriver.java:1011)
java.sql.DriverManager.getConnection(DriverManager .java:579)
java.sql.DriverManager.getConnection(DriverManager .java:243)
org.apache.jsp.membershow_jsp._jspService(membersh ow_jsp.java:75)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:390)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
--------------------------------------------------------------------------------
Apache Tomcat/6.0.18
....................................
من يه ديتابيس هم تو sql به اسم member ساختم
اگه كسي ميتونه بهم كمك كنه خيلي واجبه حتما يابد درست كنم ممنون