tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From הילה <hilavalen...@gmail.com>
Subject Re: JDBC Pool Disconnections
Date Wed, 06 Apr 2011 19:36:50 GMT
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
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message