RE: Oracle connection pooling
I was just putting some fake values there. But I got around the problem (although I can't remember how) Now I put: 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:port:SID/ into META-INF/context.xml. The type javax.sql.DataSource didn't work. Now when I call getConnection() on the OracleDataSource I get: java.sql.SQLException: User credentials doesn't match the existing ones at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:240) at oracle.jdbc.pool.OracleImplicitConnectionCache.validateUser(OracleImplicitConnectionCache.java:258) at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:314) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:286) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:179) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:159) This looks like an Oracle problem. Thanks for all your help!! 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 -Original Message- From: Propes, Barry L [mailto:barry.l.pro...@citi.com] Sent: Thursday, February 12, 2009 4:27 PM To: 'Tomcat Users List' Subject: RE: Oracle connection pooling Yeah -- 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 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::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
RE: Oracle connection pooling
Thanks, I was able to get connections that way. However, I use Oracle-specific classes like: oracle.jdbc.OracleTypes; oracle.jdbc.internal.OracleCallableStatement; oracle.sql.ARRAY; oracle.sql.ArrayDescriptor; which require Oracle-specific connections. I've filed a Service Request with MetaLink to see if Oracle folks know what to do. I had the exact same problems with jBoss, too. The remedy there was to put jBoss-specfic code in the application - not an option with us. 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 -Original Message- From: Propes, Barry L [mailto:barry.l.pro...@citi.com] Sent: Friday, February 13, 2009 12:12 PM To: 'Tomcat Users List' Subject: RE: Oracle connection pooling For factory, I have namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory type=javax.sql.DataSource/ I'd try taking out that line you have -- type=oracle.jdbc.pool.OracleDataSource factory=oracle.jdbc.pool.OracleDataSourceFactory And switch up accordingly. See if that doesn't work. -Original Message- From: Hamacher, Eric [mailto:eric_hamac...@gallup.com] Sent: Friday, February 13, 2009 11:45 AM To: Tomcat Users List Subject: RE: Oracle connection pooling I was just putting some fake values there. But I got around the problem (although I can't remember how) Now I put: 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:port:SID/ into META-INF/context.xml. The type javax.sql.DataSource didn't work. Now when I call getConnection() on the OracleDataSource I get: java.sql.SQLException: User credentials doesn't match the existing ones at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:240) at oracle.jdbc.pool.OracleImplicitConnectionCache.validateUser(OracleImplicitConnectionCache.java:258) at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:314) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:286) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:179) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:159) This looks like an Oracle problem. Thanks for all your help!! 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 -Original Message- From: Propes, Barry L [mailto:barry.l.pro...@citi.com] Sent: Thursday, February 12, 2009 4:27 PM To: 'Tomcat Users List' Subject: RE: Oracle connection pooling Yeah -- 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 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 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:78) 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::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::SID/ /GlobalNamingResources Service name=Catalina Connector port=8080 protocol=HTTP/1.1 connectionTimeout=2 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::SID/ WatchedResourceWEB-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::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
RE: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
DataSource pds = null; pds = (DataSource)context.lookup(name); name had to be java:/comp/jdbc/GFDataSource and then I moved on to my next problem. -Original Message- From: Pid [mailto:p...@pidster.com] Sent: Thursday, January 29, 2009 2:43 PM To: Tomcat Users List Subject: Re: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context Hamacher, Eric wrote: I solved the problem by putting java:/comp/env in the JNDI lookup in the code. So you're not putting: java:/comp/jdbc/GFDataSource? p That led me to an exception when I tried to use an ArrayDescriptor. So I tried to change my pooling form dbcp to oracle with: 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:@uxsvr3.enetrix.msn:2224:STG9/ And now I'm back to javax.naming.NameNotFoundException: Name jdbc is not bound in this Context! -Original Message- From: Hamacher, Eric [mailto:eric_hamac...@gallup.com] Sent: Thursday, January 29, 2009 9:04 AM To: Tomcat Users List Subject: RE: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context Tomcat's -Original Message- From: news [mailto:n...@ger.gmane.org] On Behalf Of Stephen Souness Sent: Thursday, January 29, 2009 9:02 AM To: users@tomcat.apache.org Subject: Re: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context Which lib did you put your jars in? The web app's or Tomcat's? -- Stephen Souness Hamacher, Eric wrote: Hello: This has been a truly frustrating problem. Here is what I did: Tomcat 6.0.18 JDK 1.5 u 16 Eclipse w/ WTP 3.4.1 Ojdbc14dms.jar Dms.jar I placed my drivers in lib. In web.xml, I put resource-ref res-ref-namejdbc/GFDataSource/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref I placed the following in three different places, conf/server.xml, conf/context.xml, and in a context file in my app's META-INF directory: Resource name=jdbc/GFDataSource auth=Container type=javax.sql.DataSource maxActive=30 maxIdle=2 maxWait=1000 username=username password=password driverClassName=oracle.jdbc.OracleDriver uri=jdbc:oracle:thin:@aserver:2224:DB/ For driverClassName, I've also tried oracle.jdbc.driver.OracleDriver. This application works on other servers. Please help! 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 - 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 - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
Thanks Michael for the reply. No dice. Same error message with url. I forgot to mention that this is a fresh installation of Tomcat 6 so I haven't changed anything except for trying to insert this element. Eric -Original Message- From: Michael Ludwig [mailto:mil...@gmx.de] Sent: Wednesday, January 28, 2009 6:17 PM To: Tomcat Users List Subject: Re: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context Hamacher, Eric schrieb am 28.01.2009 um 08:18:21 (-0600): Resource name=jdbc/GFDataSource auth=Container type=javax.sql.DataSource maxActive=30 maxIdle=2 maxWait=1000 username=username password=password driverClassName=oracle.jdbc.OracleDriver uri=jdbc:oracle:thin:@aserver:2224:DB/ Try changing the attribute uri to url. Even though the connect URL doesn't look like your typical web URL, it is actually used to locate the service, not only to identify it. Michael Ludwig - 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
RE: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
Tomcat's -Original Message- From: news [mailto:n...@ger.gmane.org] On Behalf Of Stephen Souness Sent: Thursday, January 29, 2009 9:02 AM To: users@tomcat.apache.org Subject: Re: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context Which lib did you put your jars in? The web app's or Tomcat's? -- Stephen Souness Hamacher, Eric wrote: Hello: This has been a truly frustrating problem. Here is what I did: Tomcat 6.0.18 JDK 1.5 u 16 Eclipse w/ WTP 3.4.1 Ojdbc14dms.jar Dms.jar I placed my drivers in lib. In web.xml, I put resource-ref res-ref-namejdbc/GFDataSource/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref I placed the following in three different places, conf/server.xml, conf/context.xml, and in a context file in my app's META-INF directory: Resource name=jdbc/GFDataSource auth=Container type=javax.sql.DataSource maxActive=30 maxIdle=2 maxWait=1000 username=username password=password driverClassName=oracle.jdbc.OracleDriver uri=jdbc:oracle:thin:@aserver:2224:DB/ For driverClassName, I've also tried oracle.jdbc.driver.OracleDriver. This application works on other servers. Please help! 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
RE: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
I solved the problem by putting java:/comp/env in the JNDI lookup in the code. That led me to an exception when I tried to use an ArrayDescriptor. So I tried to change my pooling form dbcp to oracle with: 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:@uxsvr3.enetrix.msn:2224:STG9/ And now I'm back to javax.naming.NameNotFoundException: Name jdbc is not bound in this Context! -Original Message- From: Hamacher, Eric [mailto:eric_hamac...@gallup.com] Sent: Thursday, January 29, 2009 9:04 AM To: Tomcat Users List Subject: RE: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context Tomcat's -Original Message- From: news [mailto:n...@ger.gmane.org] On Behalf Of Stephen Souness Sent: Thursday, January 29, 2009 9:02 AM To: users@tomcat.apache.org Subject: Re: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context Which lib did you put your jars in? The web app's or Tomcat's? -- Stephen Souness Hamacher, Eric wrote: Hello: This has been a truly frustrating problem. Here is what I did: Tomcat 6.0.18 JDK 1.5 u 16 Eclipse w/ WTP 3.4.1 Ojdbc14dms.jar Dms.jar I placed my drivers in lib. In web.xml, I put resource-ref res-ref-namejdbc/GFDataSource/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref I placed the following in three different places, conf/server.xml, conf/context.xml, and in a context file in my app's META-INF directory: Resource name=jdbc/GFDataSource auth=Container type=javax.sql.DataSource maxActive=30 maxIdle=2 maxWait=1000 username=username password=password driverClassName=oracle.jdbc.OracleDriver uri=jdbc:oracle:thin:@aserver:2224:DB/ For driverClassName, I've also tried oracle.jdbc.driver.OracleDriver. This application works on other servers. Please help! 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 - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
Hello: This has been a truly frustrating problem. Here is what I did: Tomcat 6.0.18 JDK 1.5 u 16 Eclipse w/ WTP 3.4.1 Ojdbc14dms.jar Dms.jar I placed my drivers in lib. In web.xml, I put resource-ref res-ref-namejdbc/GFDataSource/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref I placed the following in three different places, conf/server.xml, conf/context.xml, and in a context file in my app's META-INF directory: Resource name=jdbc/GFDataSource auth=Container type=javax.sql.DataSource maxActive=30 maxIdle=2 maxWait=1000 username=username password=password driverClassName=oracle.jdbc.OracleDriver uri=jdbc:oracle:thin:@aserver:2224:DB/ For driverClassName, I've also tried oracle.jdbc.driver.OracleDriver. This application works on other servers. Please help! 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