cancel
Showing results for 
Search instead for 
Did you mean: 

How to resolve : MySQLNonTransientConectionException when trying to run a query against MySQL DB

SOLVED
New Contributor

How to resolve : MySQLNonTransientConectionException when trying to run a query against MySQL DB

I'm recieving the below error when I run my query against my MySQL DB. The result of this just has max of 4 records. If I run it against my DB client like TOAD or Aquadata, it works perfectly fine. I'm sure this error is because of the SOAPUIPro(Ready API) tool where the connection object might not be properly handled internally and hence its resulting this error. This was running fine for first few runs and then it started to give this error. Has somebody faced this issue and if so, can you please help me as this is frustrating and uts blocking my automated test.

 

 

2019-08-01 14:54:16.029 - Error getting response; com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Too many connections

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

Re: How to resolve : MySQLNonTransientConectionException when trying to run a query against MySQL D

Hi @MeenaExplore,

 

Please try the suggestions from these articles:

https://stackoverflow.com/questions/5274558/mysqlnontransientconnectionexception-too-many-connection...

https://support.xebialabs.com/hc/en-us/articles/360000141586-How-to-fix-com-mysql-jdbc-exceptions-jd...

https://intojava.wordpress.com/2017/09/27/mysqlnontransientconnectionexception-too-many-connections/

 

If this doesn't help, please provide the following details:

- What driver do you use?

- Can you reproduce the issue after you restart ReadyAPI?

- Can you reproduce the issue for another query?



Did my reply answer your question? Give Kudos or Accept it as a Solution to help others.↓↓↓↓↓

View solution in original post

3 REPLIES 3
Moderator

Re: How to resolve : MySQLNonTransientConectionException when trying to run a query against MySQL D

Thanks for reaching out, @MeenaExplore. Sorry to hear that you are facing this situation.

 

Community, can we help MeenaExplore with comments, suggestions, ideas?


Olga Terentieva
SmartBear Assistant Community Manager

Moderator

Re: How to resolve : MySQLNonTransientConectionException when trying to run a query against MySQL D

Hi @MeenaExplore,

 

Please try the suggestions from these articles:

https://stackoverflow.com/questions/5274558/mysqlnontransientconnectionexception-too-many-connection...

https://support.xebialabs.com/hc/en-us/articles/360000141586-How-to-fix-com-mysql-jdbc-exceptions-jd...

https://intojava.wordpress.com/2017/09/27/mysqlnontransientconnectionexception-too-many-connections/

 

If this doesn't help, please provide the following details:

- What driver do you use?

- Can you reproduce the issue after you restart ReadyAPI?

- Can you reproduce the issue for another query?



Did my reply answer your question? Give Kudos or Accept it as a Solution to help others.↓↓↓↓↓

View solution in original post

Moderator

Re: How to resolve : MySQLNonTransientConectionException when trying to run a query against MySQL D

Thank you for the reply, @Nastya_Khovrina.

 

@MeenaExplore, did the above information help you? We are looking forward to hearing from you.

 


Olga Terentieva
SmartBear Assistant Community Manager