I have the following hibernate.cfg file
<property name="hibernate.c3p0.min_size"> 1</property>
<property name="hibernate.c3p0.max_size"> 1</property>
<property name="hibernate.c3p0.timeout"> 1000</property>
<property name="hibernate.c3p0.max_statements"> 50</property>
<property name="hibernate.c3p0.acquire_increment">1</property>

1.What happens when the max_size limit is reached?

2. Also, can anyone tell me what does max_statements mean? What happens when max_statements is reached?

3. Does c3p0 maintain a separate cache of SQL statements besides the hibernate 1st level cache. Is there a way to view this cache

4. I have configured a DataSource with the connection Pool of the datasource with following attributes
InitialCapacity=20
MaxCapacity=40
CapacityIncrement=2

I am using this DataSource for the hibernate to connect.
Which connection Pool will be given a preference, the C3P0 or the DataSource connection pool.

Please help!!!

Hope the C3P0 developers can assist me to understand this.

Hi,

there are some basic explanations here:

http://www.hibernate.org/214.html

The full c3p0 documentation can be found here:

http://www.mchange.com/projects/c3p0/index.html

Hope this helps a bit.