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