Database connection pooling in Tomcat 5.5

["Darren Hall" <dhall (at) utrs.com>]

Yes, I did. Here is the web.xml

<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE web-app
  PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.2//EN"
  "http://java.sun.com/j2ee/dtds/web-app_2_2.dtd";>

<web-app>
  <display-name>My Web Application</display-name>
  <description>
    Web Application.
  </description> 

  <!-- Action Servlet Configuration -->
  <servlet>
    <servlet-name>primary-controller</servlet-name>
    <servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
    <init-param>
      <param-name>config</param-name>
      <param-value>/WEB-INF/struts-config.xml</param-value>
    </init-param>
    <init-param>
      <param-name>debug</param-name>
      <param-value>2</param-value>
    </init-param>
    <init-param>
      <param-name>detail</param-name>
      <param-value>2</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet>

  <!-- Action Servlet Mapping -->
  <servlet-mapping>
    <servlet-name>primary-controller</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>

  <!-- The Welcome File List -->
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>index.html</welcome-file>
  </welcome-file-list>

  <resource-ref>
    <description>Oracle Datasource connection pool</description>
    <res-ref-name>jdbc/flc</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>

</web-app>




-----Original Message-----
From: Mark Barnes [mailto:mark.barnes (at) coat.com] 
Sent: Monday, September 18, 2006 11:30 AM
To: Tomcat Users List
Subject: Re: Database connection pooling in Tomcat 5.5

Do you include a <resource-ref> in your WEB-INF/web.xml file?

You might also want to post your web.xml


Pid wrote:
> post your context.xml
> 
> 
> 
> 
> Darren Hall wrote:
>> Hi all.
>>
>>  
>>
>> I'm attempting to set up database connection pool using Tomcat 5.5 and
>> Oracle 10g. I've been following the "JNDI How To" guide from Apache
>>
(http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html
>> ). My question is - where should I define the connection pool resource?
>> Meaning, where should my "Resource" element appear. I've read two
different
>> descriptions about how this should be done in the Apache documentation.
The
>> first description (from the above link) states that I should modify
>> server.xml and add a new Context element as such <Context path="/DBTest"
>> docBase="DBTest" debug="5" reloadable="true" crossContext="true"> and in
>> that new context define my resource for my connection pool. However, if
you
>> read the "Context" documentation linked to the above How-To (located at
this
>> link: http://tomcat.apache.org/tomcat-5.5-doc/config/context.html) you'll
>> find in there the following text - "Please note that for tomcat 5, unlike
>> tomcat 4.x, it is NOT recommended to place <Context> elements directly in
>> the server.xml file. Instead, put them in the META-INF/context.xml
directory
>> of your WAR file or the conf directory". So I'm wondering if I should
modify
>> server.xml or create a context.xml file. Currently I'm trying the
>> context.xml file route, but it is not working (although this could be
>> because I'm configuring things incorrectly). Can anyone point me in the
>> right direction here?
>>  
>> Thanks,
>> Darren
>>
>>  
>>
>>
> 
> 
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users (at) tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe (at) tomcat.apache.org
> For additional commands, e-mail: users-help (at) tomcat.apache.org


---------------------------------------------------------------------
To start a new topic, e-mail: users (at) tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe (at) tomcat.apache.org
For additional commands, e-mail: users-help (at) tomcat.apache.org



---------------------------------------------------------------------
To start a new topic, e-mail: users (at) tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe (at) tomcat.apache.org
For additional commands, e-mail: users-help (at) tomcat.apache.org