Hi,
I am looking for a SQL parser which should return me a JAVA object
representation of the input SQL components. I tried out the SQL Parser
which is provided as a part of Apache Jackrabbit project.
Repository repository = new TransientRepository();
Session session = repository.login();
SessionNamespaceResolver resolver = new SessionNamespaceResolver(session);
QueryRootNode queryRootNode = QueryParser.parse("select ename, dname
from emp , dept where dname = 1 and enaum = 2 and dname = enaum"
, Query.SQL,
resolver);
The last statement fails with InvalidQueryException. Even, using table
alias gives errors. However, the following input SQL works fine:
"select ename, dname from emp , dept where dname = 1 and enaum = 2".
I wanted to know as to what features of SQL are supported by this
Parser. Or, is there any other parser which I can use.
Please let me know if I am missing something here.
Thanks,
Ankit Goel
