tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pid <...@pidster.com>
Subject Re: JDBC Pool Disconnections
Date Thu, 07 Apr 2011 11:16:38 GMT
On 4/6/11 8: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.

Which DB driver are you using?  In my experience some of the jTDS driver
variations have issues.


p


> 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
>>
>>
> 



Mime
View raw message