Return-Path: Delivered-To: apmail-tomcat-users-archive@www.apache.org Received: (qmail 88940 invoked from network); 12 Feb 2009 22:27:32 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 12 Feb 2009 22:27:32 -0000 Received: (qmail 34781 invoked by uid 500); 12 Feb 2009 22:27:13 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 34762 invoked by uid 500); 12 Feb 2009 22:27:13 -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 34747 invoked by uid 99); 12 Feb 2009 22:27:12 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Feb 2009 14:27:12 -0800 X-ASF-Spam-Status: No, hits=-2.5 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_HELO_SOFTFAIL,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of barry.l.propes@citi.com designates 199.67.179.105 as permitted sender) Received: from [199.67.179.105] (HELO mail.citigroup.com) (199.67.179.105) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Feb 2009 22:27:03 +0000 Received: from imbarc-nj02.nj.ssmb.com (imbarc-nj02.nj.ssmb.com [150.110.177.216]) by imbaspam-ny05.iplex.ssmb.com (8.13.8/8.13.8/SSMB_EXT/ev: 22534 $) with ESMTP id n1CMQgNB010852 for ; Thu, 12 Feb 2009 22:26:42 GMT Received: from mailhub-nj04-1.nj.ssmb.com (mailhub-nj04-2.nj.ssmb.com [150.110.236.237]) by imbarc-nj02.nj.ssmb.com (8.13.8/8.13.8/SSMB_QQQ_IN/1.1) with ESMTP id n1CMQaiT003895 for ; Thu, 12 Feb 2009 22:26:36 GMT Received: from exnjiht02.nam.nsroot.net (EXNJIHT02.nam.nsroot.net [150.110.165.228]) by mailhub-nj04-1.nj.ssmb.com (8.13.8/8.13.8/CG_HUB) with ESMTP id n1CMQZkt002675 for ; Thu, 12 Feb 2009 22:26:35 GMT Received: from exgtht04.nam.nsroot.net (169.171.98.133) by exnjiht02.nam.nsroot.net (150.110.165.228) with Microsoft SMTP Server (TLS) id 8.1.311.2; Thu, 12 Feb 2009 17:26:35 -0500 Received: from exgtmb06.nam.nsroot.net ([169.171.98.118]) by exgtht04.nam.nsroot.net ([169.171.98.133]) with mapi; Thu, 12 Feb 2009 16:26:34 -0600 From: "Propes, Barry L " To: "'Tomcat Users List'" Date: Thu, 12 Feb 2009 16:26:33 -0600 Subject: RE: Oracle connection pooling Thread-Topic: Oracle connection pooling Thread-Index: AcmNU7WIQ6ozUL6TQvGpRhMyKKRmAAACky6gAAC4YQA= Message-ID: <08382548D50D3049BD5599E1E3146B340D047927BD@exgtmb06.nam.nsroot.net> References: <9DD36C99332AB7438F8D73C048D8C62C02096DCC@sneezy.ad.e-dialog.com> In-Reply-To: <9DD36C99332AB7438F8D73C048D8C62C02096DCC@sneezy.ad.e-dialog.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-Scanned-By: MIMEDefang 2.52 on 172.27.136.24 X-Virus-Checked: Checked by ClamAV on apache.org Yeah -- 3333 looked like an odd port to me, too -- I've only seen 1521, 152= 6 and 1527 before. I figured his SID was just a generic placeholder for his real SID.=20 -----Original Message----- From: Jorge Medina [mailto:jmedina@e-dialog.com]=20 Sent: Thursday, February 12, 2009 4:12 PM To: Tomcat Users List Subject: RE: Oracle connection pooling Is your Oracle database port 3333 and is the name of your SID "SID"? We use Oracle jdbc driver with Oracle 10g.=20 I set the attributes on the resource to: type=3D"javax.sql.DataSource" driverClassName=3D"oracle.jdbc.OracleDriver" and no factory -----Original Message----- From: Hamacher, Eric [mailto:Eric_Hamacher@gallup.com] Sent: Thursday, February 12, 2009 3:52 PM To: users@tomcat.apache.org Subject: Oracle connection pooling Hello: I am in a bind. I am getting: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context = at org.apache.naming.NamingContext.lookup(NamingContext.java:770) at org.apache.naming.NamingContext.lookup(NamingContext.java:153) at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137) at javax.naming.InitialContext.lookup(InitialContext.java:351) at survey.db.SurveyConnection.getConnection(SurveyConnection.java:66) at util.LoadDropdownListener.loadAllCodes(LoadDropdownListener.java:137) at util.LoadDropdownListener.contextInitialized(LoadDropdownListener.java:7 8) when I add: to either server.xml (under ), config/context.xml (under )= , or in META-INF/context.xml. Here's what these files look like when I place in them: ********** SERVER.XML *************************************************************** *************** CONFIG/CONTEXT.XML ******************************************* WEB-INF/web.xml *************** META-INF/CONTEXT.XML ******************************************* Here is the offending code: Context context =3D new InitialContext(); DataSource pds =3D null; pds =3D (DataSource)context.lookup("jdbc/GFDataSource"); Connection conn =3D pds.getConnection(); context.close(); I have tried java:comp/env/jdbc/GFDataSource as well. I am using ojdbc14dm= s.jar and dms.jar. J. ERIC HAMACHER Software Application Developer 608.664.3859 8476 Greenway Boulevard Suite 100 Middleton, WI 53562 USA GALLUP Technology Achiever | Learner | Restorative | Intellection | Deliberative --------------------------------------------------------------------- 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