tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anurag Kapur <anuragka...@gmail.com>
Subject Re: Oracle connection pooling
Date Thu, 12 Feb 2009 23:40:12 GMT
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.propes@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:jmedina@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_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:
>
> <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-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
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message