Helpful error message when attempting DELETE/INSERT/UPDATE

Brought to you by: jackerm, mfrasca, sbrienen, simoc

#42 Helpful error message when attempting DELETE/INSERT/UPDATE

Status: open

Owner: Simon Chenery

Labels: None

Priority: 5

Updated: 2015-12-10

Created: 2015-12-10

Creator: Simon Chenery

Private: No

Report a helpful error message if user attempts to use a DELETE, INSERT or UPDATE SQL statement with CsvJdbc.

Currently,

stmt.execute("DELETE FROM sample");

throws the following unhelpful SQLException

java.sql.SQLException: Syntax error: Encountered " <NAME> "DELETE "" at line 1, column 1.
Was expecting:
"SELECT" ...

at org.relique.jdbc.csv.CsvStatement.execute(CsvStatement.java:559)
at org.relique.jdbc.csv.Runner1.main(Runner1.java:33)

and INSERT and UPDATE throw similarly unhelpful SQLExceptions.

Helpful error message when attempting DELETE/INSERT/UPDATE

Group

Searches

Help

#42 Helpful error message when attempting DELETE/INSERT/UPDATE

Discussion