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
– Darren

2013-07-08 12:48:35 +00:00
Commented Jul 8, 2013 at 12:48 — Darren
– Darren, Commented Jul 8, 2013 at 12:48
Your SQL query is probably wrong.

ibrahim
– ibrahim

2013-07-08 12:49:16 +00:00
Commented Jul 8, 2013 at 12:49 — ibrahim
– ibrahim, Commented Jul 8, 2013 at 12:49
Are you sure, looks to me as exception not as compile error

ajay.patel
– ajay.patel

2013-07-08 12:49:19 +00:00
Commented Jul 8, 2013 at 12:49 — ajay.patel
– ajay.patel, Commented Jul 8, 2013 at 12:49

Buhake Sindi · Accepted Answer · 2013-07-08 12:55:39Z

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 8, 2013 at 12:55

Buhake Sindi

89.5k30 gold badges176 silver badges234 bronze badges

answered Jul 8, 2013 at 12:51

Natalia

4,5322 gold badges27 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Java mysql connection is error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related