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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org