An error of my SQL syntax

Question

try {
    String sql = "Insert into eyeglass (Brand, Model, Size, Color, Type, Case, Lens, Style, Warranty, Remarks) values(?,?,?,?,?,?,?,?,?,? )";

    pst = conn.prepareStatement(sql);
    pst.setString(1, txtBrand.getText());
    pst.setString(2, txtModel.getText());
    pst.setString(3, txtSize.getText());
    pst.setString(4, txtColor.getText());
    pst.setString(5, txtType.getText());
    pst.setString(6, txtCase.getText());
    pst.setString(7, txtLens.getText());
    pst.setString(8, txtStyle.getText());
    pst.setString(9, txtWarranty.getText());
    pst.setString(10, txtRemarks.getText());
    pst.execute();
    JOptionPane.showMessageDialog(null, "Saved");
} catch (Exception e) {
    JOptionPane.showMessageDialog(null, e);
}

I'm getting 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 'Case, Lens, Style, Warranty, Remarks) values(",",",",",",",",",")' in line 1 and I don't understand why it happens.

Have you tried the same sql in mysql? Ex.: print the sql, copy it and run it in mysql. I think you have quotes problem. single ' or double ". — Rajesh Ujade
– Rajesh Ujade, Commented Oct 4, 2014 at 9:01
unrelated...the joptionpane will how something like "java.lang.Exception...." use e.getMessage() or e.printStackTrace(); — Deval Khandelwal
– Deval Khandelwal, Commented Oct 4, 2014 at 9:22

Reimeus · Accepted Answer · 2014-10-04 13:21:40Z

4

CASE is a MySQL reserved word. Either escape the word or alter the database column name, the latter being preferable to avoid escaping completely.

String sql = 
  Insert into eyeglass 
   (Brand, Model, Size, Color, Type, `Case`, Lens, Style, Warranty, Remarks) values(?,?,?,?,?,?,?,?,?,? )";

edited Oct 4, 2014 at 13:21

answered Oct 4, 2014 at 9:02

Reimeus

160k16 gold badges224 silver badges282 bronze badges

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

1 Comment

RoyalRyt Over a year ago

Thank you @Reimeus :) I finally fixed the error. I really don't know that CASE was already a reserved word. Hehehe, thanks a lot again :)

Collectives™ on Stack Overflow

An error of my SQL syntax

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related