number of connections increase

Ot · **Posted:** Tue Feb 03, 2004 9:30 am

I can't get the number of connections to get constant. In the hibernate.properties file, i have this:

Code:

hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class=org.gjt.mm.mysql.Driver
hibernate.connection.url=jdbc:mysql://localhost/thedbname
hibernate.connection.username=theusername
hibernate.connection.password=thepassword
hibernate.connection.pool_size=3

Isn't it supposed to keep the number of active connections alwais in "3" ? every new database access i do with my application , i get an increment :

Code:

?        S      0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
?        S      0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
?        S      0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
?        S      0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock

If i request a new list of active connections after every request i do with my application, i have a higher number, until my application crashes (in fact, the db crashes).

After every SessionFactory, and after the queries, i always session.flush and session.close.
What am i missing ?

Thanks in advance

emmanuel · **Posted:** Tue Feb 03, 2004 12:17 pm

Don't use hibernate internal connection pool in production. Use your app server one or one whom Hibernate provide conenctors :
c3p0
dbcp
proxool

Ot · **Posted:** Tue Feb 03, 2004 4:04 pm

Would someone show a tutorial or a part of the hibernate docs where i could take a look at this? This is a completely new issue to me...I have to read about using these other features.

Thanks for the advice

Ot · **Posted:** Tue Feb 03, 2004 6:29 pm

thanks to the help. I got it working ;)