commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dirk Verbeeck <dirk.verbe...@pandora.be>
Subject Re: Pool and DBCP : Pool not Open
Date Tue, 12 Apr 2005 06:01:01 GMT
Your configuration is ok.
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 <dirk.verbeeck@pandora.be> 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: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message