Subject Re: New JDBC driver keep throwing Dynamic SQL Error exception
Author llafranc78
Hi!!

You have to remove the semicolon at the end of your select string:

ResultSet rs = statement.executeQuery("SELECT * FROM
MESSAGES;");

must become

ResultSet rs = statement.executeQuery("SELECT * FROM
MESSAGES");


When using jdbc you must not add the semicolon at the end of any sql
statements!

Ciao
Luca