I guess I'm not sure why...I have all kinds of packages and stored procs in mine, and yet I'm never using Oracle-specific classes.
It's probably too lengthy an explanation for you as to why you have to or need to use them. -----Original Message----- From: Hamacher, Eric [mailto:eric_hamac...@gallup.com] Sent: Friday, February 13, 2009 1:55 PM To: Tomcat Users List Subject: 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 <name>factory</name> <value>org.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 -- 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 --------------------------------------------------------------------- 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
