Re: Connection leak Tomcat7 and Oracle

2015-03-06 Thread Red
On 02/27/2015 11:59 AM, Christopher Schultz wrote: > Red, > > On 2/27/15 11:04 AM, Red wrote: > > On 02/27/2015 06:58 AM, Антон Мацюк wrote: > >> 2015-02-27 1:36 GMT+02:00 Mark Thomas : > >>> On 26/02/2015 22:56, Christopher Schultz wrote: > >>> > The solution is to put your into your >

RE: Connection leak Tomcat7 and Oracle

2015-03-04 Thread Jeffrey Janner
ing to make my point more noticeable by OP. > -Original Message- > From: Christopher Schultz [mailto:ch...@christopherschultz.net] > Sent: Friday, February 27, 2015 11:00 AM > To: Tomcat Users List > Subject: Re: Connection leak Tomcat7 and Oracle > > -BEGIN PGP SIGNED MESS

Re: Connection leak Tomcat7 and Oracle

2015-02-27 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Red, On 2/27/15 11:04 AM, Red wrote: > On 02/27/2015 06:58 AM, Антон Мацюк wrote: >> 2015-02-27 1:36 GMT+02:00 Mark Thomas : >>> On 26/02/2015 22:56, Christopher Schultz wrote: >>> The solution is to put your into your application's >>>

Re: Connection leak Tomcat7 and Oracle

2015-02-27 Thread Red
On 02/27/2015 06:58 AM, Антон Мацюк wrote: > 2015-02-27 1:36 GMT+02:00 Mark Thomas : >> On 26/02/2015 22:56, Christopher Schultz wrote: >> >>> The solution is to put your into your application's >> s/The solution/The best solution/ >> >>> context.xml and not into the site-wide defaults. Konstantin

Re: Connection leak Tomcat7 and Oracle

2015-02-27 Thread Антон Мацюк
2015-02-27 1:36 GMT+02:00 Mark Thomas : > > On 26/02/2015 22:56, Christopher Schultz wrote: > > > The solution is to put your into your application's > > s/The solution/The best solution/ > > > context.xml and not into the site-wide defaults. Konstantin may not > > have spelled-out the solution, b

Re: Connection leak Tomcat7 and Oracle

2015-02-26 Thread Mark Thomas
On 26/02/2015 22:56, Christopher Schultz wrote: > The solution is to put your into your application's s/The solution/The best solution/ > context.xml and not into the site-wide defaults. Konstantin may not > have spelled-out the solution, but he did give you all the information > you needed to

Re: Connection leak Tomcat7 and Oracle

2015-02-26 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Red, On 2/26/15 5:28 PM, Red wrote: > On 02/26/2015 12:29 PM, Konstantin Kolinko wrote: >> 2015-02-26 19:28 GMT+03:00 Red : >>> Thank You all who responded; Did not want to waste your time, >>> hence delayed response. >>> >>> To make sure no custom

Re: Connection leak Tomcat7 and Oracle

