Return-Path: 
 <tomcat-user-return-119484-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org
Received: (qmail 33881 invoked from network); 15 Jan 2005 00:45:54 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 15 Jan 2005 00:45:54 -0000
Received: (qmail 68670 invoked by uid 500); 15 Jan 2005 00:45:38 -0000
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 68648 invoked by uid 500); 15 Jan 2005 00:45:38 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 68634 invoked by uid 99); 15 Jan 2005 00:45:38 -0000
X-ASF-Spam-Status: No, hits=0.4 required=10.0
	tests=DNS_FROM_RFC_ABUSE,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of
 parsonstechnical@earthlink.net designates 207.217.121.253 as permitted
 sender)
Received: from pop-a065d19.pas.sa.earthlink.net (HELO
 pop-a065d19.pas.sa.earthlink.net) (207.217.121.253)
  by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 14 Jan 2005 16:45:37 -0800
Received: from va-69-34-33-6.sta.sprint-hsd.net ([69.34.33.6] helo=ptslaptop)
	by pop-a065d19.pas.sa.earthlink.net with smtp (Exim 3.33 #1)
	id 1Cpc4N-000154-00
	for tomcat-user@jakarta.apache.org; Fri, 14 Jan 2005 16:45:35 -0800
Message-ID: <012f01c4fa9b$7c174070$8101a8c0@ptslaptop>
From: "Parsons Technical Services" <parsonstechnical@earthlink.net>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
References: <41E847C5.8050900@louisiana.edu>
Subject: Re: <Context> question
Date: Fri, 14 Jan 2005 19:45:17 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

What you have here is a classic case of cut and paste by the clueless(public 
boolean newbie;).

This code is from the server.xml that was setup for a Global database 
connection pool as opposed to a pool just for the app. The person has cut 
and pasted it into the context file for the app which will work but the pool 
is only available to that app. The first ResourceParams is used for the 
authentication of users when using login like the manager and admin apps. If 
you only wanted this app to use this file and different apps to use 
different files you would put one in each contex xml pointing to the proper 
file. With some other changes.

So unless you are doing something special with your authentication this is 
not needed here (newbie =true;).

If you have some special setup and are using this file for just this app 
(newbie=false;)

I think it would be safe to remove the first part and you might think about 
moving the DBCP to a global one. But that of course depends on your setup 
and needs.

For more details:
http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-resources-howto.html
and look at the bottom two examples.

As for the factory see:

http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/context.html#Resource%20Parameters

It depends on the factory as to whether you need to declare it or not.

Doug

----- Original Message ----- 
From: "Hollerman Geralyn M" <gmh2441@louisiana.edu>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Sent: Friday, January 14, 2005 5:29 PM
Subject: <Context> question


>I was recently given a new application to maitain. It uses Tomcat 5.0.16 
>and an Oracle database. I have used various versions of Tomcat to work with 
>applications on two other kinds of databases, one of which uses DBCP, so I 
>am somewhat familiar with the needed parameters and went to the Tomcat JNDI 
>HOW-TO and the Tomcat Configuration Reference to refresh my memory on just 
>what this was doing, but I have to admit I don't completely understand 
>this - what I have included is the <Context>.xml file for the "new" 
>application. What I don't understand is that first <ResourceParams> set of 
>statements - it appears to be saying to look at the "database" of users in 
>the tomcat-users.xml file in /conf - but why? That file hasn't been altered 
>to contain anything but the defaults, and the person that gave me the "new" 
>app was the one that set up Tomcat for it, so I assume its set up as 
>needed! Also, why is there no factory in the 2nd <ResourceParams> in this 
>file? I thought one was needed. The person that gave me this said DBCP was 
>implemented, but I don't see how this would do it.
> ----
> <Context docBase="graduate" path="/graduate">
>   <Resource auth="Container" name="jdbc/ConnectionPool" 
> type="javax.sql.DataSour
> ce"/>
>    <ResourceParams name="UserDatabase">
>       <parameter>
>         <name>factory</name>
>         <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
>       </parameter>
>       <parameter>
>         <name>pathname</name>
>         <value>conf/tomcat-users.xml</value>
>       </parameter>
>     </ResourceParams>
>     <ResourceParams name="jdbc/ConnectionPool">
>       <parameter>
>         <name>maxWait</name>
>         <value>5000</value>
>       </parameter>
>       <parameter>
>         <name>maxActive</name>
>         <value>100</value>
>       </parameter>
>       <parameter>
>         <name>password</name>
>         <value>xxxx</value>
>       </parameter>
>       <parameter>
>         <name>url</name>
>         <value>jdbc:oracle:thin:@xxxx</value>
>       </parameter>
>       <parameter>
>         <name>driverClassName</name>
>         <value>oracle.jdbc.driver.OracleDriver</value>
>       </parameter>
>       <parameter>
>         <name>maxIdle</name>
>         <value>5</value>
>       </parameter>
>       <parameter>
>         <name>username</name>
>         <value>xxxx</value>
>       </parameter>
>     </ResourceParams>
> </Context>
>
> ----
>
> Could someone please explain to me just how this is using DBCP?
>
> Thanks!!
> -- 
> Lynn Hollerman.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org