Dear All,

what is the maximum and minimum pool size in hibernate.Please help me!!!


regards
arul

The minimum size of your connection pool is 0 (you can never have less than no connections in your pool).

Say you have 10 connections in your pool and they sit there being inactive (no one is using them). When they hit their idle timeout (eg 100s) that connection will be reaped. You will never reap lower than your minimum number of connections (if your min is set to 5 you won't drop lower than that). It is possible to have less connections than your min if your min is greater than 0 (eg at startup... although c3p0 has initialPoolSize).

A connection pool is just a pool of connections (for lack of a better explanation). When you need a connection you get one from the connection pool (I think of it as caching connections). If you set your max connections to 10 for example, and all 10 connections are being used, the user requesting that connection will have to wait until that connection frees up (typically...).

Your max should be set based on your concurrent user load in my opinion.

if you are using C3P0 you should probably check out

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

it has all sorts of nifty things like idle_test_period and acquire_increment etc (you won't have the problems I do).