Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-10 Thread Saurabh Saraswat
Chris, Thanks for your regular guidance and valuable suggestions! On Fri, Apr 11, 2014 at 11:33 AM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Daniel, > > On 4/8/14, 6:36 AM, Daniel Mikusa wrote: > > On Apr 8, 2014, at 8:22

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-10 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Daniel, On 4/8/14, 6:36 AM, Daniel Mikusa wrote: > On Apr 8, 2014, at 8:22 AM, Saurabh Saraswat > wrote: > >> Dear Dan, >> >> Thanks for taking time to respond me. >> >> My updated Resource Tag is - >> >> > type="javax.sql.DataSource" maxActive

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-10 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Saurabh, On 4/8/14, 6:22 AM, Saurabh Saraswat wrote: > Thanks for taking time to respond me. > > My updated Resource Tag is - > > type="javax.sql.DataSource" maxActive="100" maxIdle="30" > maxWait="1" That's a lot of connections. Are you sur

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-08 Thread Daniel Mikusa
On Apr 8, 2014, at 8:22 AM, Saurabh Saraswat wrote: > Dear Dan, > > Thanks for taking time to respond me. > > My updated Resource Tag is - > >maxActive="100" maxIdle=“30" As Chris mentioned, set maxActive 1 in your dev environment. That will help you find the problem more qu

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-08 Thread Saurabh Saraswat
Dear Dan, Thanks for taking time to respond me. My updated Resource Tag is - I have also cross checked my code. I am closing the connection properly in finally block. Also have set the max_connection=250 in etc/my.cnf for MySql. Even now i am not getting any Exception but my Application gets

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-08 Thread Daniel Mikusa
On Apr 8, 2014, at 5:46 AM, Saurabh Saraswat wrote: > On Fri, Apr 4, 2014 at 8:39 PM, Christopher Schultz < > ch...@christopherschultz.net> wrote: > >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA256 >> >> Daniel, >> >> On 4/4/14, 8:57 AM, Daniel Mikusa wrote: >>> On Apr 4, 2014, at 8:22 AM

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-08 Thread Saurabh Saraswat
On Fri, Apr 4, 2014 at 8:39 PM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Daniel, > > On 4/4/14, 8:57 AM, Daniel Mikusa wrote: > > On Apr 4, 2014, at 8:22 AM, Saurabh Saraswat > > wrote: > > > >> Dear Dan, > >> > >> Thanks f

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-04 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Daniel, On 4/4/14, 8:57 AM, Daniel Mikusa wrote: > On Apr 4, 2014, at 8:22 AM, Saurabh Saraswat > wrote: > >> Dear Dan, >> >> Thanks for your response! >> >> I have cross checked the user / password configuration. All is >> correct. > > If you’

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-04 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Saurabh, On 4/4/14, 1:19 AM, Saurabh Saraswat wrote: > I am doing connection pooling with tomcat 7.0.39 and MySQL > 5.5.After searching on google and with your help i have done the > below things. Even i am able to get the connection successfully >

RE: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-04 Thread Propes, Barry L
-Original Message- From: Saurabh Saraswat [mailto:ssaras...@pivotalindia.com] Sent: Friday, April 04, 2014 7:23 AM To: Tomcat Users List Subject: Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39 Dear Dan, Thanks for your response! I have cross checked the user

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-04 Thread Daniel Mikusa
On Apr 4, 2014, at 8:22 AM, Saurabh Saraswat wrote: > Dear Dan, > > Thanks for your response! > > I have cross checked the user / password configuration. All is correct. If you’re getting “Access Denied” exceptions, there is only one cause and that’s bad credentials (or host + credentials, be

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-04 Thread David kerber
On 4/4/2014 8:22 AM, Saurabh Saraswat wrote: Dear Dan, Thanks for your response! I have cross checked the user / password configuration. All is correct. As i mentioned that initially i am getting the object of connection but after some time (After few hits to database from application) my web a

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-04 Thread Saurabh Saraswat
Dear Dan, Thanks for your response! I have cross checked the user / password configuration. All is correct. As i mentioned that initially i am getting the object of connection but after some time (After few hits to database from application) my web app goes to slow and than it stops working i i g

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-04 Thread Daniel Mikusa
On Apr 4, 2014, at 1:19 AM, Saurabh Saraswat wrote: > Dear All, > > I am doing connection pooling with tomcat 7.0.39 and MySQL 5.5.After > searching on google and with your help i have done the below things. > Even i am able to get the connection successfully using this but getting > some troubl

SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-03 Thread Saurabh Saraswat
Dear All, I am doing connection pooling with tomcat 7.0.39 and MySQL 5.5.After searching on google and with your help i have done the below things. Even i am able to get the connection successfully using this but getting some trouble and exception. I am explaining you all steps done by me- *1. Ha