You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "Ligade, Shailesh (Contr) (Mission Systems)" <Sh...@ngc.com> on 2007/05/29 14:15:59 UTC
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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat Connection pool
Posted by Szabolcs Márton <ma...@gmail.com>.
maybe you need some settings at the web.xml as weel?
(just guess)
regards,
Szabi
2007/5/29, Ligade, Shailesh (Contr) (Mission Systems) <Sh...@ngc.com>:
>
> 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: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
RE: Tomcat Connection pool
Posted by "Ligade, Shailesh (Contr) (Mission Systems)" <Sh...@ngc.com>.
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:danman06@gmail.com]
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) <
Shailesh.Ligade@ngc.com> 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: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat Connection pool
Posted by Daniel Stephens <da...@gmail.com>.
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) <
Shailesh.Ligade@ngc.com> 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.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: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
RE: Tomcat Connection pool
Posted by David Short <ds...@san.rr.com>.
In your code where you reference the JNDI name "jdbc", reference "jdbc/orcl"
instead.
-----Original Message-----
From: Ligade, Shailesh (Contr) (Mission Systems)
[mailto:Shailesh.Ligade@ngc.com]
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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org