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

RE: SQLNestedException: Cannot create PoolableConnectionFactory

2010-06-01 Thread Propes, Barry L
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

2010-05-31 Thread Pid *
> (ConnectionJDBC2.java:385) >at > net.sourceforge.jtds.jdbc.ConnectionJDBC3. > (ConnectionJDBC3.java:50) >at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182) >at > org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConn

SQLNestedException: Cannot create PoolableConnectionFactory

2010-05-31 Thread ennidhi
View this message in context: http://old.nabble.com/SQLNestedException%3A-Cannot-create-PoolableConnectionFactory-tp28730009p28730009.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: use

Re: SQLNestedException

2007-03-05 Thread Daniel Stephens
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(

SQLNestedException

2007-03-04 Thread Wojtek Kusch
Hi! I have a JSP-App and need a database connection (to the MS Access database "unleashed"). But, I get following exception: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' This is the context in "conf\Catalina\localhost"