I have a database that is in the cloud because it is from a site that I and some colleagues are creating and I needed to connect it to Netbeans, I put the host, the name of the bank, user name and password and everything is right, but when I go to do a SELECT, a data INSERT or even when I want to view the tables, the connection drops and presents the exception:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure.
If I run the command again it works, but only if I try again after the error occurs.
I wanted to resolve so I would not have to run the command twice ever.
Thank you !!!