ds = (DataSource)context.lookup("java:/comp/env/jdbc/GFDataSource");The above works fine for me as well. But your original email mentions that you have tried it. That's weird! Anyway, try the attributes Jorge mentioned. Your context.xml /server.xml definitions look like a problem to me. The code snippet looks fine (assuming you use java:/comp/env/jdbc/GFDataSource). Coming back to your Resource definition, type="oracle.jdbc.pool.OracleDataSource" should not be used as it is deprecated. type="javax.sql.DataSource" should be used to enable DBCP. Anurag ------------------------------------------------------------------ Anurag Kapur Associate - Technology, Sapient Corporation India ------------------------------------------------------------------ On Thu, Feb 12, 2009 at 10:26 PM, Propes, Barry L <barry.l.pro...@citi.com>wrote: > Yeah -- 3333 looked like an odd port to me, too -- I've only seen 1521, > 1526 and 1527 before. > I figured his SID was just a generic placeholder for his real SID. > > -----Original Message----- > From: Jorge Medina [mailto:jmed...@e-dialog.com] > 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. > I set the attributes on the resource to: > type="javax.sql.DataSource" > driverClassName="oracle.jdbc.OracleDriver" > and no factory > > > -----Original Message----- > From: Hamacher, Eric [mailto:eric_hamac...@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: > > <Resource name="jdbc/GFDataSource" auth="Container" > type="oracle.jdbc.pool.OracleDataSource" > factory="oracle.jdbc.pool.OracleDataSourceFactory" > connectionCachingEnabled="true" > maxActive="30" > maxIdle="2" > maxWait="1000" > username="GLP_S" > password="gideupstg" > driverClassName="oracle.jdbc.driver.OracleDriver" > url="jdbc:oracle:thin:@server:3333:SID"/> > > to either server.xml (under <Server>), config/context.xml (under > <Context>), or in META-INF/context.xml. > > Here's what these files look like when I place <Resource> in them: > > ********** SERVER.XML > *************************************************************** > > <Server port="8005" shutdown="SHUTDOWN"> > <Listener className="org.apache.catalina.core.AprLifecycleListener" > SSLEngine="on" /> > <Listener className="org.apache.catalina.core.JasperListener" /> > <Listener > className="org.apache.catalina.mbeans.ServerLifecycleListener" /> > <Listener > className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" > /> > <GlobalNamingResources> > <Resource name="UserDatabase" auth="Container" > type="org.apache.catalina.UserDatabase" > description="User database that can be updated and saved" > > factory="org.apache.catalina.users.MemoryUserDatabaseFactory" > pathname="conf/tomcat-users.xml" /> > > <Resource name="jdbc/GFDataSource" auth="Container" > type="oracle.jdbc.pool.OracleDataSource" > factory="oracle.jdbc.pool.OracleDataSourceFactory" > connectionCachingEnabled="true" > maxActive="30" > maxIdle="2" > maxWait="1000" > username="username" > password="password" > driverClassName="oracle.jdbc.driver.OracleDriver" > url="jdbc:oracle:thin:@server:3333:SID"/> > > </GlobalNamingResources> > <Service name="Catalina"> > > <Connector port="8080" protocol="HTTP/1.1" > connectionTimeout="20000" > redirectPort="8443" /> > <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" /> > > <Engine name="Catalina" defaultHost="localhost"> > <Realm className="org.apache.catalina.realm.UserDatabaseRealm" > resourceName="UserDatabase"/> > <Host name="localhost" appBase="webapps" > unpackWARs="true" autoDeploy="true" > xmlValidation="false" xmlNamespaceAware="false"> > </Host> > </Engine> > </Service> > </Server> > > *************** CONFIG/CONTEXT.XML > ******************************************* > > > <Context> > <Resource name="jdbc/GFDataSource" auth="Container" > type="oracle.jdbc.pool.OracleDataSource" > factory="oracle.jdbc.pool.OracleDataSourceFactory" > connectionCachingEnabled="true" > maxActive="30" > maxIdle="2" > maxWait="1000" > username="username" > password="password" > driverClassName="oracle.jdbc.driver.OracleDriver" > url="jdbc:oracle:thin:@server:3333:SID"/> > <WatchedResource>WEB-INF/web.xml</WatchedResource> > > </Context> > > *************** META-INF/CONTEXT.XML > ******************************************* > > <Context> > > <Resource name="jdbc/GFDataSource" auth="Container" > type="oracle.jdbc.pool.OracleDataSource" > factory="oracle.jdbc.pool.OracleDataSourceFactory" > connectionCachingEnabled="true" > maxActive="30" > maxIdle="2" > maxWait="1000" > username="username" > password="password" > driverClassName="oracle.jdbc.driver.OracleDriver" > url="jdbc:oracle:thin:@server:3333:SID"/> > </Context> > > > > Here is the offending code: > > Context context = new InitialContext(); > DataSource pds = null; > pds = (DataSource)context.lookup("jdbc/GFDataSource"); > Connection conn = pds.getConnection(); > context.close(); > > > I have tried java:comp/env/jdbc/GFDataSource as well. I am using > ojdbc14dms.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-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
