tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Filip Hanik - Dev Lists <devli...@hanik.com>
Subject Re: JDBC Pool Disconnections
Date Wed, 06 Apr 2011 19:49:41 GMT
validate == connection is open and working

if they are worried about performance, there is a compromise that gets you best of both worlds

testOnBorrow="true"
validationQuery="select 1"
validationInterval="30000"

this ensures that in a high concurrency environment, the number of validations are limited

Filip****



On 4/6/2011 1:36 PM, הילה wrote:
> I wanted to add it, bu the company that developed the application that runs
>
> on the tomcat, says that it affect performance and has issues.
>
> what do you mean "validates it"? what does it do, exactly?
>
> Thanks
> Hila
>
>
> 2011/4/6 Filip Hanik - Dev Lists<devlists@hanik.com>
>
>> On 4/5/2011 7:31 AM, הילה wrote:
>>
>>> name="jdbc/com/vstechnology/appname
>>> scope="Shareable"
>>> type="javax.sql.Datasource"
>>>
>>> url="jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false"
>>> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
>>> maxActive="200"
>>> minIdle="0"
>>> maxIdle="10"
>>> maxWait="10000"
>>> initialSize="20"
>>> driverClassName="net.sourceforge.jtds.jdbc.Driver"
>>>
>> Add in
>>
>> testOnBorrow="true"
>> validationQuery="select 1"
>>
>> this ensures that if the DB closes a connection, the pool validates it
>>
>> best
>> Filip
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1209 / Virus Database: 1500/3555 - Release Date: 04/06/11
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message