Tomcat4 数据库连接池的问题，各位帮忙看一下

Question

Context initCtx = new InitialContext();
   Context ctx = (Context) initCtx.lookup("java:comp/env");
   //获取连接池对象
   Object obj = (Object) ctx.lookup("jdbc/SqlServerDB");
--------------------------------------------------------------- 改成如下
Context initCtx = new InitialContext();
Object obj = (Object) initCtx.lookup("jdbc/SqlServerDB");然后把这句ex.printStackTrace();打印出来的信息贴出来，你只抛出自己定义错误信息的SQLException，很难判断

Answer 1

还是不行啊avax.servlet.ServletException: cannot get Connection pool.
 at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:471)
 at org.apache.jsp.testdb$jsp._jspService(testdb$jsp.java:98)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
 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:243)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
 at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
 at java.lang.Thread.run(Thread.java:534)
root cause java.sql.SQLException: cannot get Connection pool.
 at org.apache.jsp.testdb$jsp._jspService(testdb$jsp.java:87)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
 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:243)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
 at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
 at java.lang.Thread.run(Thread.java:534)

Answer 2

你上面贴的是页面显示出来的异常信息，没有找到有用的。
你要贴控制台ex.printStackTrace();这句打出来的log，你还是把
throw new SQLException("cannot get Connection pool.");
这句先注释掉

Answer 3

Context initCtx = new InitialContext();
   Context ctx = (Context) initCtx.lookup("java:comp/env");
   //获取连接池对象
   Object obj = (Object) ctx.lookup("jdbc/SqlServerDB");
--------------------------------------------------------------- 改成如下
try{
Context initCtx = new InitialContext();
Object obj = (Object) initCtx.lookup("java:SqlServerDB");
}catch(Exception e){
System.out.println(e.getmessage());
}
这样就可以得到为什么错误的信息了

Answer 4

代码我该过来了。C:\JBuilderX\jdk1.4\bin\javaw -classpath "C:\JBuilderX\thirdparty\jakarta-tomcat-4.0.6-LE-jdk14\bin\bootstrap.jar;C:\JBuilderX\jdk1.4\lib\tools.jar"  -Dcatalina.home="C:/JBuilderX/thirdparty/jakarta-tomcat-4.0.6-LE-jdk14"  org.apache.catalina.startup.Bootstrap -config "C:\Tomcat 4.0\webapps\ROOT\Pool\Tomcat\conf\server8080.xml" start 
HttpConnector Opening server socket on all host IP addressesStarting service Tomcat-StandaloneApache Tomcat/4.0.6WebappLoader[/WebModule1]: Deploying class repositories to work directory C:\Tomcat 4.0\webapps\ROOT\Pool\Tomcat\work\WebModule1WebappLoader[/WebModule1]: Deploy JAR /WEB-INF/lib/commons-collections.jar to C:\Tomcat 4.0\webapps\ROOT\Pool\WebModule1\WEB-INF\lib\commons-collections.jarWebappLoader[/WebModule1]: Deploy JAR /WEB-INF/lib/commons-dbcp.jar to C:\Tomcat 4.0\webapps\ROOT\Pool\WebModule1\WEB-INF\lib\commons-dbcp.jarWebappLoader[/WebModule1]: Deploy JAR /WEB-INF/lib/commons-pool.jar to C:\Tomcat 4.0\webapps\ROOT\Pool\WebModule1\WEB-INF\lib\commons-pool.jarWebappLoader[/WebModule1]: Deploy JAR /WEB-INF/lib/msbase.jar to C:\Tomcat 4.0\webapps\ROOT\Pool\WebModule1\WEB-INF\lib\msbase.jarWebappLoader[/WebModule1]: Deploy JAR /WEB-INF/lib/mssqlserver.jar to C:\Tomcat 4.0\webapps\ROOT\Pool\WebModule1\WEB-INF\lib\mssqlserver.jarWebappLoader[/WebModule1]: Deploy JAR /WEB-INF/lib/msutil.jar to C:\Tomcat 4.0\webapps\ROOT\Pool\WebModule1\WEB-INF\lib\msutil.jarWebappLoader[/WebModule1]: Reloading checks are enabled for this ContextStandardManager[/WebModule1]: Seeding random number generator class java.security.SecureRandomStandardManager[/WebModule1]: Seeding of random number generator has been completedContextConfig[/WebModule1]: Added certificates -> request attribute ValveStandardWrapper[/WebModule1:default]: Loading container servlet defaultStandardWrapper[/WebModule1:invoker]: Loading container servlet invokerHttpConnector[8080] Starting background threadjavax.naming.NameNotFoundException: Name jdbc is not bound in this Context at org.apache.naming.NamingContext.lookup(NamingContext.java:811) at org.apache.naming.NamingContext.lookup(NamingContext.java:194) at org.apache.naming.SelectorContext.lookup(SelectorContext.java:183) at javax.naming.InitialContext.lookup(InitialContext.java:347) at org.apache.jsp.testdb$jsp._jspService(testdb$jsp.java:74) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473) 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:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125) at java.lang.Thread.run(Thread.java:534)

Answer 5

前两天我也出了同样的问题，后来我换了个版本，重新配置了一下，就可以了。我用的是tomcat5.0.12.我有一篇文档是自己写的，不知道对你是否有用，如果需要，你把邮箱留下我可以给你发过去。

Answer 6

也给我一份吧[email protected].谢谢!

Answer 7

到底怎么配啊？[email protected]

Answer 8

毛意思，配tomcat的毛什么用处，tomcat不支持ejb配来干什么还比jboss，weblogic麻烦