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 barry.l.propes@citi.com
 designates 85.158.136.227 as permitted sender)
From: "Propes, Barry L " <barry.l.propes@citi.com>
To: "'Tomcat Users List'" <users@tomcat.apache.org>
Date: Wed, 3 Nov 2010 12:43:16 -0500
Subject: RE: Connection Leak
Thread-Topic: Connection Leak
Thread-Index: Act7cvnmzCi0648DS4mKVtnbAUXnOwAC3nLQ
Message-ID: 
 <08382548D50D3049BD5599E1E3146B34110B936BE3@exgtmb06.nam.nsroot.net>
References: <AANLkTimXxmL7hh7qQ9-Pid_muOVUYUwZTQdLi0b3Uapw@mail.gmail.com>
	<AANLkTi=HO3O7agJjyUmaj-0HM=nw14L89hR8aT4AA3+G@mail.gmail.com>
	<08382548D50D3049BD5599E1E3146B34110B93695D@exgtmb06.nam.nsroot.net>
 <AANLkTikSPFSGhsKKiajtFmQ2ovq2nU-qhdy9n+Azfsag@mail.gmail.com>
In-Reply-To: <AANLkTikSPFSGhsKKiajtFmQ2ovq2nU-qhdy9n+Azfsag@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

I had a bit of a leak, and it stopped them...actually an error coupled with=
 a leak.

You might check with some of the other users -- I think they've recommended=
 Lamda Probe and some other tools to track down leaks.

-----Original Message-----
From: Ziggy [mailto:ziggy25@gmail.com]=20
Sent: Wednesday, November 03, 2010 11:19 AM
To: Tomcat Users List
Subject: Re: Connection Leak

Does that show cached queries?


On Wed, Nov 3, 2010 at 4:02 PM, Propes, Barry L <barry.l.propes@citi.com>wr=
ote:

> Maybe try adding this, too as an attribute in the Resource tag.
>
> timeBetweenEvictionRunsMillis=3D"-1"
>
> -----Original Message-----
> From: Jason Britton [mailto:jbritton31@gmail.com]
> Sent: Wednesday, November 03, 2010 9:05 AM
> To: Tomcat Users List
> Subject: Re: Connection Leak
>
> Since you're using an Oracle database - another way to identify areas=20
> in your code that aren't closing connections.  In the sql below=20
> substitute YOURDBUSER with the name of the database user your=20
> connections connect to your database with and YOURWEBSERVER with the=20
> name of your webserver.  The results of the sql query will give you=20
> the last executed sql for each of the open connections.  Then search=20
> your code for where this sql is being executed and double check you are c=
losing the connection appropriately.
>
> SELECT username, machine, oc.sql_text, COUNT(*) open_statements FROM=20
> v$session vs, v$open_cursor oc WHERE username =3D 'YOURDBUSER' AND=20
> machine =3D 'YOURWEBSERVER' AND oc.sid =3D vs.sid GROUP BY username,=20
> machine, oc.sql_text ORDER BY open_statements DESC
>
>
>
> On Wed, Nov 3, 2010 at 6:44 AM, Ziggy <ziggy25@gmail.com> wrote:
>
> > Hi All,
> >
> > <Resource name=3D"myConn" auth=3D"Container"
> >              type=3D"javax.sql.DataSource"
> > driverClassName=3D"oracle.jdbc.driver.OracleDriver"
> >              url=3D"jdbc:oracle:thin:@10.10.10.10.:1521:mydb"
> >              username=3D"username" password=3D"password" maxActive=3D"5=
00"
> > maxIdle=3D"50"
> >              maxWait=3D"-1" removeAbandoned=3D"true"
> > removeAbandonedTimeout=3D"60" logAbandoned=3D"true"
> > accessToUnderlyingConnectionAllowed=3D"true"
> > />
> >
> > I am trying to find out areas of the application where connections=20
> > are NOT being closed. I added the removeAbandoned and logAbandoned=20
> > clauses in my context file but if i check v$session on oracle it is=20
> > still showing the same number of connections active even after 60 secon=
ds.
> > Is there something wrong in the configuration above?
> >
> >
> > How exactly does it abandone the connections? what triggers it>?
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

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