On 4/6/11 8:36 PM, הילה wrote: > 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.
Which DB driver are you using? In my experience some of the jTDS driver variations have issues. p > 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 >> >> >
signature.asc
Description: OpenPGP digital signature