设为首页收藏本站

LinuxSir.cn，穿越时空的Linuxsir!

 找回密码
 注册
搜索
热搜: shell linux mysql
LinuxSir.cn，穿越时空的Linuxsir!»论坛 › 数据库 —— LinuxSir.cn › oracle › （已解决）tomcat 连接 oracle 数据库的问题 ...
返回列表 发新帖
查看: 1089|回复: 2

（已解决）tomcat 连接 oracle 数据库的问题

[复制链接]
发表于 2005-3-9 18:01:46 | 显示全部楼层 |阅读模式
首先说说我的环境：
Debian 3.1 Sarge  Apache2 + tomcat 5.0.30 已经整合
oracle10g 数据库已经安装成功，数据库已经建好。
问题：
对于jsp网页不能连上数据库，从数据库中调用资料，应该是jdbc驱动设置的问题（我的看法），希望曾经做过的兄弟给些建议和指导！谢谢！
这里有些网页显示错误代码和apache和tomcat的日志！

  2. HTTP Status 500 -

  4. --------------------------------------------------------------------------------

  6. type Exception report

  8. message

  10. description The server encountered an internal error () that prevented it from fulfilling this request.

  12. exception

  14. org.apache.jasper.JasperException
  15.         org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
  16.         org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
  17.         org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
  18.         javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


  21. root cause

  23. java.lang.NullPointerException
  24.         org.apache.jsp.Itell.News.index_jsp._jspService(index_jsp.java:244)
  25.         org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
  26.         javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
  27.         org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
  28.         org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
  29.         org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
  30.         javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


  33. note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.


  36. --------------------------------------------------------------------------------

  38. Apache Tomcat/5.0.30
复制代码

Apache 的错误日志：

  2. Sat Sep 11 03:52:17 2004] [error] channelApr.open() attempt to connect to 127.0.0.1:8009 (127.0.0.1) failed 111
  3. [Sat Sep 11 03:52:17 2004] [error] ajp13.connect() failed ajp13:localhost:8009
  4. [Sat Sep 11 03:52:17 2004] [error] ajp13.service() failed to connect endpoint errno=9 Bad file descriptor
  5. [Sat Sep 11 03:52:17 2004] [error] ajp13.service() Error  forwarding ajp13:localhost:8009 1 1
  6. [Sat Sep 11 03:52:17 2004] [error] mod_jk2.handler() Error connecting to tomcat 120000, status 0
  7. [Sat Sep 11 03:52:21 2004] [error] channelApr.open() attempt to connect to 127.0.0.1:8009 (127.0.0.1) failed 111
  8. [Sat Sep 11 03:52:21 2004] [error] ajp13.connect() failed ajp13:localhost:8009
  9. [Sat Sep 11 03:52:21 2004] [error] ajp13.service() failed to connect endpoint errno=9 Bad file descriptor
  10. [Sat Sep 11 03:52:21 2004] [error] ajp13.service() Error  forwarding ajp13:localhost:8009 1 1
  11. [Sat Sep 11 03:52:21 2004] [error] mod_jk2.handler() Error connecting to tomcat 120000, status 0
  12. [Sat Sep 11 03:52:27 2004] [error] channelApr.open() attempt to connect to 127.0.0.1:8009 (127.0.0.1) failed 111
  13. [Sat Sep 11 03:52:27 2004] [error] ajp13.connect() failed ajp13:localhost:8009
  14. [Sat Sep 11 03:52:27 2004] [error] ajp13.service() failed to connect endpoint errno=9 Bad file descriptor
  15. [Sat Sep 11 03:52:27 2004] [error] ajp13.service() Error  forwarding ajp13:localhost:8009 1 1
  16. [Sat Sep 11 03:52:27 2004] [error] mod_jk2.handler() Error connecting to tomcat 120000, status 0
  17. [Sat Sep 11 03:52:35 2004] [notice] caught SIGTERM, shutting down
  18. [Sat Sep 11 03:54:52 2004] [error] shm.create(): error creating shm 2 No such file or directory
  19. [Sat Sep 11 03:54:52 2004] [error] shm.create(): error creating shm /var/run/apache2/logs/shm.file
  20. [Sat Sep 11 03:54:52 2004] [notice] Apache/2.0.53 (Debian GNU/Linux) mod_jk2/2.0.4 configured -- resuming normal operations
  21. [Sat Sep 11 03:55:16 2004] [notice] caught SIGTERM, shutting down
  22. [Sat Sep 11 03:56:35 2004] [error] shm.create(): error creating shm 2 No such file or directory
  23. [Sat Sep 11 03:56:35 2004] [error] shm.create(): error creating shm /var/run/apache2/logs/shm.file
  24. [Sat Sep 11 03:56:35 2004] [notice] Apache/2.0.53 (Debian GNU/Linux) mod_jk2/2.0.4 configured -- resuming normal operations
  25. [Sat Sep 11 03:56:44 2004] [error] ajp13.service() ajpGetReply recoverable error 3
  26. [Sat Sep 11 03:56:44 2004] [error] ajp13.service() ajpGetReply recoverable error 3
  27. [Sat Sep 11 03:56:44 2004] [error] ajp13.service() Error  forwarding ajp13:localhost:8009 1 0
  28. [Sat Sep 11 03:56:44 2004] [error] mod_jk2.handler() Error connecting to tomcat 3, status 200
  29. [Sat Sep 11 05:28:58 2004] [notice] caught SIGTERM, shutting down
  30. [Sat Sep 11 05:29:01 2004] [error] shm.create(): error creating shm 2 No such file or directory
  31. [Sat Sep 11 05:29:01 2004] [error] shm.create(): error creating shm /var/run/apache2/logs/shm.file
  32. [Sat Sep 11 05:29:01 2004] [notice] Apache/2.0.53 (Debian GNU/Linux) mod_jk2/2.0.4 configured -- resuming normal operations
