On 10/31/01 12:56 PM, "Paul Hammant" <[EMAIL PROTECTED]> wrote:
> OK, javacc seems to be a good way to parse SQL : > > http://www.webgain.com/products/java_cc/ > http://www.cobase.cs.ucla.edu/pub/javacc/sql-oracle.jj > > Does anyone have any insights? Any view of pitfalls or downsides to its > use? If you just want a stand-alone database than using JavaCC will be fine, but if you are trying to make something that will work with embedded devices as Hypersonic was than using JavaCC is probably not something that you will want to use. If I remember correctly a JavaCC grammar with one rule will produce a parsing mechanism that's over 100k. Velocity has a relatively small grammar and the parsing mechanism weighs in at over 1mb. The grammar for SQL is by far the largest I've seen and you will probably get something huge. Totally guessing I would say 2-3mb. If you don't care about embedded devices than it probably doesn't matter, but JavaCC makes robust parsers not small ones :-) > Regards, > > - Paul H > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- jvz. Jason van Zyl http://tambora.zenplex.org http://jakarta.apache.org/turbine http://jakarta.apache.org/velocity http://jakarta.apache.org/alexandria http://jakarta.apache.org/commons -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>