Drop connection pooling in struts and either go to Container pooling or use a product like Poolman (on sourceforge). Struts DataSource is no longer supported.
Edgar > -----Original Message----- > From: hernux [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 18, 2003 1:39 AM > To: [EMAIL PROTECTED] > Subject: 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... > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]