Configuring the Tomcat global C3P0 connection pool

Because multiple applications in a project access the same database and are deployed under the same tomcat, it is not necessary to configure connection pooling information for each application, which may result in uneven distribution of resources in the database, so this situation can be fully configured with a Tomcat global connection pool, all of which are accessed by the application involved. Make the database resources fully utilized.

I use the C3P0 connection pool, although the C3P0 has not done the relevant performance test, but the network review is good, using 0.9.1 version, Tomcat uses 7.0.32

The configuration is divided into several steps:

First, configure the data source in Tomcat's Server.xml

Locate the Globalnamingresources node and add the following in it (see the C3P0 official note for specific parameter meanings):

[HTML]View PlainCopyprint?

2. <Resource name="jdbc/db1" auth="Container "
4. type="Com.mchange.v2.c3p0.ComboPooledDataSource"
6. factory="Org.apache.naming.factory.BeanFactory"
8. driverclass="Oracle.jdbc.driver.OracleDriver"
10. jdbcurl="JDBC:ORACLE:THIN:@127.0.0.1:1521:ORCL"
12. user="Scott"
14. password="123456"
16. minpoolsize="Ten"
18. maxpoolsize="
20. maxidletime="1800"
22. acquireincrement="2"
24. maxstatements="0"
26. initialpoolsize="
28. idleconnectiontestperiod="
30. acquireretryattempts="
32. acquireretrydelay="+"
34. testconnectiononcheckin="false"
36. breakafteracquirefailure="false"
38. testconnectiononcheckout="false"/>

Second, in Tomcat under Content.xml to configure the data source corresponding Jndi

[HTML]View PlainCopyprint?

1. <resourcelink name="jdbc/db1" global="jdbc/db1" type="Javax.sql.DataSource" />

Third, put C3P0 jar package, database driver package into Tomcat under the Lib directory

Application access Method:

One, based on spring management, you only need to configure the data source in spring to

[HTML]View PlainCopyprint?

1. <Bean id= "dataSource" class="Org.springframework.jndi.JndiObjectFactoryBean">
2. <property name= "jndiname" value="java:comp/env/jdbc/db1" />
3. </Bean>

Second, write code to get the data source directly through Jndi

[Java]View PlainCopyprint?

2. try {
6. Context CTX = new InitialContext ();
10. Context Envcontext = (context) ctx.lookup ("java:/comp/env"); java:/comp/env as fixed path
14. DataSource ds = (DataSource) envcontext.lookup ("jdbc/db1"); Data sources set in Tomcat
18. Connection con = ds.getconnection ();
22. System.out.println (con);
26. } catch (Exception e) {
30. //TODO auto-generated catch block
34. E.printstacktrace ();
38. }

Configuring the Tomcat global C3P0 connection pool