Connection pooling problem with Hibernate and WAS 6.1

[Arun Kumar]

Hi Friends,
I have an application which I am running on websphere application server. The problem with that I am facing is that with WAS connection pool setting I am having the connection leak issue. Thererefor I had to switch to the hibernate connection pool.

   
 <property name="connection.datasource">jdbc/defaultDS</property> 
 <property name="connection.release_mode">auto</property>
 <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
 <property name="hibernate.current_session_context_class">thread</property> 		
 <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
 <property name="hbm2ddl.auto">validate</property> 
 

Here is the additional code I have used to put the hibernate connection pool in place.

   
<property name="connection.url">jdbc:oracle:thin:@server:1526:SID</property>
<property name="connection.username">username</property>
<property name="connection.password">password</property>
<property name="c3p0.min_size">50</property>
<property name="c3p0.max_size">70</property>
<property name="c3p0.timeout">5000</property>
<property name="hibernate.c3p0.max_statements">100</property>
<property name="hibernate.c3p0.idle_test_period">300</property>
<property name="hibernate.c3p0.acquire_increment">2</property>
 

for this to run i have also commented out this line from the above code.

    <property name="connection.datasource">jdbc/defaultDS</property> 

my question is do i need to specify

   <property name="connection.provider_class">something</property>
 

To make it run without connection pool leak.

Thanking everybody in advance.