Return-Path: Delivered-To: apmail-tomcat-users-archive@www.apache.org Received: (qmail 30009 invoked from network); 19 Mar 2010 21:33:20 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 19 Mar 2010 21:33:20 -0000 Received: (qmail 44874 invoked by uid 500); 19 Mar 2010 21:33:17 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 44711 invoked by uid 500); 19 Mar 2010 21:33:16 -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 44702 invoked by uid 99); 19 Mar 2010 21:33:16 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 19 Mar 2010 21:33:16 +0000 X-ASF-Spam-Status: No, hits=-2.4 required=10.0 tests=AWL,RCVD_IN_DNSWL_MED,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of barry.l.propes@citi.com designates 192.193.221.107 as permitted sender) Received: from [192.193.221.107] (HELO mail.citigroup.com) (192.193.221.107) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 19 Mar 2010 21:33:07 +0000 Received: from imbhub-ru02.nam.nsroot.net (imbhub-ru02.ru.ssmb.com [150.110.197.105]) by imbaspam-ss07.namdmz.dmzroot.net (8.13.8/8.13.8/SSMB_EXT/ev: 24741 $) with ESMTP id o2JLWj1B021418 for ; Fri, 19 Mar 2010 21:32:46 GMT Received: from exnjiht04.nam.nsroot.net (EXNJIHT04.nam.nsroot.net [150.110.165.230]) by imbhub-ru02.nam.nsroot.net (Switch-3.4.1/Switch-3.4.1) with ESMTP id o2JLWY0D010372 for ; Fri, 19 Mar 2010 21:32:45 GMT Received: from exnjht03.nam.nsroot.net (150.110.165.223) by exnjiht04.nam.nsroot.net (150.110.165.230) with Microsoft SMTP Server (TLS) id 8.1.393.2; Fri, 19 Mar 2010 17:32:28 -0400 Received: from exgtht02.nam.nsroot.net (169.171.98.131) by exnjht03.nam.nsroot.net (150.110.165.223) with Microsoft SMTP Server (TLS) id 8.1.393.2; Fri, 19 Mar 2010 17:32:28 -0400 Received: from exgtmb06.nam.nsroot.net ([169.171.98.118]) by exgtht02.nam.nsroot.net ([169.171.98.131]) with mapi; Fri, 19 Mar 2010 16:32:27 -0500 From: "Propes, Barry L " To: "'Tomcat Users List'" Date: Fri, 19 Mar 2010 16:32:27 -0500 Subject: RE: DB connection error -Tomcat 6 config Thread-Topic: DB connection error -Tomcat 6 config Thread-Index: AcrHh2Bo1wlhQxNwQmCC0MTgf0uFaQABBfiwAAKYmxAABDaxIAABEitgAAAokKA= Message-ID: <08382548D50D3049BD5599E1E3146B341054F2057A@exgtmb06.nam.nsroot.net> References: <08382548D50D3049BD5599E1E3146B340FFB1EE2C0@exgtmb06.nam.nsroot.net> <08382548D50D3049BD5599E1E3146B341054F20519@exgtmb06.nam.nsroot.net> <4BA278E2.4000100@christopherschultz.net> <99C8B2929B39C24493377AC7A121E21F96CBD975B0@USEA-EXCH8.na.uis.unisys.com> <08382548D50D3049BD5599E1E3146B341054F20525@exgtmb06.nam.nsroot.net> <99C8B2929B39C24493377AC7A121E21F96CBD9765B@USEA-EXCH8.na.uis.unisys.com> <08382548D50D3049BD5599E1E3146B341054F20556@exgtmb06.nam.nsroot.net> <99C8B2929B39C24493377AC7A121E21F96CBDD523D@USEA-EXCH8.na.uis.unisys.com> <08382548D50D3049BD5599E1E3146B341054F2056F@exgtmb06.nam.nsroot.net> <08382548D50D3049BD5599E1E3146B341054F20572@exgtmb06.nam.nsroot.net> <99C8B2929B39C24493377AC7A121E21F96CBDD556F@USEA-EXCH8.na.uis.unisys.com> <08382548D50D3049BD5599E1E3146B341054F20577@exgtmb06.nam.nsroot.net> <99C8B2929B39C24493377AC7A121E21F96CBDD5828@USEA-EXCH8.na.uis.unisys.com> In-Reply-To: <99C8B2929B39C24493377AC7A121E21F96CBDD5828@USEA-EXCH8.na.uis.unisys.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-WiganSS: 01000000010017exnjht03.nam.nsroot.net ID0044<08382548D50D3049BD5599E1E3146B341054F2057A@exgtmb06.nam.nsroot.net> X-Scanned-By: MIMEDefang 2.52 on 169.175.16.155 Ok, will do...thanks for the suggestion. I'll remove that. Thanks. =20 -----Original Message----- From: Caldarale, Charles R [mailto:Chuck.Caldarale@unisys.com]=20 Sent: Friday, March 19, 2010 4:31 PM To: Tomcat Users List Subject: RE: DB connection error -Tomcat 6 config > From: Propes, Barry L [mailto:barry.l.propes@citi.com] > Subject: RE: DB connection error -Tomcat 6 config >=20 > javax.servlet.ServletException: > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create=20 > PoolableConnectionFactory (ORA-00923: FROM keyword not found where > expected) I would suggest removing this from your element: testWhileIdle=3D"true" One normally uses testOnBorrow, and specifies a validationQuery appropriate= for the DB in use. Without the validationQuery, I have no idea what the D= BCP makes up to send. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MA= TERIAL and is thus for use only by the intended recipient. If you received = this in error, please contact the sender and delete the e-mail and its atta= chments from all computers. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org For additional commands, e-mail: users-help@tomcat.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org For additional commands, e-mail: users-help@tomcat.apache.org