2015-02-26 Thread Red
On 02/26/2015 12:29 PM, Konstantin Kolinko wrote: > 2015-02-26 19:28 GMT+03:00 Red : >> Thank You all who responded; >> Did not want to waste your time, hence delayed response. >> >> To make sure no customization has been made on my end I have completely >> rebuilt system: Install OS (Ubuntu 14.04.

Re: Connection leak Tomcat7 and Oracle

2015-02-26 Thread Konstantin Kolinko
2015-02-26 19:28 GMT+03:00 Red : > Thank You all who responded; > Did not want to waste your time, hence delayed response. > > To make sure no customization has been made on my end I have completely > rebuilt system: Install OS (Ubuntu 14.04.2 LTS) including reformat of > all drives, selected tomca

Re: Connection leak Tomcat7 and Oracle

2015-02-26 Thread Red
Thank You all who responded; Did not want to waste your time, hence delayed response. To make sure no customization has been made on my end I have completely rebuilt system: Install OS (Ubuntu 14.04.2 LTS) including reformat of all drives, selected tomcat7 and ssh server during install when asked.

Re: Connection leak Tomcat7 and Oracle

2015-02-24 Thread Felix Schumacher
Am 24. Februar 2015 22:20:00 MEZ, schrieb Red : >OS: Ubuntu 14.04.2 LTS >Oracle: 12.1.0.1.0 or 11.2.0.3.0 >Tomcat: 7.0.52-1ubuntu0.1 >odjbc: Ojdbc6 or Ojdbc7 (placed in /var/lib/tomcat7/lib) >java version "1.8.0_31" of "1.7.0_65" > >Context.xml: > type="javax.sql.DataSource" >dri

Re: Connection leak Tomcat7 and Oracle

2015-02-24 Thread Filip Hanik
unless DBCP changed of course. I would add ​the following property to your element​ factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html On Tue, Feb 24, 2015 at 3:47 PM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -

Re: Connection leak Tomcat7 and Oracle

2015-02-24 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Red, On 2/24/15 4:20 PM, Red wrote: > OS: Ubuntu 14.04.2 LTS Oracle: 12.1.0.1.0 or 11.2.0.3.0 Tomcat: > 7.0.52-1ubuntu0.1 odjbc: Ojdbc6 or Ojdbc7 (placed in > /var/lib/tomcat7/lib) java version "1.8.0_31" of "1.7.0_65" > > Context.xml: type="java

Re: Connection leak Tomcat7 and Oracle

2015-02-24 Thread Mark Thomas
On 24/02/2015 21:20, Red wrote: > OS: Ubuntu 14.04.2 LTS > Oracle: 12.1.0.1.0 or 11.2.0.3.0 > Tomcat: 7.0.52-1ubuntu0.1 > odjbc: Ojdbc6 or Ojdbc7 (placed in /var/lib/tomcat7/lib) > java version "1.8.0_31" of "1.7.0_65" > > Context.xml: Which context.xml file? Mark -

Connection leak Tomcat7 and Oracle

2015-02-24 Thread Red
OS: Ubuntu 14.04.2 LTS Oracle: 12.1.0.1.0 or 11.2.0.3.0 Tomcat: 7.0.52-1ubuntu0.1 odjbc: Ojdbc6 or Ojdbc7 (placed in /var/lib/tomcat7/lib) java version "1.8.0_31" of "1.7.0_65" Context.xml: Immediately after tomcat startup, number of connection goes up until it reaches below: SQL> se

Re: JMX Connection "leak"

2011-03-15 Thread Maimon Oded
t; > option to fix it via tomcat/java configuration. the reason that i don't > know > > if this is an hyperic or a tomcat/java configuration issue is because > that > > when we use hyperic on other standard java daemon it doesn't have the > same > > connection l

Re: JMX Connection "leak"

2011-03-13 Thread Mark Thomas
this is an hyperic or a tomcat/java configuration issue is because that > when we use hyperic on other standard java daemon it doesn't have the same > connection leak issue. That looks like an Hyperic issue to me. > the issue is the following: > hyperic, overtime, opens h

JMX Connection "leak"

2011-03-13 Thread Maimon Oded
se that when we use hyperic on other standard java daemon it doesn't have the same connection leak issue. the issue is the following: hyperic, overtime, opens hundreds of jmx connection and never closes them.. after few hours our tomcat server is using 100% cpu without doing anything. once

RE: Connection Leak

2010-11-03 Thread Propes, Barry L
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 wrote: > Maybe try adding this, too as an attribute in the Resource tag. > > timeBetweenEvictionRunsMillis="-1

Re: Connection Leak

2010-11-03 Thread Ziggy
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 in > your code that aren't closing connections. In the sql below substitute > YOU

RE: Connection Leak

2010-11-03 Thread Propes, Barry L
Maybe try adding this, too as an attribute in the Resource tag. timeBetweenEvictionRunsMillis="-1" -Original Message- From: Jason Britton [mailto:jbritto...@gmail.com] Sent: Wednesday, November 03, 2010 9:05 AM To: Tomcat Users List Subject: Re: Connection Leak Since you&#

Re: Connection Leak

2010-11-03 Thread Jason Britton
Since you're using an Oracle database - another way to identify areas in your code that aren't closing connections. In the sql below substitute YOURDBUSER with the name of the database user your connections connect to your database with and YOURWEBSERVER with the name of your webserver. The resul

Re: Connection Leak

2010-11-03 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ziggy, On 11/3/2010 9:44 AM, Ziggy wrote: > Hi All, > >type="javax.sql.DataSource" > driverClassName="oracle.jdbc.driver.OracleDriver" > url="jdbc:oracle:thin:@10.10.10.10.:1521:mydb" > username="username"

Connection Leak

2010-11-03 Thread Ziggy
Hi All, I am trying to find out areas of the application where connections are NOT being closed. I added the removeAbandoned and logAbandoned clauses in my context file but if i check v$session on oracle it is still showing the same number of connections active even after 60 seconds. Is there so

Re: Connection Leak in java - Tomcat 6.0.18

2008-11-12 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Arun, Arun Raj Ramkumar wrote: > Hi friends, > Please let me know is there a way to find out connection leak in my java > code , when its deployed in tomcat. Am using tomcat 6.0.18 What type of connection? - -chris -BEGIN PGP

Connection Leak in java - Tomcat 6.0.18

2008-11-11 Thread Arun Raj Ramkumar
Hi friends, Please let me know is there a way to find out connection leak in my java code , when its deployed in tomcat. Am using tomcat 6.0.18 Regards, Arun.

Re: Diagnosing DBCP JDBC connection leak using removeAbandoned parm

2006-04-06 Thread Darryl L. Miles
Richard Mixon wrote: Marc, Thank you - We are using a recent version of the MySQL Connector/J (3.1.10), but maybe that does not mean anything. - Richard Hmm thats not very recent. I know of 2 bugs since then that have bitten me. 3.1.13 should be brewing and that would be the first releas

Re: Diagnosing DBCP JDBC connection leak using removeAbandoned parm - short version

2006-04-05 Thread Mark Lai
#1 Could be a logging bug. Notice how the day is always the same as the minute. On 4/5/06, Richard Mixon <[EMAIL PROTECTED]> wrote: > > I'm still curious about the crazy logAbandoned messages - not sure how to > interpret or rely on them. I'll try a again with a briefer posting - maybe > I > was

Re: Diagnosing DBCP JDBC connection leak using removeAbandoned parm

2006-04-05 Thread David Smith
Mixon wrote: Marc, Thank you - We are using a recent version of the MySQL Connector/J (3.1.10), but maybe that does not mean anything. - Richard -Original Message- From: Farrow, Marc [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 05, 2006 4:44 AM To: Tomcat Users List Subject: R

RE: Diagnosing DBCP JDBC connection leak using removeAbandoned parm

2006-04-05 Thread Richard Mixon
JDBC connection leak using removeAbandoned parm Can you change your code to something similar to below? I have seen issues with certain implementations of database drivers in which the JDBC interfaces are not being implemented/coded properly. Just remember that the order you call your close

RE: Diagnosing DBCP JDBC connection leak using removeAbandoned parm - short version

2006-04-05 Thread Richard Mixon
I'm still curious about the crazy logAbandoned messages - not sure how to interpret or rely on them. I'll try a again with a briefer posting - maybe I was too detailed in the original post. We are getting strange (erroneous?) messages because of the logAbandoned parameter: 1) The dates look lik

RE: Diagnosing DBCP JDBC connection leak using removeAbandoned parm

2006-04-05 Thread Farrow, Marc
d } } -Original Message- From: Richard Mixon [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 04, 2006 10:57 PM To: users@tomcat.apache.org Subject: Diagnosing DBCP JDBC connection leak using removeAbandoned parm Bear with me, I'll try to make this short, but want to give enough info

Diagnosing DBCP JDBC connection leak using removeAbandoned parm

2006-04-04 Thread Richard Mixon
4-b05, all running under Linux kernel 2.4.22-1.2115.nptlsmp on a dual Xeon dedicated server. Anyway, we determined that we had a connection leak when our application froze today. We obtained a thread dump and it showed that everyone of the Tomcat threads that were running application code, were waiti

Re: DBCP connection leak after undeploy

2005-10-31 Thread Bogdan Calmac
ge- > > From: Bogdan Calmac [mailto:[EMAIL PROTECTED] > > Sent: Monday 31 October 2005 16:50 > > To: Tomcat Users List > > Subject: Re: DBCP connection leak after undeploy > > > > > > In our company we share several Tomcat servers for all developers, so >

RE: DBCP connection leak after undeploy

2005-10-31 Thread Steve Kirk
t Users List > Subject: Re: DBCP connection leak after undeploy > > > In our company we share several Tomcat servers for all developers, so > that's why we use deploy/undeploy instead of start/stop. > > As a workaround for this problem, you can create a > ServletC

Re: DBCP connection leak after undeploy

2005-10-31 Thread Bogdan Calmac
; From: Bogdan Calmac [mailto:[EMAIL PROTECTED] > > Sent: Thursday 27 October 2005 19:27 > > To: Tomcat Users List > > Subject: Re: DBCP connection leak after undeploy > > > > > > > PS I don't think that I have see the problem that you have > > reported.

RE: DBCP connection leak after undeploy

2005-10-28 Thread Steve Kirk
Calmac [mailto:[EMAIL PROTECTED] > Sent: Thursday 27 October 2005 19:27 > To: Tomcat Users List > Subject: Re: DBCP connection leak after undeploy > > > > PS I don't think that I have see the problem that you have > reported. I run > > TC 5.5.9 on WinXP with

Re: DBCP connection leak after undeploy

2005-10-27 Thread Bogdan Calmac
> PS I don't think that I have see the problem that you have reported. I run > TC 5.5.9 on WinXP with Mysql 4.1.11 and Connector/J 3.1.8, have never > noticed that problem, my pools always seem to clean up fine. You might not have the same setup. I would suggest to try the following: 1. make sur

RE: DBCP connection leak after undeploy

2005-10-27 Thread Steve Kirk
pools always seem to clean up fine. > -Original Message- > From: Bogdan Calmac [mailto:[EMAIL PROTECTED] > Sent: Thursday 27 October 2005 16:49 > To: Tomcat Users List > Subject: Re: DBCP connection leak after undeploy > > > This problem is caused by Tomcat

Re: DBCP connection leak after undeploy

2005-10-27 Thread Bogdan Calmac
t; > redeploying the webapp while TC is running? Might help narrow down the > > cause slightly. Might be worth reporting to bugzilla? > > > > > -Original Message- > > > From: Bogdan Calmac [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday 26 October 200

Re: DBCP connection leak after undeploy

2005-10-26 Thread Bogdan Calmac
bugzilla? > > > -Original Message- > > From: Bogdan Calmac [mailto:[EMAIL PROTECTED] > > Sent: Wednesday 26 October 2005 02:18 > > To: users@tomcat.apache.org > > Subject: DBCP connection leak after undeploy > > > > > > I've written a

RE: DBCP connection leak after undeploy

2005-10-26 Thread Steve Kirk
gt; From: Bogdan Calmac [mailto:[EMAIL PROTECTED] > Sent: Wednesday 26 October 2005 02:18 > To: users@tomcat.apache.org > Subject: DBCP connection leak after undeploy > > > I've written a simple web application consisting of a servlet which > does a select from a

DBCP connection leak after undeploy

2005-10-25 Thread Bogdan Calmac
I've written a simple web application consisting of a servlet which does a select from a table and displays the result. It is then packaged as a war and deployed using the tomcat ant task. After executing the servlet, it is undeployed using the ant task again. stdout confirms that the webapp is dep