关于 Tomcat , Jsp 的两个问题

如果没有我可以发给你 SQL SERVER2000 JDBC驱动
[email protected]

1、不能在系统服务里启动，是因为你在装tomcat的时候没有选中把它作为一个系统服务安装。
解决方法：
1、重装tomcat
2、找第三方工具安装，
建议使用重装

我将 JDBC 驱动装好,并且指定 CLASSPATH=C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib用 test.jsp :<%@ 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://localhost:1433;DatabaseName=Test";
//pubs为你的数据库的
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 test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为：<%=rs.getString(1)%>
<%}%>
<%out.print("数据库操作成功，恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html> http://localhost:8080/test.jsp  // test.jsp 在 Root 目录下
页面显示 : HTTP Status 500 -
还有一大页错误怎么回事啊 , 真搞不懂了

test.jsp 文件放在root下吗？
JDBC下载放在tomcat的lib下就行，与classpath没有关系

错误： HTTP Status 500 -
还有一大页错误怎么回事啊 , 真搞不懂了to kongxiangli(笑看红尘) : "JDBC下载放在tomcat的lib下就行" ---- 何意 ? 是将 JDBC 安装在 Tomcat 的 Lib 目录下 ?

String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Test";
//pubs为你的数据库的 ^^^^^^^^^^ ^^^^
这段配置你改成你自己的了吗？

错误贴出来一看就知道了，现在来看最大的可能性是没有将sql的jdbc copy到lib文件夹下

在来看最大的可能性是没有将sql的jdbc copy到lib文件夹????怎么做 ?

先去微软网站去把odbc for sql server 2000载下来，然后随意安装在一个目录下。
再把msbase.jar，mssqlserver.jar，msutil.jar三个文件拷贝到JAVA_HOME\jre\lib\ext目录下，最后再将classpath环境变量指向这三个变量所在位置即可。

我也好像没有把jdbc放在jre下面
非常感谢！

可能没有说清楚 : 1 . 下载了 JDK ,安装于 :      C:\Program Files\j2sdk_nb\j2sdk1.4.2\   目录下   环境变量 (Windows 2000 Professional)
     用户变量 :
       PATH=c:\ssh;C:\Program Files\j2sdk_nb\j2sdk1.4.2\bin;C:\Program Files\j2sdk_nb\j2sdk1.4.2\lib
       CLASSPATH=C:\Program Files\j2sdk_nb\j2sdk1.4.2\jre\lib\ext
     系统变量 :
       JAVA_HOME=C:\Program Files\j2sdk_nb\j2sdk1.4.2
  Dos 下  java 可以出现提示 2 . 下载 tomcat-4.1.18.exe ,安装无误    路径 : C:\Program Files\Apache Group\Tomcat 4.1 3 . 下载 Sql Server 2000 JDBC Driver(只有一个安装文件和一个文档,是否不全 ?),安装无误    路径 : C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC

4 . http://localhost:8080

     小猫可以出现 5 .将 C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib 下三个
文件 : msbase.jar , mssqlserver.jar , msutil.jar  复制到:C:\Program Files\j2sdk_nb\j2sdk1.4.2\jre\lib\ext    // 调试不成功
复制到:C:\Program Files\j2sdk_nb\j2sdk1.4.2\lib            // 调试不成功
复制到:C:\Program Files\Apache Group\Tomcat 4.1\common\lib // 调试不成功

// 以上复制是三次分开调试,不是一次出错信息 :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: com.microsoft.jdbc.sqlserver.SQLServerDriver
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
at java.lang.Thread.run(Thread.java:534)
root cause (转下)

javax.servlet.ServletException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:533)
at org.apache.jsp.test_jsp._jspService(test_jsp.java:74)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
at java.lang.Thread.run(Thread.java:534)--------------------------------------------------------------------------------Apache Tomcat/4.1.18--------------------------------------------------------------------------      调试用 test.jsp : // 路径 : C:\Program Files\Apache Group\Tomcat 4.1\webapps\ROOT<%@ 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://localhost:1433;DatabaseName=Test";
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 test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为：<%=rs.getString(1)%>
<%}%>
<%out.print("数据库操作成功");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>-------------------------------------------------------------------------------
-------------------------------------------------------------------------------请大家帮我看看哪儿不对 , 谢谢

调试易

关于 Tomcat , Jsp 的两个问题

解决方案 »