In your code where you reference the JNDI name "jdbc", reference "jdbc/orcl" instead.
-----Original Message----- From: Ligade, Shailesh (Contr) (Mission Systems) [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 5:16 AM To: Tomcat Users List Subject: Tomcat Connection pool 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.jav a:39) [May 29, 2007 7:47:06 AM (http-80-Processor4_214)]: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor 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]
