Java mysql connection is error

Question

I tried connect mysql in java but there is compiler error.

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

I added mysql libraray but this is defective : Class.forName("com.mysql.jdbc.Driver");

What should I do?

You should include the SQL code in your question. – Darren Jul 08 '13 at 12:48 — Darren, Jul 08 '13 at 12:48
Your SQL query is probably wrong. – ibrahim Jul 08 '13 at 12:49 — ibrahim, Jul 08 '13 at 12:49
Are you sure, looks to me as exception not as compile error – ajay.patel Jul 08 '13 at 12:49 — ajay.patel, Jul 08 '13 at 12:49

score 1 · Answer 1 · edited Jul 08 '13 at 12:55

1

MySQLSyntaxErrorException means that you are already connected to MySQL but you have some problems with your SQL script, that you're trying to execute.

edited Jul 08 '13 at 12:55

Buhake Sindi

87,898
29
167
228

answered Jul 08 '13 at 12:51

Natalia

4,362
24
25

Java mysql connection is error

1 Answers1