dbcp c3po 数据库连接池(国外英语资料).docVIP

dbcp c3po 数据库连接池(国外英语资料) One: what is a DBCP? One of the major database connection pools (DBCP, c3p0, proxool), and the DBCP alone is required to use the Commons - dbpc-jar, Commons - collection.jar, Commons - pool.jar, You can go up and down the Apache organizations website (). In the Spring configuration bean id = ds0 class = mons. DBCP. BasicDataSource destroy - method = close property name = url value = JDBC: mysql: / / 12:3306 / vidc property name = driverClassName value = com.mysql. JDBC. Driver / property name = username value = vidc / property name = password value = 1234 / property name = initialSize value = 1 / property name = maxActive value = 3 / property name = maxIdle value = 2 / property name = minIdle value = 1 / / bean Two: the difference between DBCP and c3po Regardless of the persistence technique, you must access the database through the data connection, which is obtained through the data source. In previous applications, data sources were typically provided by Web application servers. In Spring, you can get the application server through the JNDI data source, also can be directly in the Spring container configuration data sources, in addition, you can also create a data source, by means of code for without relying on the unit tests Configure a data source Spring has a third party dependency package that contains the implementation class package for two data sources, one for Apaches DBCP and the other for C3P0. You can use either of these two configuration data sources in the Spring configuration file. DBCP data source DBCP class package in the/lib/Jakarta Commons/Commons - DBCP. Jar, DBCP is a dependent Jakarta Commons - the pool object pooling mechanisms of database connection pool, so in the classpath must also include/lib/Jakarta Commons/Commons - pool. The jar. Here is the configuration snippet to configure the MySql data source with DBCP: XML code bean id = dataSource class = . DBCP. BasicDataSource Destroy - method =