Error during test of my Data Adapter

Hello All.

I've just installed Jaspersoft Studio 1.3.1 in Eclipse Juno and tried to configure a simple Data Adapter for my localhosted MySQL.

Here is my config parameters :

JDBC Driver : com.mysql.jdbc.Driver

JDBC Url : jdbc:mysql://localhost:3306/test

Username : root

Password : the good one of course !

Driver classpath : /usr/share/mysql-connector-java-5.1.18.jar

When I clic on Test button, I receive this error :

net.sf.jasperreports.engine.JRException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: 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.

Caused by: Connexion refusée <= "Connection refused", in english


Do I have to define some "Connection properties" ?

philippe.lemenager's picture
Joined: Oct 17 2012 - 8:53am
Last seen: 5 years 1 month ago

1 Answer:

It looks like your MySQL server is not accepting TCP connection. Do you have networking enabled? And can the root user connect externally?

This link can help you out troubleshooting:

marianol's picture
Joined: Sep 13 2011 - 8:04am
Last seen: 4 years 5 months ago