MY application used below configuration for connection pool in hibernet.cfg.xml file.

property name="connection.pool_size">1</property>


Below is my question?

1) will it enough hibernate take care of the inbuild connection pool.

My application has

Hibernet3.0
EJB
JMS
Websphere6.0

I am trying to use C3p0 , but i am unable to get the connection. I did the below things.

1).created hibernate.prop file and kept in classpath.

hibernate.c3p0.min_size=5
hibernate.c3p0.max_size=20
hibernate.c3p0.timeout=300
hibernate.c3p0.max_statements=50
hibernate.c3p0.idle_test_period=3000


2)configured below things at hibernet.cfg.xml file.

<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.timeout">300</property>
<property name="hibernate.c3p0.max_statements">50</property>
<property name="hibernate.c3p0.idle_test_period">3000</property>

Please help me out guys.

I'd humbly suggest leveraging the WebSphere connection pooling features. Create a datasource in WebSphere, and use it!