You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@struts.apache.org by hernux <he...@etherac.com.ar> on 2003/12/18 07:38:44 UTC

Connection Pooling

Hi all,

I'm having problems with db pooling, in my sistem, there is a process that creates lot's of subsystems, and it opens lots of connections in the pool... I have to create 380 subsystems, but I can't create more than 4 at once.....at number 5, pool dies .. out of conexions it sais..

So, I got two cuestions... 

1- what am I doing wrong?...
2- is it posible to clean the pool by code, avoiding to restart tomcat every time pool dies?

I'm using struts dbpooling .. here's my config:

<data-source>
<set-property property="autoCommit" value="false" />
<set-property property="description" value="Conexión a la base de datos" />
<set-property property="driverClass" value="org.postgresql.Driver" />
<set-property property="maxCount" value="256" />
<set-property property="minCount" value="20" />
<set-property property="user" value="xxx" />
<set-property property="password" value="xxx" />
<set-property property="url" value="jdbc:postgresql://xxx/xxx" />
</data-source>

Thanx...