SQL Query works in workbench but gives syntax error in java

Question

I ran the query in both sql Workbench and in the executeUpdate() method in java:

in Workbench:

INSERT INTO recentsearches (name) VALUES ("blah");

in java:

statement.executeUpdate("INSERT INTO recentsearches (name) VALUES (\""+name+"\""));

Assuming name = "blah". But I get a syntax error from running the query in java, I've already checked the string value for name. It definitely comes up as "blah", and I didn't forget the speech marks around string values, yet I still get a syntax error.

The error I get in my console is:

check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Perhaps "INSERT INTO recentsearches (name) VALUES ('"+name+"')" — Abhik Chakraborty
– Abhik Chakraborty, Commented Mar 30, 2015 at 14:11
check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 — Andrew Brick
– Andrew Brick, Commented Mar 30, 2015 at 14:13
"INSERT INTO recentsearches (name) VALUES("+name+")"; My advice, use PreparedStatement. — drgPP
– drgPP, Commented Mar 30, 2015 at 14:18
By me it's not the same, the String representation of your statement will looks as follows: INSERT INTO recentsearches (name) VALUES('somename'); — drgPP
– drgPP, Commented Mar 30, 2015 at 14:28

drgPP · Accepted Answer · 2015-03-30 14:23:56Z

1

Try to use:

"INSERT INTO recentsearches (name) VALUES("+name+")";

My advice, use PreparedStatement because it has:

-Precompilation and DB-side caching of the SQL statement leads to overall faster execution and the ability to reuse the same SQL statement in batches.

-Automatic prevention of SQL injection attacks by builtin escaping of quotes and other special characters. Note that this requires that you use any of the PreparedStatement setXxx() methods to set the values

answered Mar 30, 2015 at 14:23

drgPP

9362 gold badges7 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

SQL Query works in workbench but gives syntax error in java

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related