JSP连接SQL2000求教

死海文书

但是我用peter-yue提供的测试代码却成功显示了jobs表的内容如下：
==============================================================
以下是从Ms SQL Server2000数据库读取的数据： 1 New Hire - Job not specified 10 10 2 Chief Executive Officer 200 250 3 Business Operations Manager 175 225 4 Chief Financial Officier 175 250 5 Publisher 150 250 6 Managing Editor 140 225 7 Marketing Manager 120 200 8 Public Relations Manager 100 175 9 Acquisitions Manager 75 175 10 Productions Manager 75 165 11 Operations Manager 75 150 12 Editor 25 100 13 Sales Representative 25 100 14 Designer 25 100
===============================================================================
现在不明白另两个不成功的原因，大家能帮忙分析下不？
三个代码用的是同样的数据库，用户，密码等

wqbi

最初由 死海文书 发布
[B]我用 wqbi 的代码，页面提示无法连接数据库 [/B]

我的是可以的，SQL Server 2000+tomcat5.5+eclipse3.0

peter-yue

上面提示你的tamcat设置出现严重的错误,建议你使用缺省设置,你自己改过什么你自己清楚,
什么原因出现的问题谁也看不出来

hzskkkk

我也出现了类似的错误,是不是因为没有java.sql.*?还希望各位高手给点意见？

wqbi

最初由 hzskkkk 发布
[B]我也出现了类似的错误,是不是因为没有java.sql.*?还希望各位高手给点意见？ [/B]

这个更看不明白，你出现什么错误？

hzskkkk

错误如下rg.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: -1 in the jsp file: null

Generated servlet error:
    [javac] Since fork is true, ignoring compiler setting.
    [javac] Compiling 1 source file
    [javac] Since fork is true, ignoring compiler setting.



        at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:130)
        at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:293)
        at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:353)
        at org.apache.jasper.compiler.Compiler.compile(Compiler.java:370)
        at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:473)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:190)
        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:256)
        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:171)
        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:594)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
        at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
        at java.lang.Thread.run(Thread.java:534)

wqbi

这个不是驱动问题，而是环境配置问题吧

死海文书

现在用wqbi的代码也可以了。
不过tomcat我从来就没有动过他的设置。