I was following Hibernate Reference Doc: Chapter 3 for configuration.
background:
I have HibernateSessionFactory class to open and close the session but
DBA told me that I was eating up sessions(or processes).
To do connection pooling, I used c3p0 as recommened by Reference Doc.
I have c3p0-0.9.1.jar in my class path and I added configuration to my
hibernate.cfg.xml.
I wrote: <property name="hibernate.c3p0.timeout">100</property>
Still I cannot kill the old existing sessions
I am using session-per-conversation pattern. IDE: MyEclipse and Tomcat
Application Server.
Please help... I have read all online material...nothing is working...
Thanks in Advance. |