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 <[email protected]> > 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: [email protected] > For additional commands, e-mail: [email protected] > >
