Re: Active DataSource Connection count never decreasing with PostgreSQL [RESOLVED]

2010-02-08 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alexander, On 2/5/2010 8:05 PM, Alexander Hartner wrote: > Thanks guys. It turns out that there was a connection leak. I just > needed to wait for the entire pool to fill up with "Active" > connection and then I got the abandoned messages. ...one of

Re: Active DataSource Connection count never decreasing with PostgreSQL [RESOLVED]

2010-02-05 Thread Alexander Hartner
.@j2anywhere.com] >> Subject: Re: Active DataSource Connection count never decreasing with >> PostgreSQL > > Again, please send just to the mailing list, not to individuals. > >> conf/Catalina/localhost/ROOT.xml >> >> > > Apparently you missed this bit

RE: Active DataSource Connection count never decreasing with PostgreSQL

2010-02-03 Thread Caldarale, Charles R
> From: Alexander Hartner [mailto:a...@j2anywhere.com] > Subject: Re: Active DataSource Connection count never decreasing with > PostgreSQL Again, please send just to the mailing list, not to individuals. > conf/Catalina/localhost/ROOT.xml > > Apparently you missed this b

Re: Active DataSource Connection count never decreasing with PostgreSQL

2010-02-03 Thread Alexander Hartner
Hi Christopher and Charles, Thanks for your help so far. I made the following changes: server.xml conf/Catalina/localhost/ROOT.xml I also set the autoDeploy to false in server.xml and tried keeping my WAR in the webapps folder, however this didn'

RE: Active DataSource Connection count never decreasing with PostgreSQL

2010-02-03 Thread Caldarale, Charles R
> From: Alexander Hartner [mailto:a...@j2anywhere.com] > Subject: Re: Active DataSource Connection count never decreasing with > PostgreSQL Just send responses to the list, please - not to individuals. > However there doesn't seem to be an option to set the root > applicat

Re: Active DataSource Connection count never decreasing with PostgreSQL

2010-02-03 Thread Alexander Hartner
his 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:a...@j2anywhere.com] >> Subject: Re: Active DataSource Connection count never decreasing with >

Re: Active DataSource Connection count never decreasing with PostgreSQL

2010-02-02 Thread Alexander Hartner
RemoveAbandonedTimeout: 60 2010-Feb-03 00:34:36 [JCLLoggerAdapter - INFO] RDBMS: PostgreSQL, version: 8.4.2 Regards Alex On 3 Feb 2010, at 00:15, Caldarale, Charles R wrote: >> From: Alexander Hartner [mailto:a...@j2anywhere.com] >> Subject: Re: Active DataSource Connection count never dec

Re: Active DataSource Connection count never decreasing with PostgreSQL

2010-02-02 Thread Alexander Hartner
tions though. Thanks again for all your suggestions. Alex On 3 Feb 2010, at 00:15, Caldarale, Charles R wrote: >> From: Alexander Hartner [mailto:a...@j2anywhere.com] >> Subject: Re: Active DataSource Connection count never decreasing with >> PostgreSQL >> >>> Put

RE: Active DataSource Connection count never decreasing with PostgreSQL

2010-02-02 Thread Caldarale, Charles R
> From: Alexander Hartner [mailto:a...@j2anywhere.com] > Subject: Re: Active DataSource Connection count never decreasing with > PostgreSQL > > > Put this into either META-INF/context.xml within your WAR/webapp > > directory, or into CATALINA_BASE/Catalina/[hostname]/ROO

Re: Active DataSource Connection count never decreasing with PostgreSQL

2010-02-02 Thread Alexander Hartner
Hi Christopher, Thanks for your suggestion. On 2 Feb 2010, at 22:48, Christopher Schultz wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Alexander, > > On 2/2/2010 2:44 PM, Alexander Hartner wrote: >> I have developed an application which accesses a database via >> Hibernate as w

Re: Active DataSource Connection count never decreasing with PostgreSQL

2010-02-02 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alexander, On 2/2/2010 2:44 PM, Alexander Hartner wrote: > I have developed an application which accesses a database via > Hibernate as well as directly via JDBC (datasource). The datasource is > defined in the server.xml file as follows: > > :

Active DataSource Connection count never decreasing with PostgreSQL

2010-02-02 Thread Alexander Hartner
I have developed an application which accesses a database via Hibernate as well as directly via JDBC (datasource). The datasource is defined in the server.xml file as follows: By default I use an embedded H2 databas