Hi,
this is my first question and hope this will be answered.

My application is in java,jsp,servlet and hibernate. when I am using the following configuration my application is working fast and good.

property name is : <property name="hibernate.connection.pool_size">10</property>

but some time I get exception like "too many connection"

To rectify this I used following properties :

<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.idle_test_period">3000</property>
<property name="hibernate.c3p0.max_statements">50</property>


but this makes my application very slow when I am using select from and insert operation.


I am in middle of my application , I searched a lot but did'nt got solution to it.

Regards,