Updating mysql database using jdbc

Question

I am using the following code to update my mysql database

String sql = "update stocks set price = ?, high = ?, change = ? where SYMBOL = ?";  
PreparedStatement stmt = conn.prepareStatement(sql); 

for(int i=0;i<ing;i++)
 {   

    stmt.setString(1, price[i]); 
    stmt.setString(2, high[i]); 
    stmt.setDouble(3, changedvalue[i]); 
    stmt.setString(4, SYMBOL[i]);

    stmt.addBatch(); 
} 
stmt.executeBatch();

where changedvalue is a array of type double. If i remove change it executes properly. But with it it throws the following error.

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 'change = 0.1 where SYMBOL = ''' at line 1 What is the issue

Why do you have 4 parameters, but you're setting 8?

Jon Skeet
– Jon Skeet

2012-03-15 10:20:51 +00:00
Commented Mar 15, 2012 at 10:20 — Jon Skeet
– Jon Skeet, Commented Mar 15, 2012 at 10:20
What's the type of change in the database?

Jon Skeet
– Jon Skeet

2012-03-15 10:22:06 +00:00
Commented Mar 15, 2012 at 10:22 — Jon Skeet
– Jon Skeet, Commented Mar 15, 2012 at 10:22

Jon Skeet · Accepted Answer · 2012-03-15 10:23:34Z

2

CHANGE is a reserved word in MySQL. Try quoting it:

update stocks set price = ?, high = ?, `change` = ? where SYMBOL = ?

answered Mar 15, 2012 at 10:23

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

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

Comments

Tom Anderson · Accepted Answer · 2012-03-15 10:21:21Z

0

Your SQL has four parameters. Your code is setting eight. That can't possibly work.

Is this your actual code? If so, that's your problem, and the solution is to make your SQL and code match.

If not, show us your actual code.

answered Mar 15, 2012 at 10:21

Tom Anderson

47.4k17 gold badges96 silver badges138 bronze badges

3 Comments

Bartek Jablonski Over a year ago

Where do you see "setting eight parameters"?

Jon Skeet Over a year ago

@BartekJablonski: It was before the question was edited. See my comment on the question.

Tom Anderson Over a year ago

Either that or I started drinking early today.

Collectives™ on Stack Overflow

Updating mysql database using jdbc

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related