Hey, I'm using JTDS 1.2.5 It has proven to be more stable than the JDBC driver of microsoft, so we're using it.
Thanks Hila 2011/4/7 Pid <p...@pidster.com> > 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 > >> > >> > > > > >