复制代码

tomcat 的日志：

  2. Sep 11, 2004 5:29:02 AM org.apache.catalina.startup.Catalina load
  3. INFO: Initialization processed in 846 ms
  4. Sep 11, 2004 5:29:02 AM org.apache.catalina.core.StandardService start
  5. INFO: Starting service Catalina
  6. Sep 11, 2004 5:29:02 AM org.apache.catalina.core.StandardEngine start
  7. INFO: Starting Servlet Engine: Apache Tomcat/5.0.30
  8. Sep 11, 2004 5:29:02 AM org.apache.catalina.core.StandardHost start
  9. INFO: XML validation disabled
  10. Sep 11, 2004 5:29:02 AM org.apache.catalina.core.StandardHost getDeployer
  11. INFO: Create Host deployer for direct deployment ( non-jmx )
  12. Sep 11, 2004 5:29:02 AM org.apache.catalina.core.StandardHostDeployer install
  13. INFO: Processing Context configuration file URL file:/opt/tomcat/conf/Catalina/localhost/admin.xml
  14. Sep 11, 2004 5:29:04 AM org.apache.catalina.core.StandardHostDeployer install
  15. INFO: Processing Context configuration file URL file:/opt/tomcat/conf/Catalina/localhost/balancer.xml
  16. Sep 11, 2004 5:29:04 AM org.apache.catalina.core.StandardHostDeployer install
  17. INFO: Processing Context configuration file URL file:/opt/tomcat/conf/Catalina/localhost/manager.xml
  18. Sep 11, 2004 5:29:04 AM org.apache.catalina.core.StandardHostDeployer install
  19. INFO: Installing web application at context path  from URL file:/opt/tomcat/webapps/ROOT
  20. Sep 11, 2004 5:29:04 AM org.apache.catalina.core.StandardHostDeployer install
  21. INFO: Installing web application at context path /jsp-examples from URL file:/opt/tomcat/webapps/jsp-examples
  22. Sep 11, 2004 5:29:05 AM org.apache.catalina.core.StandardHostDeployer install
  23. INFO: Installing web application at context path /servlets-examples from URL file:/opt/tomcat/webapps/servlets-examples
  24. Sep 11, 2004 5:29:05 AM org.apache.catalina.core.StandardHostDeployer install
  25. INFO: Installing web application at context path /tomcat-docs from URL file:/opt/tomcat/webapps/tomcat-docs
  26. Sep 11, 2004 5:29:05 AM org.apache.catalina.core.StandardHostDeployer install
  27. INFO: Installing web application at context path /webdav from URL file:/opt/tomcat/webapps/webdav
  28. Sep 11, 2004 5:29:05 AM org.apache.coyote.http11.Http11Protocol start
  29. INFO: Starting Coyote HTTP/1.1 on http-8080
  30. Sep 11, 2004 5:29:05 AM org.apache.jk.common.ChannelSocket init
  31. INFO: JK2: ajp13 listening on /0.0.0.0:8009
  32. Sep 11, 2004 5:29:05 AM org.apache.jk.server.JkMain start
  33. INFO: Jk running ID=0 time=0/72  config=/opt/tomcat/conf/jk2.properties
  34. Sep 11, 2004 5:29:05 AM org.apache.catalina.startup.Catalina start
  35. INFO: Server startup in 2884 ms
  36. aq.executeQuery: invalid arguments in call
  37. dbclass():invalid arguments in call
  38. aq.executeQuery: invalid arguments in call
  39. dbclass():invalid arguments in call
  40. aq.executeQuery: invalid arguments in call
  41. aq.executeQuery: invalid arguments in call
  42. dbclass():invalid arguments in call
  43. aq.executeQuery: invalid arguments in call
复制代码
回复

使用道具 举报

发表于 2005-3-10 10:27:50 | 显示全部楼层
从错误信息看，你的代码里有一个空指针异常，最好是把你的代码贴出来。尤其是连接数据库的那段代码
回复 支持 反对

使用道具 举报

 楼主| 发表于 2005-3-11 11:55:58 | 显示全部楼层
已经解决，谢谢！是Oracle登陆帐号设置错误。
回复 支持 反对

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

快速回复 返回顶部 返回列表