Package gudusoft.gsqlparser.parser

Class OdbcSqlParser

Object
gudusoft.gsqlparser.parser.AbstractSqlParser
gudusoft.gsqlparser.parser.OdbcSqlParser
All Implemented Interfaces:
SqlParser
public class OdbcSqlParser extends AbstractSqlParser
ODBC database SQL parser implementation.

This parser handles ODBC-specific SQL syntax including:

  • ODBC escape sequences ({ ... })
  • ODBC date/time literals ({ d 'date' }, { t 'time' }, { ts 'timestamp' })
  • ODBC function calls ({ fn function_name(...) })
  • ODBC outer join syntax ({ oj outer_join })
  • ODBC CALL statements ({ call procedure_name(...) })
  • Base MSSQL syntax (inherited)

Design Notes:

  • Extends AbstractSqlParser using the template method pattern
  • Uses TLexerOdbc for tokenization
  • Uses TParserOdbc for parsing
  • Based on MSSQL parser with ODBC escape sequence handling
  • Delimiter character: ';' for SQL statements

Usage Example: 

 // Get ODBC parser from factory
 SqlParser parser = SqlParserFactory.get(EDbVendor.dbvodbc);

 // Build context
 ParserContext context = new ParserContext.Builder(EDbVendor.dbvodbc)
     .sqlText("SELECT * FROM Employees WHERE hire_date > { d '2020-01-01' }")
     .build();

 // Parse
 SqlParseResult result = parser.parse(context);

 // Access statements
 TStatementList statements = result.getSqlStatements();
Since:
3.3.0.0
See Also: