1. Import the jar package:
Hibernate-release-4.3.5.final/lib/optional/*.jar
2. Join the configuration:
<!--configuring C3P0 data Source- <property name= "hibernate.c3p0.max_size" >10</property> <property Name= "Hibernate.c3p0.min_size" >5</property> <property name= "C3p0.acquire_increment" >2</ property> <property name= "C3p0.idle_test_period" >2000</property> <property name= " C3p0.timeout ">2000</property> <property name=" C3p0.max_statements ">10</property>
hibernate.c3p0.max_size: Maximum number of connections to the database connection pool
Hibernate.c3p0.min_size: Minimum number of connections to the database connection pool
Hibernate.c3p0.timeout: The Connection object in the database connection pool should be destroyed when it has not been used for a long time
Hibernate.c3p0.max_statements: Number of cached Statement objects
Hibernate.c3p0.idle_test_period: Indicates how long the connection pool detection thread is detecting whether all linked objects within the pool have timed out. The connection pool itself does not
Will remove itself from the connection pool, but instead dedicate a thread to do it at a certain time interval by comparing the connection object with the last
The time difference between the times used and the current time to compare with timeout, and then decide whether to destroy the connection object.
Hibernate.c3p0.acquire_increment: How many database connections are acquired at the same time when a connection in the database connection pool is exhausted