How to use

[manifit]

Hi All,
I I just want a sql validator not the optimizer and all?
How can I get just a validator ?
Please help

[manticore-projects]

Please refer to src/test/java/net/sf/jsqlparser/util/validation/ValidationTest.java:

        String sql = "SELECT * FROM tab1, tab2 WHERE tab1.id (+) = tab2.ref";
        Statement stmt = CCJSqlParserUtil.parse(sql);

        StatementValidator validator = new StatementValidator();
        validator.setContext(new ValidationContext()
                .setCapabilities(Arrays.asList(DatabaseType.SQLSERVER, DatabaseType.POSTGRESQL)));
        stmt.accept(validator);

        Map<ValidationCapability, Set<ValidationException>> unsupportedErrors = validator
                .getValidationErrors(DatabaseType.SQLSERVER);
        assertErrorsSize(unsupportedErrors, 1);
        assertNotSupported(unsupportedErrors.get(DatabaseType.SQLSERVER), Feature.oracleOldJoinSyntax);

        unsupportedErrors = validator.getValidationErrors(DatabaseType.POSTGRESQL);
        assertErrorsSize(unsupportedErrors, 1);
        assertNotSupported(unsupportedErrors.get(DatabaseType.POSTGRESQL), Feature.oracleOldJoinSyntax);

[manifit]

So, if I add dependency this in maven, and if I simply use this class with my query then it will work or some other things also I need to do for same ?

[manticore-projects]

Yes.

[wumpz]

As well you could look into: https://github.com/JSQLParser/JSqlParser/wiki/Examples-of-SQL-Validation.