Hi Ashwin,
I don't know whether anyone got back to you on this topic. I hope that
this addresses your question.
The DumpParseTree tracepoint causes Derby to print the ASTs to
derby.log. You can set this tracepoint when Derby starts up. Here for
instance is how you would do it if you were running Derby embedded under
the ij tool:
java -cp $CLASSPATH -Dderby.debug.true=DumpParseTree
-Dderby.stream.error.logSeverityLevel=0 org.apache.derby.tools.ij z.sql
Regards,
-Rick
Ashwin Jayaprakash wrote:
Hi,
Does anybody know if there is a way to parse and view the AST for an
SQL Query in Derby? I looked at the sqlparser.jj in the source code,
but couldn't find a way to start it and parse a query without hacking
into all the code.
Some thing like this one: http://www.experlog.com/gibello/zql/ ?
I am especially interested in extending the SQL grammar a little bit
by adding a few keywords and re-writing some queries issued by the
user. So, some kind of a Visitor-pattern would be nice.
Thanks,
Ashwin (www.JavaForU.com).
<http://adworks.rediff.com/cgi-bin/AdWorks/sigclick.cgi/www.rediff.com/signature-home.htm/[EMAIL PROTECTED]>