Recent changes to 42: Helpful error message when attempting DELETE/INSERT/UPDATEhttps://sourceforge.net/p/csvjdbc/support-requests/42/2015-12-10T19:16:58.973000ZRecent changes to 42: Helpful error message when attempting DELETE/INSERT/UPDATEHelpful error message when attempting DELETE/INSERT/UPDATE2015-12-10T19:16:58.973000Z2015-12-10T19:16:58.973000ZSimon Cheneryhttps://sourceforge.net/u/simoc/https://sourceforge.neta03410eb93bf81aadc03cd3e2498b0685eb62e8d<div class="markdown_content"><p>Report a helpful error message if user attempts to use a DELETE, INSERT or UPDATE SQL statement with CsvJdbc.</p>
<p>Currently, </p>
<div class="codehilite"><pre>stmt.execute("DELETE FROM sample");
</pre></div>
<p>throws the following unhelpful SQLException</p>
<div class="codehilite"><pre>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)
</pre></div>
<p>and INSERT and UPDATE throw similarly unhelpful SQLExceptions.</p></div>