免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › 数据库技术 › Oracle › jsp+tomcat4+oracle8连接问题
最近访问板块 发新帖
查看: 1313 | 回复: 2
打印 上一主题 下一主题

jsp+tomcat4+oracle8连接问题 [复制链接]

huilili

论坛徽章:
0
跳转到指定楼层
1楼 [收藏(0)] [报告]
发表于 2006-07-30 17:20 |只看该作者 |倒序浏览
请教，我在JSP中连接Oracle，可是网页不能正常运行，请问是什么问题？我的jsp源码和错误信息如下：
源码
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" %>
<html>
        <body>
        <%
        Class.forName("oracle.jdbc.driver.OracleDriver" ).newInstance();
        String url="jdbc: oracle:thin: @127.0.0.1:1521: ee300";
        //orcl为你的数据库的SID
        String user="scott";
        String password="tiger";
        Connection conn= DriverManager.getConnection(url,user,password);
        Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        String sql="select tname from tab";
        ResultSet rs=stmt.executeQuery(sql);
        while(rs.next())
        {
        %>
        您的第一个字段内容为：<%=rs.getString(1)%>
        您的第二个字段内容为：<%=rs.getString(2)%>
        <%
        }
        %>
        <%out.print("数据库操作成功，恭喜你" );%>
        <%
        rs.close();
        stmt.close();
        conn.close();
        %>
</body>
</html>
错误信息：
javax.servlet.ServletException: oracle.jdbc.driver.OracleDriver
        at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:49
        at org.apache.jsp.li_jsp._jspService(li_jsp.java:77)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:19
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:13
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2459)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:132)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:11
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:126)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)


root cause

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1540)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1385)
        at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:149)
        at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:83)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:164)
        at org.apache.jsp.li_jsp._jspService(li_jsp.java:44)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:19
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:13
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2459)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:132)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:11
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:126)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)

我在本论坛搜索了一下，说是应该把把jdbc driver即classes12.jar发到应用的WEB-INF/lib目录下，可是我在我的oracle下的jdbc/lib下只找到了classes12.zip文件，不知道应如何处理。
huilili

论坛徽章:
0
2楼 [报告]
发表于 2006-07-30 17:43 |只看该作者
找到了一个classes12.jar,加入后还是有问题，不过错误信息变了：
javax.servlet.ServletException: No suitable driver
        at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:49
        at org.apache.jsp.li_jsp._jspService(li_jsp.java:77)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:19
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:13
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2459)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:132)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:11
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:126)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)


root cause

java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(DriverManager.java:545)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.apache.jsp.li_jsp._jspService(li_jsp.java:49)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:19
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:13
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2459)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:132)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:11
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:126)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
        at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)

不知道如何解决？
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
huilili

论坛徽章:
0
3楼 [报告]
发表于 2006-07-31 21:39 |只看该作者
没有能解决的高手吗
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP