You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by AMIR-TAHMASSEB Marc <MA...@cus-strasbourg.net> on 2003/04/30 15:58:56 UTC
GenericDataSource maxCount
does any one knows who work the minCount and maxCount in org.apache.struts.util.GenericDataSource ?
it seems that when I try to open more connection than maxCount then server connections are down !?
-----Message d'origine-----
De : AMIR-TAHMASSEB Marc
Envoyé : mercredi 30 avril 2003 09:48
À : 'Struts Users Mailing List'
Objet : GenericDataSource getConnection()
Hi,
I have a problem with the Struts org.apache.struts.util.GenericDataSource "getConnection()" method.
When I submit a form, then I ask a connection from the dataSource to make some SQL operations.
- If I use the submit button "normally" (I click once the button and wait for the response) every thing is ok.
- But if I click several time, very fast, the submit button, then I ask several times a connection because I generate several Actions. In this case after 3,4 or 5... steps, the getConnection() is blocked and it is impossible to access the database anymore from any application running in the tomcat server... The only way is to restart the tomcat server...
The following line is never finished :
Connection conn = dataSource.getConnection();
(I know this because I have traces before and after the line)
can anybody help me ?
Thanks,
Marc AT
-----Original Message-----
From: AMIR-TAHMASSEB Marc [mailto:MAMIR-TAHMASSEB@cus-strasbourg.net]
Sent: Monday, April 28, 2003 4:34 PM
To: struts-user@jakarta.apache.org
Subject: tomcat fowling down
I have a problem with my application.
each time I double (or triple) click a submit button (instead of a simple click) my tomcat server fall out of order ! Then the only way to lunch an application is to restart the tomcat server before !
Does any body had already a problem like this ? and what can be the solution ?
I'm using :
- Struts 1.02
- Tomcat 3.2.4
- Apache 1.3
- jdk 1.3.1_06
- j2ee 1.2.1
- windows nt sp6
- orcale 8i
--
Marc AMIR-TAHMASSEB
mamir-tahmasseb@cus-strasbourg.net
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
Re: GenericDataSource maxCount
Posted by Navjot Singh <na...@net4india.net>.
i had never worked with GenericDataSource so can't tell ya what to change
with that.
But here is the reason -- There is some limit set to the object pool
(default is 8) that store the connections..if that limit is reached the
default behaviour of PoolableConnection is to WAIT INFINTELY till the
connection is available from the pool.
So make sure you are returning your connections back to pool after you have
used it.
or you may set your object pool to GROW if the pool ran short of pooled
connections.
HTH
navjot
----- Original Message -----
From: "AMIR-TAHMASSEB Marc" <MA...@cus-strasbourg.net>
To: <st...@jakarta.apache.org>
Sent: Wednesday, April 30, 2003 7:28 PM
Subject: GenericDataSource maxCount
does any one knows who work the minCount and maxCount in
org.apache.struts.util.GenericDataSource ?
it seems that when I try to open more connection than maxCount then server
connections are down !?
-----Message d'origine-----
De : AMIR-TAHMASSEB Marc
Envoyé : mercredi 30 avril 2003 09:48
À : 'Struts Users Mailing List'
Objet : GenericDataSource getConnection()
Hi,
I have a problem with the Struts org.apache.struts.util.GenericDataSource
"getConnection()" method.
When I submit a form, then I ask a connection from the dataSource to make
some SQL operations.
- If I use the submit button "normally" (I click once the button and wait
for the response) every thing is ok.
- But if I click several time, very fast, the submit button, then I ask
several times a connection because I generate several Actions. In this case
after 3,4 or 5... steps, the getConnection() is blocked and it is impossible
to access the database anymore from any application running in the tomcat
server... The only way is to restart the tomcat server...
The following line is never finished :
Connection conn = dataSource.getConnection();
(I know this because I have traces before and after the line)
can anybody help me ?
Thanks,
Marc AT
-----Original Message-----
From: AMIR-TAHMASSEB Marc [mailto:MAMIR-TAHMASSEB@cus-strasbourg.net]
Sent: Monday, April 28, 2003 4:34 PM
To: struts-user@jakarta.apache.org
Subject: tomcat fowling down
I have a problem with my application.
each time I double (or triple) click a submit button (instead of a simple
click) my tomcat server fall out of order ! Then the only way to lunch an
application is to restart the tomcat server before !
Does any body had already a problem like this ? and what can be the solution
?
I'm using :
- Struts 1.02
- Tomcat 3.2.4
- Apache 1.3
- jdk 1.3.1_06
- j2ee 1.2.1
- windows nt sp6
- orcale 8i
--
Marc AMIR-TAHMASSEB
mamir-tahmasseb@cus-strasbourg.net
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org