0

I need to establish a connection to MySQL DB. Using some examples from the Internet, I managed to have a simple JSP accessing the DB and displaying data on the browser.

Next, I developed a small servlet querying exactly the same table (copy-paste of the SELECT statement).

This time, the Servlet is being accessed (I can see titles deployed by the JSP) but the access to the DB fails with the following exception message:

SQLException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Again, within the same TOMCAT instance, JSP works while the Servlet doesn't.

Any clue? Could it be an issue of versions used in the Servlet development (Eclipse), and if so, how can I check which version is being used in the TOMCAT and which within Eclipse?

Thanks!!

As far as I can see, this is not a duplicate as suggested in the first comment. Please read the details of the problem before marking it as duplicate.

FDavidov
  • 3,505
  • 6
  • 23
  • 59
  • Possible duplicate of [Solving a "communications link failure" with JDBC and MySQL](http://stackoverflow.com/questions/6865538/solving-a-communications-link-failure-with-jdbc-and-mysql) – malaguna Dec 09 '15 at 13:02
  • No Duplicate: I checked the link as well as some links therein. it is not a matter of timeout, and the connection does work vis-à-vis JSP. By the way, the referenced entry is not marked as being answered. – FDavidov Dec 09 '15 at 13:13

1 Answers1

0

Problem solved. Was using the wrong IP address of the DB. My mistake.

FDavidov
  • 3,505
  • 6
  • 23
  • 59