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:30:20 GMT
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