I wanted to add the last string as well, but they said to forget about it.. :] and they should know best however, if disconnections will continue (there are some right now) I'll try it anyway
as for the connection validation = you said that if the DB closes a connection (why does it happen? can I prevent it?) than the pool is checking if the connection is open and working. and if not? i the DB closed the connection and it's not usable.. then what does the pool do? 2011/4/6 Filip Hanik - Dev Lists <devli...@hanik.com> > validate == connection is open and working > > if they are worried about performance, there is a compromise that gets you > best of both worlds > > > testOnBorrow="true" > validationQuery="select 1" > validationInterval="30000" > > this ensures that in a high concurrency environment, the number of > validations are limited > > Filip**** > > > > > On 4/6/2011 1: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. >> >> 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 >>> >>> >>> >> >> ----- >> No virus found in this message. >> Checked by AVG - www.avg.com >> Version: 10.0.1209 / Virus Database: 1500/3555 - Release Date: 04/06/11 >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
