TOMCAT已正确配置,因为访问http://localhost/完全正常;MSSQL-JDBC已安装,并将三个jar文件加入了CLASSPATH中。写的最简单程序片段如下: <%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%> <html>
<body> <%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://wjserver:1433;DatabaseName=master";
String user="sa";
String password=""; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from emp_basic";
ResultSet rs=stmt.executeQuery(sql);
结果得到如下错误:HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Exception in JSP: /test_jdbc.jsp:118:
9: <%
10:
11: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
12:
13: String url="jdbc:microsoft:sqlserver://wjserver:1433;DatabaseName=master";
14:
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause javax.servlet.ServletException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.test_005fjdbc_jsp._jspService(org.apache.jsp.test_005fjdbc_jsp:113)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1352)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1198)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:127)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:65)
java.lang.ClassLoader.loadClassInternal(Unknown Source)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
org.apache.jsp.test_005fjdbc_jsp._jspService(org.apache.jsp.test_005fjdbc_jsp:53)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.15 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.5.15不知是何原因。
<%@ page import="java.sql.*"%> <html>
<body> <%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://wjserver:1433;DatabaseName=master";
String user="sa";
String password=""; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from emp_basic";
ResultSet rs=stmt.executeQuery(sql);
结果得到如下错误:HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Exception in JSP: /test_jdbc.jsp:118:
9: <%
10:
11: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
12:
13: String url="jdbc:microsoft:sqlserver://wjserver:1433;DatabaseName=master";
14:
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause javax.servlet.ServletException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.test_005fjdbc_jsp._jspService(org.apache.jsp.test_005fjdbc_jsp:113)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1352)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1198)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:127)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:65)
java.lang.ClassLoader.loadClassInternal(Unknown Source)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
org.apache.jsp.test_005fjdbc_jsp._jspService(org.apache.jsp.test_005fjdbc_jsp:53)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.15 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.5.15不知是何原因。
解决方案 »
- 代码敲多了,在网上发表个东西的时候总是会行惯性的ctrl+s,结果弹出保存整个网页的对话框!有没有?
- 请教问题: 关于jsp动态的显示一定的元素(label)
- 请教一个关于session的问题,散分
- struts2 用*.validation.xml做表单验证,有没有办法指定返回指定验证页面的方法?
- 帮看下这个action的execute方法中的else
- 招聘JAVA软件开发,软件测试
- 谁给我一个简单易懂的连接池代码?最好有注释,就这20分了...
- 如何再網頁裡面做出一個類似資源管器的東東(也要有資源管理器的功能喔)
- 问一条sql语句的显示!
- 关于JS中outlookbar.additem的一个问题
- 请问各位为什么在weblogic8里只能运行html,而不能运行jsp文件呢
- 学习JSP一定要学习HTML javascrip和XML吗
如果能访问到,检查驱动程序,要考到wb_inf\lib下,试试
9: <%
10:
11: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();可能找不到驱动
貌似没捕获异常哦~~
Class.forName()方法会抛出Exception
下面的java.sql.*里定义的方法会抛出SQLException
你把它们放在try catch块里试试
xuyingjun(徐小邪) ( ) 信誉:96 2006-03-07 17:25:00 得分: 0
500是文件找不到,先检查你的web下的文件是否能访问到,如果不能访问到,可能是web.xml错误
如果能访问到,检查驱动程序,要考到wb_inf\lib下,试试