【方法一】在Tomcat4中，配置連接池，常見的就是在server.XML和web.xml中作相應(yīng)配置。在針對單個項目文件情況下，Tomcat5中我們可以不在server.xml中配置Context（實際上，我們在server.xml中默認(rèn)情況下沒有看見Context標(biāo)記）,可以在jakarta-tomcat-5.0.27confCatalinalocalhost下針對具體的文件夾名.xml（如：我的是blog.xml)中配置Context,這樣也就免去了在web.xml中還要配置。<?xml version='1.0' encoding='gb2312'?><Context displayName='Cactus Blog Web Application 1.0' docBase='F:jakarta-tomcat-5.0.27webappsblog' path='/blog' workDir='workCatalinalocalhostblog'><Resource auth='Container' description='Oracle DataBase' name='jdbc/blog' type='Javax.sql.DataSource'/> <ResourceParams name='jdbc/blog'> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>maxWait</name> <value>-1</value> </parameter> <parameter> <name>maxActive</name> <value>10</value> </parameter> <parameter> <name>passWord</name> <value>。。</value> </parameter> <parameter> <name>url</name> <value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=blog</value> </parameter> <parameter> <name>driverClassName</name> <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value> </parameter><!--對應(yīng)oracle參數(shù);<parameter> <name>url</name> <value>jdbc:oracle:thin:@localhost:1521:mydata</value> </parameter> <parameter> <name>driverClassName</name> <value>oracle.jdbc.driver.OracleDriver</value> </parameter>--> <parameter> <name>maxIdle</name> ;;;<value>10</value> </parameter> <parameter> <name>username</name> <value>sa</value> </parameter> </ResourceParams></Context>/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////總結(jié)：Tomcat5中，可以不在server.xml和web.xml中配置就能實現(xiàn)連接池配置；這應(yīng)該是Tomcat5的功能相對Tomcat4的提高，有些朋友在Tomcat5中（使用在Tomcat4中配置方法）來配置連接池不能正常使用，可以采用這個方法，更快捷！！//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////【方法二】看到關(guān)注這方面內(nèi)容人比較多，考慮到各人理解層度不一樣，現(xiàn)把常見配置方式具體步驟也增加上來（tomcat-5.0.27），對tomcat5都適用。第一步：在tomcat的治理員界面中設(shè)置Data Source(commonlib下增加oracle驅(qū)動：classes12.jar.classes12-for oracle8.jar) JNDI Name:; jdbc/mydata Data Source URL:; jdbc:oracle:thin:@localhost:1521:mydata; JDBC Driver Class: oracle.jdbc.driver.OracleDriver User Name:。。。 //如system Password:;。。。//如manager Max. Active Connections: 4 Max. Idle Connections:2; Max. Wait for Connection:5000 Validation Query: 第二步：在jakarta-tomcat-5.0.27webappsDeoWebWEB-INF的web.xml配置<?xml version='1.0' encoding='ISO-8859-1'?> <!DOCTYPE web-app PUBLIC '-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN' 'http://java.sun.com/dtd/web-app_2_3.dtd'> <web-app> <display-name>My Web Application</display-name> <description> MY homesite.</description><resource-ref> <description> oracle DataSource </description> <res-ref-name> jdbc/mydata </res-ref-name> <res-type> javax.sql.DataSource </res-type> <res-auth> Container </res-auth> </resource-ref></web-app> 第三步：啟動tomcat后confconfserver.xml自動變成了這個樣子（自動發(fā)布為全局連接池）：<?xml version='1.0' encoding='utf-8'?> <Server> <Listener className='org.apache.catalina.mbeans.ServerLifecycleListener'/> <Listener className='org.apache.catalina.mbeans.GlobalResourcesLifecycleListener'/> <GlobalNamingResources> <Environment name='simpleValue' type='java.lang.Integer' value='30'/> <Resource auth='Container' description='User database that can be updated and saved' name='UserDatabase' type='org.apache.catalina.UserDatabase'/> <Resource name='jdbc/mydata' type='javax.sql.DataSource'/> <ResourceParams name='UserDatabase'> <parameter> <name>factory</name> <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value> </parameter> <parameter> <name>pathname</name> <value>conf/tomcat-users.xml</value> </parameter> </ResourceParams> <ResourceParams name='jdbc/mydata'> <parameter> <name>maxWait</name> <value>5000</value> </parameter> <parameter> <name>maxActive</name> <value>4</value> </parameter> <parameter> <name>password</name> <value>manager</value> </parameter> <parameter> <name>url</name> <value>jdbc:oracle:thin:@localhost:1521:mydata</value> </parameter> <parameter> <name>driverClassName</name> <value>oracle.jdbc.driver.OracleDriver</value> </parameter> <parameter> <name>maxIdle</name> <value>2</value> </parameter> ;;;<parameter> <name>username</name> <value>system</value> </parameter> </ResourceParams> </GlobalNamingResources> <Service name='Catalina'> <Connector acceptCount='100' connectionTimeout='20000' disableUploadTimeout='true' port='8080' redirectPort='8443' maxSpareThreads='75' maxThreads='150' minSpareThreads='25'> </Connector> <Connector port='8009' protocol='AJP/1.3' protocolHandlerClassName='org.apache.jk.server.JkCoyoteHandler' redirectPort='8443'> </Connector> <Engine defaultHost='localhost' name='Catalina'> <Host appBase='webapps' name='localhost'> <Context path=' ' docBase='.'/> <Logger className='org.apache.catalina.logger.FileLogger' prefix='localhost_log.' suffix='.txt' timestamp='true'/> </Host> <Logger className='org.apache.catalina.logger.FileLogger' prefix='catalina_log.' suffix='.txt' timestamp='true'/> <Realm className='org.apache.catalina.realm.UserDatabaseRealm'/> </Engine> </Service></Server>第四步：寫了個簡單jsp測試：<!DOCTYPE Html PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'><%@ page contentType='text/html; charset=iso-8859-1' %><%@ page import='java.sql.*'%><%@ page import='javax.sql.*'%><%@ page import='javax.naming.*'%><html><head><meta http-equiv='Content-Type' content='text/html; charset=gb2312'><title></title><% out.println('Test begin!');try{InitialContext ctx=new InitialContext(); out.println('First sUCcess!');DataSource ds=(DataSource)ctx.lookup('java:comp/env/jdbc/mydata'); out.println('Second success!');Connection conn = ds.getConnection(); out.println('Third success!'); Statement stmt = conn.createStatement();String strSql = 'select * from sys.signon';ResultSet rs = stmt.executeQuery(strSql);while(rs.next()){;;;out.print(rs.getString(1));}out.print('我的測試結(jié)束'); ; }catch(Exception ex){;;;;out.print('There is exception:'+ex.getMessage());;ex.printStackTrace();} %></head><body></body></html>