Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (athena.apache.org: domain of alex@j2anywhere.com
 designates 82.71.16.58 as permitted sender)
Subject: Re: Active DataSource Connection count never decreasing with
 PostgreSQL
Mime-Version: 1.0 (Apple Message framework v1077)
Content-Type: text/plain; charset=us-ascii
From: Alexander Hartner <alex@j2anywhere.com>
In-Reply-To: 
 <99C8B2929B39C24493377AC7A121E21F96C401DBB4@USEA-EXCH8.na.uis.unisys.com>
Date: Wed, 3 Feb 2010 20:17:06 +0000
Cc: Tomcat Users List <users@tomcat.apache.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <19F5222C-2A66-449C-BCE4-A605BDC6341E@j2anywhere.com>
References: <C9D65715-71E1-4CA5-9873-1C4D09E651EE@j2anywhere.com>
 <4B68ABB4.6050308@christopherschultz.net>
 <DE54EC1E-4E1F-44D8-897A-D8AAD915FAA5@j2anywhere.com>
 <99C8B2929B39C24493377AC7A121E21F96C401DBB4@USEA-EXCH8.na.uis.unisys.com>
To: "Caldarale, Charles R" <Chuck.Caldarale@unisys.com>,
 Christopher Schultz <chris@christopherschultz.net>

This is a little off topic, but I tried your suggestions. However there =
doesn't seem to be an option to set the root application without =
renaming the WAR to ROOT.war, or is there.

I tried your suggestions as well as the suggestions from here:
=
http://mail-archives.apache.org/mod_mbox//tomcat-users/200902.mbox/%3C499F=
E497.2000506@ice-sa.com%3E

Besides the connection problems my configuration worked really well and =
allowed me to configure all I needed in one file outside the WAR, as =
well as set the application accessible on the root (/) path. I see that =
using a separate file has it's merits in some cases, however right now I =
can't get the application running on the / path without renaming it. =
Don't really want to rename it as this only seems to work on Tomcat.=20

Ideally I would like to set the deployment path to / in =
META-INF/context.xml but configure the database connection outside the =
WAR to allow me to change between different database.=20

Any other suggestion on my Connection issue. I set the maxActive to 200 =
and after a day ended up with 21 in numActive state. So by increasing my =
upper limit I can increase the time between restarts. However this is =
really just a hack until I figure this out.

Thanks for all your suggestions.

Regards
Alex


On 3 Feb 2010, at 00:15, Caldarale, Charles R wrote:

>> From: Alexander Hartner [mailto:alex@j2anywhere.com]
>> Subject: Re: Active DataSource Connection count never decreasing with
>> PostgreSQL
>>=20
>>> Put this into either META-INF/context.xml within your WAR/webapp
>>> directory, or into CATALINA_BASE/Catalina/[hostname]/ROOT.xml
>>>=20
>>> Remove the "path" and "docBase" attributes when you move the
>>> <Context> element.
>>=20
>> I really like it that way as it allows me to configure what I need to
>> in one central place without having to touch or expand the WAR file.
>=20
> And it breaks things.  You are now getting double deployment, once =
under the name AddressBookServer and once again as ROOT.  Do it the =
right way, by renaming your .war file to ROOT.war, and placing the =
<Context> element in conf/Catalina/[host]/ROOT.xml - that also avoids =
having to change the contents of the .war file.  (Note that Chris' =
suggesting was missing part of the path.)  As Chris said, when you do =
that, remove the path and docBase attributes.
>=20
>> This also works great for me. My database folder is relative the the
>> startup script.
>=20
> That's really asking for trouble.  A parser has complete freedom to =
ignore any .. entry in a URL, so if it happens to be working now, you're =
extremely lucky, and there's no guarantee it will work tomorrow.  The =
URL is *not* relative to any current directory, since it doesn't target =
the file system per se.
>=20
> - Chuck
>=20
>=20
> THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE =
PROPRIETARY MATERIAL and is thus for use only by the intended recipient. =
If you received this in error, please contact the sender and delete the =
e-mail and its attachments from all computers.
>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>=20


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