To find the problem you should create a special version of commons-pool with extra logging. Put a printStacktrace in the pool.close() method and see who is calling it.
-- Dirk
Pedro Gonçalves wrote:
Sorry, but i cant send you a war..
Its a application of datamining, and many threads running.. in the middle of process the exception appears.. but then others queries are executed...
This is my data-source..
<set-property property="autoCommit" value="false"/>
<set-property property="description"
value="SmartBaseGrid Database"/>
<set-property property="driverClass"
value="org.gjt.mm.mysql.Driver"/>
<set-property property="maxActive" value="150"/>
<set-property property="testOnBorrow" value="true"/>
<set-property property="testOnReturn" value="false"/>
<set-property property="validationQuery" value="SELECT
1"/> <set-property property="removeAbandoned"
value="false"/> <set-property property="maxCount" value="500"/>
<set-property property="minCount" value="5"/>
<set-property property="timeBetweenEvictionRunsMillis"
value="600000"/>
<set-property property="minEvictableIdleTimeMillis"
value="600000"/>
<set-property property="maxIdle" value="2"/>
<set-property property="minIdle" value="1"/>
<set-property property="maxWait" value="-1"/> <set-property property="testWhileIdle" value="true"/>
<set-property property="url"
value="jdbc:mysql://192.168.0.5/sbdesenv"/>
<set-property property="user" value="sbase"/>
<set-property property="password" value="sbase"/>
Anything wrong?
Thanks all
--- Dirk Verbeeck <[EMAIL PROTECTED]> wrote:
Normally it shouldn't close on its own and I have never seen it happen. Can you create a small and simple test war showing the problem?
-- Dirk
Pedro Gonçalves wrote:
Is there any reason for my pool closing alone?
I dont manager the pool, i only get the data
source in
the action of struts.. what the reasons that makes
the
pool close?
thanks all
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
