广告创意大赛策划书:C3P0连接池详细配置与实现(2)全局使用

来源:百度文库 编辑:中财网 时间:2024/05/08 15:08:54

全局使用c3p0
1. server.xml中GlobalNamingResources
description="DB Connection"
driverClass="org.gjt.mm.mysql.Driver"
maxPoolSize="10"
minPoolSize="2"
acquireIncrement="2"
name="jdbc/mysql1"
user="root"
password="xxxxxx"
factory="org.apache.naming.factory.BeanFactory"
type="com.mchange.v2.c3p0.ComboPooledDataSource"
jdbcUrl="jdbc:mysql://localhost:3306/noticemanager?characterEncoding=UTF-8&useUnicode=TRUE&autoReconnect=true" />

2. context.xml中ResourceLink


3. web.xml

Tomcat Datasource
jdbc/mysql1
javax.sql.DataSource
Container




4.Hibernate中的配置


"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">





5
100
1800
100


org.hibernate.dialect.MySQLDialect


jdbc:mysql://localhost:3306/noticemanager



java:comp/env/jdbc/mysql1

root
xxxxxxxxx
true








JDBC实现:与DateSource相同

try {
Context ctx = new InitialContext();
ds = (DataSource) ctx.lookup("java:comp/env/jdbc/mysql1");
conn = ds.getConnection();
} catch (NamingException e) {
e.printStackTrace();
return null;

} catch (SQLException e) {
e.printStackTrace();
return null;
}