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]>



Reply via email to