4.1 to 5.5.20...context.xml question

[Jeff Pollet]

Hello All,

I'm attempting to upgrade from Tomcat 4.1 to 5.5.20, and running into some trouble that I'm having a hard time figuring out. The newest problem is figuring out how to include my database resource properly. In the 5.5 documentation, it is strongly suggested that:

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 as described above.

So, I'm attempting to put the <Resource> elements within the <Context> element in said context.xml. However, according to the 5.5 documentation, I'm only allowed to place auth, description, name, scope and type elements within the <Resource> element in the context.xml. So, whereas previously I defined my database resource in the server.xml file like so:

   <Resource name="jdbc/testDB" 
    auth="Container"
            type="javax.sql.DataSource"/>
  <ResourceParams name="jdbc/testDB">
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
 
    <parameter>
      <name>maxActive</name>
      <value>100</value>
    </parameter>
 
    <parameter>
      <name>maxIdle</name>
      <value>30</value>
    </parameter>
 
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
 
    <parameter>
      <name>testname</name>
      <value>name</value>
    </parameter>
    <parameter>
      <name>testpassword</name>
      <value>test</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>com.mysql.jdbc.Driver</value>
    </parameter>
    <parameter>
      <name>url</name>
      <value>jdbc:mysql://localhost:3306/testDB?autoReconnect=true</value>
    </parameter>
  </ResourceParams>
 
 

I am now supposed to define it this way in the context.xml:

    <Resource name="jdbc/testDB" 
      auth="Container"
            type="javax.sql.DataSource"
            factory="org.apache.commons.dbcp.BasicDataSourceFactory"
            maxActive="100"
            maxIdle="30"
            maxWait="10000"
            username="testname"
            password="testpassword"
            driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://localhost:3306/pureDB?autoReconnect=true"
   />
 

or, something *like* the above. I'm only allowed a few elements, so my resource definition ends up being:

    <Resource name="jdbc/testDB" 
      auth="Container"
            type="javax.sql.DataSource"
          />
 

So, where the heck does the *rest* of the context/resource information go? Where do I place the rest of my elements, i.e.

   factory="org.apache.commons.dbcp.BasicDataSourceFactory"
            maxActive="100"
            maxIdle="30"
            maxWait="10000"
            usernamefactory="org.apache.commons.dbcp.BasicDataSourceFactory"
            maxActive="100"
            maxIdle="30"
            maxWait="10000"
            username="testname"
            password="testpassword"
            driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://localhost:3306/pureDB?autoReconnect=true"
="testname"
             

I get the feeling I'm missing something big here. Any help?
[ October 25, 2006: Message edited by: Jeff Pollet ]

[Ben Souther]

Did you see:
http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html
?

<Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="javauser" password="javadude" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true"/>

[Jeff Pollet]

Ben--
You're right, of course. What confused me was this (from this part of the documentation):

The valid attriutes for a <Resource> element are as follows:


auth Specify whether the web Application code signs on to the corresponding resource manager programatically, or whether the Container will sign on to the resource manager on behalf of the application. The value of this attribute must be Application or Container. This attribute is required if the web application will use a <resource-ref> element in the web application deployment descriptor, but is optional if the application uses a <resource-env-ref> instead.

description Optional, human-readable description of this resource.

name The name of the resource to be created, relative to the java:comp/env context.

scope Specify whether connections obtained through this resource manager can be shared. The value of this attribute must be Shareable or Unshareable. By default, connections are assumed to be shareable.

type The fully qualified Java class name expected by the web application when it performs a lookup for this resource.

I guess I took "the valid attributes for a Resource element" to be all-inclusive. But, as you point out, the examples given have more than these attributes.

Thanks for your help.