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
|