Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

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

-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

-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

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

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

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

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

-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

-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

-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

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

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

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

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

RE: SQLNestedException: Cannot create PoolableConnectionFactory

Users List Subject: Re: SQLNestedException: Cannot create PoolableConnectionFactory Is this the right forum for your question? It looks like the db isn't running or isn't accessible. If there's a Tomcat problem, please include exact OS, JVM and Tomcat version numbers. p On 3

Re: SQLNestedException: Cannot create PoolableConnectionFactory

Is this the right forum for your question? It looks like the db isn't running or isn't accessible. If there's a Tomcat problem, please include exact OS, JVM and Tomcat version numbers. p On 31 May 2010, at 12:30, ennidhi wrote: > > I am getting this exception. Everything seems to be fine. >

Re: SQLNestedException

1st. verifiy that the driver you need is in the Tomcat common lib. 2nd. verify your config in your server.xml and make sure your character "case" is correct. 3rd, double check your web.xml or context.xml to make sure your referencing your DataSource correctly, and finally post this and your class(