Re: [OT] Tomcat connection error

2019-02-18 Thread John Dale
Chris, On 2/18/19, Christopher Schultz wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > John, > > On 2/18/19 07:45, John Dale wrote: >> I agree - release your connection, commit transaction (if you have >> auto-commit set to false), and null-out your connection >> references. >> >>

Re: [OT] Tomcat connection error

2019-02-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 John, On 2/18/19 07:45, John Dale wrote: > I agree - release your connection, commit transaction (if you have > auto-commit set to false), and null-out your connection > references. > > The analogy in c++ is you need deallocate memory. Deallocati

Re: Tomcat connection error

2019-02-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Faisal, On 2/18/19 00:32, fai...@bestercapitalmedia.com wrote: > Dear all, > > > > I am working on a project and I am facing following issue on almost > every second day. I need to restart tomcat to get it running > again. > > Can someone guide

Re: Tomcat connection error

2019-02-18 Thread John Dale
y, February 18, 2019 5:45 PM > To: Tomcat Users List > Subject: Re: Tomcat connection error > > I agree - release your connection, commit transaction (if you have > auto-commit set to false), and null-out your connection references. > > The analogy in c++ is you need dea

RE: Tomcat connection error

2019-02-18 Thread faisal
, February 18, 2019 5:45 PM To: Tomcat Users List Subject: Re: Tomcat connection error I agree - release your connection, commit transaction (if you have auto-commit set to false), and null-out your connection references. The analogy in c++ is you need deallocate memory. Java has GC in Java at a base

Re: Tomcat connection error

2019-02-18 Thread John Dale
of problem down. > > Mark > > >> >> Faisal Zaidi >> >> -Original Message- >> From: Ted Spradley [mailto:ted.k.sprad...@gmail.com] >> Sent: Monday, February 18, 2019 1:52 PM >> To: Tomcat Users List >> Subject: Re: Tomcat connection

Re: Tomcat connection error

2019-02-18 Thread Mark Thomas
ication. I expect the connection pool includes tools to help you track that sort of problem down. Mark > > Faisal Zaidi > > -Original Message- > From: Ted Spradley [mailto:ted.k.sprad...@gmail.com] > Sent: Monday, February 18, 2019 1:52 PM > To: Tomcat Users List >

RE: Tomcat connection error

2019-02-18 Thread faisal
Users List Subject: Re: Tomcat connection error Hi Faisal, Your application(s) run as expected for a while, then you get the SQL Connection error? Then the only way to “fix it” is to restart Tomcat? At the same time are you also restarting MySQL? Thanks, Ted > On Feb 18, 2019, at 02:17, L

Re: Tomcat connection error

2019-02-18 Thread Ted Spradley
Hi Faisal, Your application(s) run as expected for a while, then you get the SQL Connection error? Then the only way to “fix it” is to restart Tomcat? At the same time are you also restarting MySQL? Thanks, Ted > On Feb 18, 2019, at 02:17, Luis Rodríguez Fernández wrote: > > Hello Faisal,

Re: Tomcat connection error

2019-02-18 Thread Luis Rodríguez Fernández
Hello Faisal, It looks like your problem is more related with your hikari connection pool than with tomcat itself. I would recommend you to double check your hikari configuration properties. Pay specially attention on how you are configuring your connection pool (minimum and maximum size, timeout,

Tomcat connection error

2019-02-17 Thread faisal
Dear all, I am working on a project and I am facing following issue on almost every second day. I need to restart tomcat to get it running again. Can someone guide me on it. Ask if you need some other insight to look into it. 2019-02-18 04:49:35.572 WARN 20698 --- [io-4200-exec-15] o.h.en