Return-Path: Delivered-To: apmail-tomcat-users-archive@www.apache.org Received: (qmail 84236 invoked from network); 6 Apr 2011 19:49:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 6 Apr 2011 19:49:40 -0000 Received: (qmail 55142 invoked by uid 500); 6 Apr 2011 19:49:37 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 54908 invoked by uid 500); 6 Apr 2011 19:49:36 -0000 Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Tomcat Users List" Delivered-To: mailing list users@tomcat.apache.org Received: (qmail 54899 invoked by uid 99); 6 Apr 2011 19:49:36 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Apr 2011 19:49:36 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [72.22.94.67] (HELO virtual.halosg.com) (72.22.94.67) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Apr 2011 19:49:30 +0000 Received: (qmail 19989 invoked from network); 6 Apr 2011 14:49:09 -0500 Received: from softdnserror (HELO ?172.16.97.165?) (63.76.33.54) by halosg.com with (AES256-SHA encrypted) SMTP; 6 Apr 2011 14:49:08 -0500 Message-ID: <4D9CC3D5.5040105@hanik.com> Date: Wed, 06 Apr 2011 13:49:41 -0600 From: Filip Hanik - Dev Lists User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9 MIME-Version: 1.0 To: Tomcat Users List Subject: Re: JDBC Pool Disconnections References: <4D9CBF4C.10809@hanik.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org 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 > >> 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 >> >> > > > ----- > 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-unsubscribe@tomcat.apache.org For additional commands, e-mail: users-help@tomcat.apache.org