Hibernate Community • View topic - c3p0 max_size doesn't limit connections

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

c3p0 max_size doesn't limit connections

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

vanyatka

Post subject: c3p0 max_size doesn't limit connections

Posted: Mon Apr 02, 2007 4:47 pm

Beginner

Joined: Fri Jun 09, 2006 4:21 pm
Posts: 23
Location: Reading

Hi all,

Hibernate 3.2
MySQL
c3p0 0.9.1.1

Even though I set maximum c3p0 pool size to 5 in hibernate.xml, the MySQL's SHOW PROCESSES command gives about 20(!) sleeping connections.

Here is c3p0 config part:

Code:

        <property name="c3p0.acquire_increment">1</property>
        <property name="c3p0.idle_test_period">300</property>        <!-- seconds -->
        <property name="c3p0.timeout">10</property>        <!-- seconds -->
        <property name="c3p0.min_size">2</property>
        <property name="c3p0.max_size">5</property>
        <property name="c3p0.max_statements">0</property>

Can anyone suggest what I missed in configuration?
Any clues are much appreciated.

Top

Vivian

Post subject: I also have the same problems

Posted: Sun Aug 19, 2007 1:48 pm

Newbie

Joined: Sun Aug 19, 2007 1:40 pm
Posts: 1

This issue seems to be exactly same what Im trying to figure out!!
I set proper values for c3p0.min_size and c3p0.timeout as well as doing close session. Nevertheless seems not to be closed. As a result the sleeping sessions are always increasing.

If someone have an idea, please help me.
Thanks a lot.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum