How to use reserved words in SQL query?

Question

I have tried several ideas using prepared statement, but none of them worked. These are:

String insertSQL = "INSERT INTO APP.TEST (Name, 'role') VALUES (?, ?)";

String insertSQL = "INSERT INTO APP.TEST (Name, [role]) VALUES (?, ?)";

String insertSQL = "INSERT INTO APP.TEST (Name, role) VALUES (?, ?)";

use role , it should work. It seems overstackflow remove the chars. — Samir Das
– Samir Das, Commented Apr 5, 2015 at 16:24
Derby docs specify double quotes for identifiers. db.apache.org/derby/docs/10.7/ref/crefsqlj1003454.html — Michael Berkowski
– Michael Berkowski, Commented Apr 5, 2015 at 16:25

Michael Berkowski · Accepted Answer · 2015-04-05 16:57:04Z

2

Apache Derby's documentation specifies that delimited SQL identifiers may be double-quoted. So your SQL string would eventually look like:

INSERT INTO APP.TEST (Name, "role") VALUES (?, ?)

Since that is being placed inside a string already double-quoted, backslash-escape the inner quotes:

String insertSQL = "INSERT INTO APP.TEST (Name, \"role\") VALUES (?, ?)";

Derby's list of reserved words does not currently specify role as reserved, but if in your implementation it does appear to be reserved, you must quote it accordingly.

answered Apr 5, 2015 at 16:57

Michael Berkowski

271k47 gold badges451 silver badges395 bronze badges

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

2 Comments

user1036645 Over a year ago

I encountered another issue, which is SQL name conflict with the table name. I tried String insertSQL = "INSERT INTO DATABASE.\"User\" (Name, username, password, \"role\") " + "VALUES (?, ?, ?, ?)"; but it did not work.

Michael Berkowski Over a year ago

Quote both parts I suppose, like \"DATABASE\".\"User\" -- that's how the documentation example looks.

Collectives™ on Stack Overflow

How to use reserved words in SQL query?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related