CCJSqlParserManager pm = new CCJSqlParserManager();
net.sf.jsqlparser.statement.Statement statement = null;
try {
statement = pm.parse(new StringReader(sqlEIDVIDUsers));
} catch (JSQLParserException jspe) {
ScrapClassLogger.error(
"SQL Statement Error - " + jspe.getMessage());
}
/
now you should use a class that implements StatementVisitor
to decide what to do based on the kind of the statement,
that is SELECT or INSERT etc. but here we are only
interested in SELECTS /
if (!(statement instanceof Select)) {
ScrapClassLogger.error(
"SQL Statement Error - "
+ "Expected Select statement not found");
}
getMessage from JSQLParserException spits out - null...
using version - 0.7.0
===========================================================
import net.sf.jsqlparser.JSQLParserException;
import net.sf.jsqlparser.parser.CCJSqlParserManager;
import net.sf.jsqlparser.statement.select.Select;
import java.io.StringReader;
String sqlEIDVIDUsers = "heh heh";
CCJSqlParserManager pm = new CCJSqlParserManager();
net.sf.jsqlparser.statement.Statement statement = null;
try {
statement = pm.parse(new StringReader(sqlEIDVIDUsers));
} catch (JSQLParserException jspe) {
ScrapClassLogger.error(
"SQL Statement Error - " + jspe.getMessage());
}
/
now you should use a class that implements StatementVisitor
to decide what to do based on the kind of the statement,
that is SELECT or INSERT etc. but here we are only
interested in SELECTS
/
if (!(statement instanceof Select)) {
ScrapClassLogger.error(
"SQL Statement Error - "
+ "Expected Select statement not found");
}
===========================================================
Output:-
2014-11-26 13:23:18,006 - ERROR - SQL Statement Error - null
2014-11-26 13:23:18,006 - ERROR - SQL Statement Error - Expected Select statement not found
Last edit: aj250037 2014-11-26