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: java.net.ConnectException: Connexion refusée <= "Connection refused", in english
Do I have to define some "Connection properties" ?
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: http://nst.sourceforge.net/nst/docs/faq/ch06s04.html
