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 ma...@apache.org: On 26/02/2015 22:56, Christopher Schultz wrote: The solution is to put your Resource into your

RE: Connection leak Tomcat7 and Oracle

2015-03-04 Thread Jeffrey Janner
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 MESSAGE- Hash: SHA256 Red, On 2/27/15 11:04 AM

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 ma...@apache.org: On 26/02/2015 22:56, Christopher Schultz wrote: The solution is to put your Resource into your

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 ma...@apache.org: On 26/02/2015 22:56, Christopher Schultz wrote: The solution is to put your Resource into your application's s/The solution/The best solution/ context.xml and not into the site-wide defaults.

Re: Connection leak Tomcat7 and Oracle

2015-02-27 Thread Антон Мацюк
2015-02-27 1:36 GMT+02:00 Mark Thomas ma...@apache.org: On 26/02/2015 22:56, Christopher Schultz wrote: The solution is to put your Resource 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

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

Re: Connection leak Tomcat7 and Oracle

2015-02-26 Thread Konstantin Kolinko
2015-02-26 19:28 GMT+03:00 Red redhoo...@gmail.com: 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,

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 redhoo...@gmail.com: Thank You all who responded; Did not want to waste your time, hence delayed response. To make sure no

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 Resource 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

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 redhoo...@gmail.com: 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

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: Resource name=*1 auth=Container type=javax.sql.DataSource

Re: Connection leak Tomcat7 and Oracle

2015-02-24 Thread Felix Schumacher
Am 24. Februar 2015 22:20:00 MEZ, schrieb Red redhoo...@gmail.com: 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: Resource name=*1

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: Resource

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 Resource 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: JMX Connection leak

2011-03-15 Thread Maimon Oded
/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 leak issue. That looks like an Hyperic issue to me. the issue is the following

JMX Connection leak

2011-03-13 Thread Maimon Oded
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 i stop hyperic agent

Re: JMX Connection leak

2011-03-13 Thread Mark Thomas
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 hundreds of jmx connection and never closes them.. after few

Connection Leak

2010-11-03 Thread Ziggy
Hi All, Resource name=myConn auth=Container type=javax.sql.DataSource driverClassName=oracle.jdbc.driver.OracleDriver url=jdbc:oracle:thin:@10.10.10.10.:1521:mydb username=username password=password maxActive=500 maxIdle=50 maxWait=-1

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, Resource name=myConn auth=Container type=javax.sql.DataSource driverClassName=oracle.jdbc.driver.OracleDriver url=jdbc:oracle:thin:@10.10.10.10.:1521:mydb

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

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 using

Re: Connection Leak

2010-11-03 Thread Ziggy
: 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 YOURDBUSER with the name of the database user your

RE: Connection Leak

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

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 SIGNATURE

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

RE: Diagnosing DBCP JDBC connection leak using removeAbandoned parm

2006-04-05 Thread Farrow, Marc
: 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/background that it makes sense. Basically we

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

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

2006-04-05 Thread David Smith
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: RE: Diagnosing DBCP JDBC connection leak using

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 too

Diagnosing DBCP JDBC connection leak using removeAbandoned parm

2006-04-04 Thread Richard Mixon
, 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 waiting

Re: DBCP connection leak after undeploy

2005-10-31 Thread Bogdan Calmac
, but then again I suppose it might affect ISP type users. PS I have these config values: maxActive=10 maxIdle=5 -Original Message- From: Bogdan Calmac [mailto:[EMAIL PROTECTED] Sent: Thursday 27 October 2005 19:27 To: Tomcat Users List Subject: Re: DBCP connection leak after undeploy

RE: DBCP connection leak after undeploy

2005-10-31 Thread Steve Kirk
: 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 ServletContextListener and close the datasource yourself in contextDestroyed

Re: DBCP connection leak after undeploy

2005-10-27 Thread Bogdan Calmac
? -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 simple web application consisting of a servlet which does a select from

RE: DBCP connection leak after undeploy

2005-10-27 Thread Steve Kirk
. -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 not cleaning up the JDBC resources defined in context.xml. When a context

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 sure

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