I am using Spring ORM (2.5.6) with hibernate (3.3.2.GA). For the database connection pooling i have used c3p0 (0.9.1.2) with oracle 10g.
Can anyone explain me how exactly the connection pooling works ? As per my knowledge we cannot have a connection open for a long period of time. It's generally preferred to open a connection, do the transaction and then close it.
I was looking at the c3p0 implementation (com.mchange.v2.c3p0.ComboPooledDataSource). It uses the javax.sql.PooledConnection ?
Can anyone please explain how exactly is the PooledConnection implemented ?
Thanks in advance.