之前接触的都是dbcp和c3p0,tomcat7也提供了新的连接池,据说更好用,首先要修改context.xml文件:
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<!-- Uncomment this to disable session persistence across Tomcat restarts -->
<!--
<Manager pathname="" />
-->
<!-- Uncomment this to enable Comet connection tacking (provides events
on session expiration as well as webapp lifecycle) -->
<!--
<Valve className="org.apache.catalina.valves.CometConnectionManagerValve" />
-->
<Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" initialSize="5" maxActive="30" maxIdle="10" name="jdbc/******" password="******" type="javax.sql.DataSource" url="jdbc:oracle:thin:@***.***.***.***:****:***" username="******"/>
然后需要在tomcat的lib目录中加入具体的数据库驱动。