tomcat连接池配置
Tomcat文档说明 http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html
Tomcat4的数据库连接池配置 http://www.7880.com/Info/Article-37ebcbc0-2.html
tomcat连接池的配置与使用(原创)数据库mysql  http://www.7880.com/Info/Article-37f05fa0.html简单过程:1.配置server.xml,在对应位置添加如下信息(楼主自己作相应修改)。在此之前应该把classes2.jar复制到%tomcat_home%\common\lib\目录下
  <Context path="/OracleDBP" docBase="OracleDBP"
        debug="5" reloadable="true" crossContext="true">    <Resource name="jdbc/myoracle" auth="Container"
              type="javax.sql.DataSource"/> <ResourceParams name="jdbc/myoracle">
  <parameter>
    <name>factory</name>
    <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
  </parameter>
  <parameter>
    <name>driverClassName</name>
    <value>oracle.jdbc.driver.OracleDriver</value>
  </parameter>
  <parameter>
    <name>url</name>
    <value>jdbc:oracle:thin:@192.168.0.193:1521:oradb</value>
  </parameter>
  <parameter>
    <name>username</name>
    <value>gxtax</value>
  </parameter>
  <parameter>
    <name>password</name>
    <value>gxtax</value>
  </parameter>
  <parameter>
    <name>maxActive</name>
    <value>20</value>
  </parameter>
  <parameter>
    <name>maxIdle</name>
    <value>10</value>
  </parameter>
  <parameter>
    <name>maxWait</name>
    <value>-1</value>
  </parameter>
</ResourceParams></Context>2.修改web.xml文件,内容如下:  <?xml version="1.0" encoding="ISO-8859-1"?>
  <web-app xmlns="http://java.sun.com/xml/ns/j2ee"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
   http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"  version="2.4">
 <description>MySQL Test App</description>
 <resource-ref>
     <description>DB Connection</description>
     <res-ref-name>jdbc/myoracle</res-ref-name>
     <res-type>javax.sql.DataSource</res-type>
     <res-auth>Container</res-auth>
 </resource-ref>
</web-app>3.测试代码(jsp)
  <%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.io.*,javax.naming.*,javax.sql.*,java.sql.*"%><html>
<head>
<title>
</title>
</head>
<body bgcolor="#ffffff">
<%
Context initContext = new InitialContext();
Context envContext  = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
System.out.println(conn);
if(conn != null)
conn.close();
%>
</body>
<table><a href = ">下载</A></table>
</html>