On 4/6/11 8:36 PM, =D7=94=D7=99=D7=9C=D7=94 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?
>=20
> Thanks
> Hila
>=20
>=20
> 2011/4/6 Filip Hanik - Dev Lists <devlists@hanik.com>
>=20
>> On 4/5/2011 7:31 AM, =D7=94=D7=99=D7=9C=D7=94 wrote:
>>
>>> name=3D"jdbc/com/vstechnology/appname
>>> scope=3D"Shareable"
>>> type=3D"javax.sql.Datasource"
>>>
>>> url=3D"jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=3Df=
alse;sendStringParametersAsUnicode=3Dfalse"
>>> factory=3D"org.apache.tomcat.jdbc.pool.DataSourceFactory"
>>> maxActive=3D"200"
>>> minIdle=3D"0"
>>> maxIdle=3D"10"
>>> maxWait=3D"10000"
>>> initialSize=3D"20"
>>> driverClassName=3D"net.sourceforge.jtds.jdbc.Driver"
>>>
>> Add in
>>
>> testOnBorrow=3D"true"
>> validationQuery=3D"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
>>
>>
>=20
|