配置环境:tomcat-6.0.29
<Resource name="jdbc/CasDB"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/DB_CAS?useUnicode=true&characterEncoding=utf8&autoReconnect=true"
username="root"
password="123456"
maxPoolSize="20"
minPoolSize="20"
initialPoolSize="20"
maxIdleTime="7200"
idleConnectionTestPeriod="3600"
testConnectionOnCheckin="false"
acquireIncrement="20"
acquireRetryAttempts="30"
acquireRetryDelay="1000"
checkoutTimeout="5000"
maxStatements="0"
testConnectionOnCheckout="false"
preferredTestQuery="select 1"
/>
mysql-connector-5.1.6-bin.jar
c3p0-0.9.1.jar
jstl-1.1-standard.jar
jstl-1.1-jstl.jar
NetBeans-6.9.1
KUbuntu 10.10
1.根据Tomcat6.0的说明文档,首先将数据库连接所用到的jar包导入。
2.编写配置文件:content.xml
<?xml version="1.0" encoding="UTF-8"?>
<Context debug="5" reloadable="true" crossContext="true">
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/DB_CAS?useUnicode=true&characterEncoding=utf8&autoReconnect=true"
username="root"
password="123456"
maxPoolSize="20"
minPoolSize="20"
initialPoolSize="20"
maxIdleTime="7200"
idleConnectionTestPeriod="3600"
testConnectionOnCheckin="false"
acquireIncrement="20"
acquireRetryAttempts="30"
acquireRetryDelay="1000"
checkoutTimeout="5000"
maxStatements="0"
testConnectionOnCheckout="false"
preferredTestQuery="select 1"
/>
</Context>
3.Tomcat6.0建议在web.xml中添加以下内容,但这不是必须的。
<resource-ref>
<res-ref-name>jdbc/dbtest</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<资源
AUTH
=
“
集装箱
”
说明 =“ 数据库 连接”
driverClass = “ com.mysql.jdbc.Driver ”
maxPoolSize = “50”
minPoolSize = “2”
acquireIncrement =“1”
NAME =“ JDBC / dbtest ”
USER = “根”
密码 = “管理员”
工厂 = “ org.apache.naming.factory.BeanFactory ”
类型=“ com.mchange.v2.c3p0.ComboPooledDataSource ”
jdbcUrl =“ jdbc的 : MySQL的: // 本地主机 : 3306 / dbtest autoReconnect的 = TRUE ” / >
说明 =“ 数据库 连接”
driverClass = “ com.mysql.jdbc.Driver ”
maxPoolSize = “50”
minPoolSize = “2”
acquireIncrement =“1”
NAME =“ JDBC / dbtest ”
USER = “根”
密码 = “管理员”
工厂 = “ org.apache.naming.factory.BeanFactory ”
类型=“ com.mchange.v2.c3p0.ComboPooledDataSource ”
jdbcUrl =“ jdbc的 : MySQL的: // 本地主机 : 3306 / dbtest autoReconnect的 = TRUE ” / >