Error on Creating a table from a Java application

Question

I'm trying to create table onto a MySQL Database, but when I click the button to perform, I'm getting the following error on GUI;

com.mysql.jdbc.exception.jdbc4.CommunicationsException: Communications link failure

The last packet sent succesfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Why does this error occur?

Full code on Pastebin; http://pastebin.com/NEic9iP4

Just edited and updated a link to pastebin for the code, and that's the only error — SoftwareEnthusiast, Jan 25 '14 at 05:18
possible duplicate of com.mysql.jdbc.exception.jdbc4.CommunicationsException: Communications link failure — Ashoka Lella, Jan 25 '14 at 05:19
yep, give it a host access by what name? Although the wild card % is there — SoftwareEnthusiast, Jan 25 '14 at 05:22
For remote mysql connections your IP should be having permission.Has your IP granted permission? — SpringLearner, Jan 25 '14 at 05:26
http://stackoverflow.com/questions/21346305/acces-denied-error-from-java-to-mysql from this question I have given access to buiud458_raklar'@'d24-36-33-148.home1.cgocable.net Is that what you mean? — SoftwareEnthusiast, Jan 25 '14 at 05:28
Your `url` (`dbc:mysql://buiud.com:3306/buiud458_androidhive`) looks wrong, shouldn't it be `jdbc:mysql://buiud.com:3306/buiud458_androidhive`? — MadProgrammer, Jan 25 '14 at 05:41
This question described [here][1] I guess. [1]: http://stackoverflow.com/questions/2983248/com-mysql-jdbc-exceptions-jdbc4-communicationsexception-communications-link-fai — Slow Harry, Jan 25 '14 at 08:42

score 0 · Answer 1 · answered Jan 25 '14 at 08:47

Your problem is this line:

url = "dbc:mysql://buiud.com:3306/buiud458_androidhive";

Change it to :

url = "jdbc:mysql://buiud.com:3306/buiud458_androidhive";

The error also comes when the Mysql service is not up. But for you I think the error is in your URL

Error on Creating a table from a Java application

1 Answers1