请问：Tomcat+Oracle+linux下如何设置tomcat的连接池？顶者有分

[jishibo]

Tomcat+Oracle+linux下如何设置tomcat的连接池？我设置了tomcat的web.xml的内容，可是仍然有错误。提示是
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: cannot get Connection pool.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778)
org.apache.jsp.testdb_jsp._jspService(org.apache.jsp.testdb_jsp:88)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.sql.SQLException: cannot get Connection pool.

如果采用server.xml设置参数
<resource-ref>
<description>Oracle
Datasource example</description>
<res-ref-name>jdbc/OracleDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

，却提示找不到jsp文件
HTTP Status 404 - /testdb.jsp

--------------------------------------------------------------------------------

type Status report

message /testdb.jsp

description The requested resource (/testdb.jsp) is not available.


--------------------------------------------------------------------------------

Apache Tomcat/5.5.4

请指教是怎么回事啊？顶者有分

[jishibo]

土豆块能否说的更详细些啊？

[yangbc]

用tomcat-5.0.28试试，当初第一次用tomcat的时候，是自己手工修改web.xml和server.xml，用了好几天，后来用tomcat-5.0.28,直接在配置页面里设置就成功了

[kingofhawks]

嘿嘿,偶会:)
1.把你的应用部署到webapps目录下
2.在tomcat\config\catalina\localhost下边会自动生成与你应用相关的context.xml
3.在context.xml中编辑如下,这是连接mysql的例子
<Context path="/Sign" debug="0" reloadable="true" docBase="D:\Tomcat 5.0\webapps\Sign" workDir="D:\Tomcat 5.0\webapps\Sign\work" >
<Resource name="jdbc/signlog" auth="Container" type="javax.sql.DataSource" description="sign in out log DB">
</Resource>
<ResourceParams name="jdbc/signlog">
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/signmanage</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value>790629</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30000</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>100</value>
</parameter>
</ResourceParams>
</Context>
4.在web.xml中加上如下标签
<resource-ref>
<res-ref-name> jdbc/signlog </res-ref-name>
<res-type> javax.sql.DataSource </res-type>
<res-auth> Container </res-auth>
</resource-ref>
Congratulations!

[topnk]

帮你顶一下~~