tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From הילה <hilavalen...@gmail.com>
Subject Re: JDBC Pool Disconnections
Date Fri, 08 Apr 2011 10:08:56 GMT
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 <pid@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 <devlists@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-unsubscribe@tomcat.apache.org
> >> For additional commands, e-mail: users-help@tomcat.apache.org
> >>
> >>
> >
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message