Thanks Daniel, I got to work by removing things from web.xml. Removing DefaultCOntext from server.xml.
Adding a context.xml with <Context> <ResourceLink name="jdbc/orcl" global="jdbc/orcl" auth="Container" type="javax.sql.DataSource" /> </Context> And placing this context.xml in conf directory (where server.xml is) resolved my problems :-) thanks Shailesh -----Original Message----- From: Daniel Stephens [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 10:00 AM To: Tomcat Users List Subject: Re: Tomcat Connection pool Yes post your web.xml where with your <resource-ref> tags. Looks like a typo in there. On 5/29/07, Ligade, Shailesh (Contr) (Mission Systems) < [EMAIL PROTECTED]> wrote: > > > Greetings, > > I am running Tomcat 5.x, and I have many webapps deployed and working > under tomcat. I want my connection pool to be used from any application. > When I modify server.xml in conf directory to add my connection, > listed > below: > > <Server port="8010" shutdown="SHUTDOWN"> > > <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener" > debug="0"/> > <Listener > className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" > debug="0"/> > > <GlobalNamingResources> > <Resource name="jdbc/orcl" scope="Shareable" > auth="Container" type="javax.sql.DataSource" description="Employees > Database for HR Applications"/> > > <ResourceParams name="jdbc/orcl"> > <parameter> > <name>factory</name> > > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > <parameter> > <name>driverClassName</name> > > <value>oracle.jdbc.driver.OracleDriver</value> > </parameter> > <parameter> > <name>url</name> > > <value>jdbc:oracle:thin:@158.114.68.201:1521:CSAPPDB</value> > </parameter> > <parameter> > <name>username</name> > <value>ROAM_USER</value> > </parameter> > <parameter> > <name>password</name> > <value>ngit1234</value> > </parameter> > ................................. > </ResourceParams> > </GlobalNamingResources> > > <Service name="Collaboration-Standalone"> > <Connector protocol="HTTP/1.1" enableLookups="true" > redirectPort="8443" > acceptCount="100" connectionTimeout="20000" > disableUploadTimeout="true" URIEncoding="UTF-8"/> > <Connector protocol="AJP/1.3" port="8009" > minProcessors="50" maxProcessors="150" > enableLookups="true" redirectPort="8443" > acceptCount="130" URIEncoding="UTF-8"/> > <Engine name="Standalone" defaultHost="localhost" debug="8"> > <!-- uncomment to dump HTTP requests received > <Valve className="org.apache.catalina.valves.RequestDumperValve"/> > --> > <Host name="localhost" appBase="webapps" unpackWARs="true" > autoDeploy="true"> > <Valve className="org.apache.catalina.valves.AccessLogValve" > directory="log" prefix="localhost_access_log." > suffix=".txt" > pattern="common" resolveHosts="false"/> > <Context path="" docBase="../WWW" crossContext="true" > override="true" > debug="5" reloadable="true"> > <ResourceLink name="jdbc/orcl" global="jdbc/orcl" > auth="Container" type="javax.sql.DataSource"/> > </Context> > > </Host> > </Engine> > </Service> > </Server> > > > And I get following error: > > > javax.naming.NameNotFoundException: Name jdbc is not bound in this > Context > [May 29, 2007 7:47:06 AM (http-80-Processor4_214)]: at > org.apache.naming.NamingContext.lookup(NamingContext.java:769) > [May 29, 2007 7:47:06 AM (http-80-Processor4_214)]: at > org.apache.naming.NamingContext.lookup(NamingContext.java:152) > [May 29, 2007 7:47:06 AM (http-80-Processor4_214)]: at > com.intraspect.reports.CustomerReport.getVBCSDBConnection(Unknown > Source) > [May 29, 2007 7:47:06 AM (http-80-Processor4_214)]: at > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > [May 29, 2007 7:47:06 AM (http-80-Processor4_214)]: at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j > av > a:39) > [May 29, 2007 7:47:06 AM (http-80-Processor4_214)]: at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess > or > Impl.java:25) > [May 29, 2007 7:47:06 AM (http-80-Processor4_214)]: at > java.lang.reflect.Method.invoke(Method.java:585) > > Any idea, what I am doing wrong? > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, > e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
