You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@beehive.apache.org by ke...@apache.org on 2006/07/13 03:34:07 UTC

svn commit: r421473 [4/6] - in /beehive/sandbox/hornet: ./ controls/ controls/api/ controls/api/src/ controls/api/src/main/ controls/api/src/main/java/ controls/api/src/main/java/org/ controls/api/src/main/java/org/apache/ controls/api/src/main/java/or...

Added: beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SimpleCharStream.java
URL: http://svn.apache.org/viewvc/beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SimpleCharStream.java?rev=421473&view=auto
==============================================================================
--- beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SimpleCharStream.java (added)
+++ beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SimpleCharStream.java Wed Jul 12 18:34:03 2006
@@ -0,0 +1,401 @@
+/* Generated By:JavaCC: Do not edit this line. SimpleCharStream.java Version 3.0 */
+package org.apache.beehive.controls.system.jdbc.parser;
+
+/**
+ * An implementation of interface CharStream, where the stream is assumed to
+ * contain only ASCII characters (without unicode processing).
+ */
+
+public class SimpleCharStream
+{
+  public static final boolean staticFlag = false;
+  int bufsize;
+  int available;
+  int tokenBegin;
+  public int bufpos = -1;
+  protected int bufline[];
+  protected int bufcolumn[];
+
+  protected int column = 0;
+  protected int line = 1;
+
+  protected boolean prevCharIsCR = false;
+  protected boolean prevCharIsLF = false;
+
+  protected java.io.Reader inputStream;
+
+  protected char[] buffer;
+  protected int maxNextCharInd = 0;
+  protected int inBuf = 0;
+
+  protected void ExpandBuff(boolean wrapAround)
+  {
+     char[] newbuffer = new char[bufsize + 2048];
+     int newbufline[] = new int[bufsize + 2048];
+     int newbufcolumn[] = new int[bufsize + 2048];
+
+     try
+     {
+        if (wrapAround)
+        {
+           System.arraycopy(buffer, tokenBegin, newbuffer, 0, bufsize - tokenBegin);
+           System.arraycopy(buffer, 0, newbuffer,
+                                             bufsize - tokenBegin, bufpos);
+           buffer = newbuffer;
+
+           System.arraycopy(bufline, tokenBegin, newbufline, 0, bufsize - tokenBegin);
+           System.arraycopy(bufline, 0, newbufline, bufsize - tokenBegin, bufpos);
+           bufline = newbufline;
+
+           System.arraycopy(bufcolumn, tokenBegin, newbufcolumn, 0, bufsize - tokenBegin);
+           System.arraycopy(bufcolumn, 0, newbufcolumn, bufsize - tokenBegin, bufpos);
+           bufcolumn = newbufcolumn;
+
+           maxNextCharInd = (bufpos += (bufsize - tokenBegin));
+        }
+        else
+        {
+           System.arraycopy(buffer, tokenBegin, newbuffer, 0, bufsize - tokenBegin);
+           buffer = newbuffer;
+
+           System.arraycopy(bufline, tokenBegin, newbufline, 0, bufsize - tokenBegin);
+           bufline = newbufline;
+
+           System.arraycopy(bufcolumn, tokenBegin, newbufcolumn, 0, bufsize - tokenBegin);
+           bufcolumn = newbufcolumn;
+
+           maxNextCharInd = (bufpos -= tokenBegin);
+        }
+     }
+     catch (Throwable t)
+     {
+        throw new Error(t.getMessage());
+     }
+
+
+     bufsize += 2048;
+     available = bufsize;
+     tokenBegin = 0;
+  }
+
+  protected void FillBuff() throws java.io.IOException
+  {
+     if (maxNextCharInd == available)
+     {
+        if (available == bufsize)
+        {
+           if (tokenBegin > 2048)
+           {
+              bufpos = maxNextCharInd = 0;
+              available = tokenBegin;
+           }
+           else if (tokenBegin < 0)
+              bufpos = maxNextCharInd = 0;
+           else
+              ExpandBuff(false);
+        }
+        else if (available > tokenBegin)
+           available = bufsize;
+        else if ((tokenBegin - available) < 2048)
+           ExpandBuff(true);
+        else
+           available = tokenBegin;
+     }
+
+     int i;
+     try {
+        if ((i = inputStream.read(buffer, maxNextCharInd,
+                                    available - maxNextCharInd)) == -1)
+        {
+           inputStream.close();
+           throw new java.io.IOException();
+        }
+        else
+           maxNextCharInd += i;
+        return;
+     }
+     catch(java.io.IOException e) {
+        --bufpos;
+        backup(0);
+        if (tokenBegin == -1)
+           tokenBegin = bufpos;
+        throw e;
+     }
+  }
+
+  public char BeginToken() throws java.io.IOException
+  {
+     tokenBegin = -1;
+     char c = readChar();
+     tokenBegin = bufpos;
+
+     return c;
+  }
+
+  protected void UpdateLineColumn(char c)
+  {
+     column++;
+
+     if (prevCharIsLF)
+     {
+        prevCharIsLF = false;
+        line += (column = 1);
+     }
+     else if (prevCharIsCR)
+     {
+        prevCharIsCR = false;
+        if (c == '\n')
+        {
+           prevCharIsLF = true;
+        }
+        else
+           line += (column = 1);
+     }
+
+     switch (c)
+     {
+        case '\r' :
+           prevCharIsCR = true;
+           break;
+        case '\n' :
+           prevCharIsLF = true;
+           break;
+        case '\t' :
+           column--;
+           column += (8 - (column & 07));
+           break;
+        default :
+           break;
+     }
+
+     bufline[bufpos] = line;
+     bufcolumn[bufpos] = column;
+  }
+
+  public char readChar() throws java.io.IOException
+  {
+     if (inBuf > 0)
+     {
+        --inBuf;
+
+        if (++bufpos == bufsize)
+           bufpos = 0;
+
+        return buffer[bufpos];
+     }
+
+     if (++bufpos >= maxNextCharInd)
+        FillBuff();
+
+     char c = buffer[bufpos];
+
+     UpdateLineColumn(c);
+     return (c);
+  }
+
+  /**
+   * @deprecated 
+   * @see #getEndColumn
+   */
+
+  public int getColumn() {
+     return bufcolumn[bufpos];
+  }
+
+  /**
+   * @deprecated 
+   * @see #getEndLine
+   */
+
+  public int getLine() {
+     return bufline[bufpos];
+  }
+
+  public int getEndColumn() {
+     return bufcolumn[bufpos];
+  }
+
+  public int getEndLine() {
+     return bufline[bufpos];
+  }
+
+  public int getBeginColumn() {
+     return bufcolumn[tokenBegin];
+  }
+
+  public int getBeginLine() {
+     return bufline[tokenBegin];
+  }
+
+  public void backup(int amount) {
+
+    inBuf += amount;
+    if ((bufpos -= amount) < 0)
+       bufpos += bufsize;
+  }
+
+  public SimpleCharStream(java.io.Reader dstream, int startline,
+  int startcolumn, int buffersize)
+  {
+    inputStream = dstream;
+    line = startline;
+    column = startcolumn - 1;
+
+    available = bufsize = buffersize;
+    buffer = new char[buffersize];
+    bufline = new int[buffersize];
+    bufcolumn = new int[buffersize];
+  }
+
+  public SimpleCharStream(java.io.Reader dstream, int startline,
+                                                           int startcolumn)
+  {
+     this(dstream, startline, startcolumn, 4096);
+  }
+
+  public SimpleCharStream(java.io.Reader dstream)
+  {
+     this(dstream, 1, 1, 4096);
+  }
+  public void ReInit(java.io.Reader dstream, int startline,
+  int startcolumn, int buffersize)
+  {
+    inputStream = dstream;
+    line = startline;
+    column = startcolumn - 1;
+
+    if (buffer == null || buffersize != buffer.length)
+    {
+      available = bufsize = buffersize;
+      buffer = new char[buffersize];
+      bufline = new int[buffersize];
+      bufcolumn = new int[buffersize];
+    }
+    prevCharIsLF = prevCharIsCR = false;
+    tokenBegin = inBuf = maxNextCharInd = 0;
+    bufpos = -1;
+  }
+
+  public void ReInit(java.io.Reader dstream, int startline,
+                                                           int startcolumn)
+  {
+     ReInit(dstream, startline, startcolumn, 4096);
+  }
+
+  public void ReInit(java.io.Reader dstream)
+  {
+     ReInit(dstream, 1, 1, 4096);
+  }
+  public SimpleCharStream(java.io.InputStream dstream, int startline,
+  int startcolumn, int buffersize)
+  {
+     this(new java.io.InputStreamReader(dstream), startline, startcolumn, 4096);
+  }
+
+  public SimpleCharStream(java.io.InputStream dstream, int startline,
+                                                           int startcolumn)
+  {
+     this(dstream, startline, startcolumn, 4096);
+  }
+
+  public SimpleCharStream(java.io.InputStream dstream)
+  {
+     this(dstream, 1, 1, 4096);
+  }
+
+  public void ReInit(java.io.InputStream dstream, int startline,
+                          int startcolumn, int buffersize)
+  {
+     ReInit(new java.io.InputStreamReader(dstream), startline, startcolumn, 4096);
+  }
+
+  public void ReInit(java.io.InputStream dstream)
+  {
+     ReInit(dstream, 1, 1, 4096);
+  }
+  public void ReInit(java.io.InputStream dstream, int startline,
+                                                           int startcolumn)
+  {
+     ReInit(dstream, startline, startcolumn, 4096);
+  }
+  public String GetImage()
+  {
+     if (bufpos >= tokenBegin)
+        return new String(buffer, tokenBegin, bufpos - tokenBegin + 1);
+     else
+        return new String(buffer, tokenBegin, bufsize - tokenBegin) +
+                              new String(buffer, 0, bufpos + 1);
+  }
+
+  public char[] GetSuffix(int len)
+  {
+     char[] ret = new char[len];
+
+     if ((bufpos + 1) >= len)
+        System.arraycopy(buffer, bufpos - len + 1, ret, 0, len);
+     else
+     {
+        System.arraycopy(buffer, bufsize - (len - bufpos - 1), ret, 0,
+                                                          len - bufpos - 1);
+        System.arraycopy(buffer, 0, ret, len - bufpos - 1, bufpos + 1);
+     }
+
+     return ret;
+  }
+
+  public void Done()
+  {
+     buffer = null;
+     bufline = null;
+     bufcolumn = null;
+  }
+
+  /**
+   * Method to adjust line and column numbers for the start of a token.
+   */
+  public void adjustBeginLineColumn(int newLine, int newCol)
+  {
+     int start = tokenBegin;
+     int len;
+
+     if (bufpos >= tokenBegin)
+     {
+        len = bufpos - tokenBegin + inBuf + 1;
+     }
+     else
+     {
+        len = bufsize - tokenBegin + bufpos + 1 + inBuf;
+     }
+
+     int i = 0, j = 0, k = 0;
+     int nextColDiff = 0, columnDiff = 0;
+
+     while (i < len &&
+            bufline[j = start % bufsize] == bufline[k = ++start % bufsize])
+     {
+        bufline[j] = newLine;
+        nextColDiff = columnDiff + bufcolumn[k] - bufcolumn[j];
+        bufcolumn[j] = newCol + columnDiff;
+        columnDiff = nextColDiff;
+        i++;
+     } 
+
+     if (i < len)
+     {
+        bufline[j] = newLine++;
+        bufcolumn[j] = newCol + columnDiff;
+
+        while (i++ < len)
+        {
+           if (bufline[j = start % bufsize] != bufline[++start % bufsize])
+              bufline[j] = newLine++;
+           else
+              bufline[j] = newLine;
+        }
+     }
+
+     line = bufline[j];
+     column = bufcolumn[j];
+  }
+
+}

Propchange: beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SimpleCharStream.java
------------------------------------------------------------------------------
    svn:eol-style = native

Added: beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlFragment.java
URL: http://svn.apache.org/viewvc/beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlFragment.java?rev=421473&view=auto
==============================================================================
--- beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlFragment.java (added)
+++ beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlFragment.java Wed Jul 12 18:34:03 2006
@@ -0,0 +1,93 @@
+/*
+ * Copyright 2005 The Apache Software Foundation.
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ *
+ * $Header:$
+ */
+
+package org.apache.beehive.controls.system.jdbc.parser;
+
+import org.apache.beehive.controls.system.jdbc.TypeMappingsFactory;
+
+import java.lang.reflect.Method;
+
+/**
+ * The abstract base class for fragments generated during parsing.
+ */
+public abstract class SqlFragment {
+
+    /**
+     * True if this fragment shouldn't be cached since the prepared statement may change on each invocation.
+     * @return true if this fragment shouldn't be cached by the parser
+     */ 
+    boolean isDynamicFragment() {
+        return false;
+    }
+
+    /**
+     * Does this fragment contain a parameter value for a prepared statement
+     * @return true if this fragement doesn't contain a prepared statement value.
+     */
+    boolean hasParamValue() {
+        return false;
+    }
+
+    /**
+     * True if this fragment evaluates to a JdbcControl.ComplexSqlFragment, i.e.
+     * a value type which needs additional evaluation after reflection.
+     * 
+     * @param method Method.
+     * @param args Method args.
+     * @return true if evaluates to a complex sql fragment.
+     */
+    protected boolean hasComplexValue(Method method, Object[] args) {
+        return false;
+    }
+
+    /**
+     * Get the SQL data type for the parameter value contained within this fragment.
+     * @return The SQL data type for this fragment.
+     */
+    int getParamSqlDataType() {
+        return TypeMappingsFactory.TYPE_UNKNOWN;
+    }
+
+    /**
+     * Get the prepared statement parameter value contained within this fragment.
+     *
+     * @param method The annotated method
+     * @param args The method's parameters
+     * @return null if this fragment doesn't contain a parameter value.
+     */
+    Object[] getParameterValues(Method method, Object[] args)  {
+        return null;
+    }
+
+    /**
+     * Get the text for a prepared statement generated by this fragment.
+     * @param method The annotated method
+     * @param args The method's parameters
+     * @return A String containing the prepared statement text generated by this fragment
+     */
+    abstract String getPreparedStatementText(Method method, Object[] args);
+
+    /**
+     * Must be implemented for JUnit testing.
+     * @return The String value of this fragment.
+     */
+    public String toString() {
+        assert false : "Classes which extend SqlFragment must implement toString()";
+        return null;
+    }
+}

Propchange: beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlFragment.java
------------------------------------------------------------------------------
    svn:eol-style = native

Added: beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlFragmentContainer.java
URL: http://svn.apache.org/viewvc/beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlFragmentContainer.java?rev=421473&view=auto
==============================================================================
--- beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlFragmentContainer.java (added)
+++ beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlFragmentContainer.java Wed Jul 12 18:34:03 2006
@@ -0,0 +1,95 @@
+/*
+ * Copyright 2005 The Apache Software Foundation.
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ *
+ * $Header:$
+ */
+
+package org.apache.beehive.controls.system.jdbc.parser;
+
+import java.lang.reflect.Method;
+import java.util.ArrayList;
+
+/**
+ * The abstract base class for fragment's which may contain child fragments.
+ */
+public abstract class SqlFragmentContainer extends SqlFragment {
+
+    /** Child fragments of this container. */
+    protected ArrayList<SqlFragment> _children;
+
+    /**
+     * Construct a new SqlFragmentContainer instance.
+     */
+    SqlFragmentContainer() {
+        _children = new ArrayList<SqlFragment>();
+    }
+
+    /**
+     * Does this fragment contain a parameter value for a prepared statement?
+     * @return true If this fragment contains a parameter value for a PreparedStatement.
+     */
+    boolean hasParamValue() {
+        for (SqlFragment f : _children) {
+            if (f.hasParamValue()) {
+                return true;
+            }
+        }
+        return false;
+    }
+
+    /**
+     * Add a child.
+     * @param child Child to add.
+     */
+    void addChild(SqlFragment child) {
+        _children.add(child);
+    }
+
+    /**
+     * Return the array of children.
+     * @return An array of SqlFragments.
+     */
+    SqlFragment[] getChildren() {
+        SqlFragment[] fragments = new SqlFragment[_children.size()];
+        return _children.toArray(fragments);
+    }
+
+    /**
+     * Must be implemented for JUnit testing.
+     * @return The String value of this fragment and all of its child fragments.
+     */
+    public String toString() {
+        StringBuilder s = new StringBuilder();
+        for (SqlFragment f : _children) {
+            s.append(f.toString());
+        }
+        return s.toString();
+    }
+
+    /**
+     * builds the text of the prepared statement
+     *
+     * @param m The annotated method.
+     * @param args The method's parameters.
+     * @return The PreparedStatement text generated by this fragment and its children.
+     */
+    String getPreparedStatementText(Method m, Object[] args) {
+        StringBuilder sb = new StringBuilder();
+        for (SqlFragment sf : _children) {
+            sb.append(sf.getPreparedStatementText(m, args));
+        }
+        return sb.toString();
+    }
+}

Propchange: beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlFragmentContainer.java
------------------------------------------------------------------------------
    svn:eol-style = native

Added: beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammar.java
URL: http://svn.apache.org/viewvc/beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammar.java?rev=421473&view=auto
==============================================================================
--- beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammar.java (added)
+++ beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammar.java Wed Jul 12 18:34:03 2006
@@ -0,0 +1,538 @@
+/* Generated By:JavaCC: Do not edit this line. SqlGrammar.java */
+package org.apache.beehive.controls.system.jdbc.parser;
+import java.io.StringReader;
+
+public class SqlGrammar implements SqlGrammarConstants {
+    private StringBuilder buffer = new StringBuilder();
+    public static void main(String[] args) throws Exception
+    {
+        SqlGrammar parser = new SqlGrammar(new StringReader(args[0]));
+        SqlStatement statement = parser.parse();
+        System.out.println(statement.toString());
+    }
+
+//
+// Parse methods
+//
+
+
+//
+// Main parse method
+//
+  final public SqlStatement parse() throws ParseException {
+    SqlStatement statement = new SqlStatement();
+    SqlFragment frag;
+    Token t, sq;
+    label_1:
+    while (true) {
+      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+      case NON_EXPRESSION_TEXT:
+      case START_EXPRESSION:
+      case SQUOTE:
+        ;
+        break;
+      default:
+        jj_la1[0] = jj_gen;
+        break label_1;
+      }
+      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+      case NON_EXPRESSION_TEXT:
+        t = jj_consume_token(NON_EXPRESSION_TEXT);
+                                 statement.addChild(new LiteralFragment(t.image));
+        break;
+      case SQUOTE:
+        sq = jj_consume_token(SQUOTE);
+        t = jj_consume_token(STRING_LITERAL);
+                                       statement.addChild(new LiteralFragment(sq.image + t.image));
+        break;
+      case START_EXPRESSION:
+        frag = parseExpression();
+                                statement.addChild(frag);
+        break;
+      default:
+        jj_la1[1] = jj_gen;
+        jj_consume_token(-1);
+        throw new ParseException();
+      }
+    }
+    jj_consume_token(0);
+      {if (true) return statement;}
+    throw new Error("Missing return statement in function");
+  }
+
+//
+// Parse an expression delimited by '{}'
+//
+  final public SqlFragment parseExpression() throws ParseException {
+    Token t, tt = null;
+    SqlFragment frag = null;
+    jj_consume_token(START_EXPRESSION);
+    label_2:
+    while (true) {
+      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+      case WHITESPACE:
+        ;
+        break;
+      default:
+        jj_la1[2] = jj_gen;
+        break label_2;
+      }
+      jj_consume_token(WHITESPACE);
+    }
+    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+    case SQL_ESCAPE:
+    case SQL_SUBST:
+    case SQL_FN:
+      frag = parseSqlEscape();
+      break;
+    case JDBC_CALL:
+    case JDBC_RET:
+    case JDBC_DATE:
+    case JDBC_TIME:
+    case JDBC_TIMESTAMP:
+    case JDBC_FUNCTION:
+    case JDBC_ESCAPE:
+    case JDBC_OUTERJOIN:
+      frag = parseJdbcEscape();
+      break;
+    case IDENTIFIER:
+      t = jj_consume_token(IDENTIFIER);
+      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+      case REFLECT_SEP:
+        jj_consume_token(REFLECT_SEP);
+        tt = jj_consume_token(IDENTIFIER);
+        break;
+      default:
+        jj_la1[3] = jj_gen;
+        ;
+      }
+      jj_consume_token(END_EXPRESSION);
+                                                                         frag = new ReflectionFragment(t.image,(tt == null) ? null : tt.image);
+      break;
+    default:
+      jj_la1[4] = jj_gen;
+      jj_consume_token(-1);
+      throw new ParseException();
+    }
+    label_3:
+    while (true) {
+      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+      case WHITESPACE:
+        ;
+        break;
+      default:
+        jj_la1[5] = jj_gen;
+        break label_3;
+      }
+      jj_consume_token(WHITESPACE);
+    }
+     {if (true) return frag;}
+    throw new Error("Missing return statement in function");
+  }
+
+//
+// parse an sql: escape sequence
+//
+  final public SqlSubstitutionFragment parseSqlEscape() throws ParseException {
+    Token id1, id2;
+    Token t = null;
+    SqlSubstitutionFragment frag;
+    String func = null;
+    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+    case SQL_ESCAPE:
+    case SQL_SUBST:
+      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+      case SQL_ESCAPE:
+        jj_consume_token(SQL_ESCAPE);
+        break;
+      case SQL_SUBST:
+        jj_consume_token(SQL_SUBST);
+        break;
+      default:
+        jj_la1[6] = jj_gen;
+        jj_consume_token(-1);
+        throw new ParseException();
+      }
+      t = jj_consume_token(IDENTIFIER);
+           if (t != null) {
+             frag = new SqlSubstitutionFragment(new ReflectionFragment(t.image));
+           } else {
+             frag = new SqlSubstitutionFragment(new LiteralFragment(func));
+           }
+      break;
+    case SQL_FN:
+      jj_consume_token(SQL_FN);
+      label_4:
+      while (true) {
+        switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+        case SQL_FN_WHITESPACE:
+          ;
+          break;
+        default:
+          jj_la1[7] = jj_gen;
+          break label_4;
+        }
+        jj_consume_token(SQL_FN_WHITESPACE);
+      }
+      jj_consume_token(SQL_FN_NM);
+      label_5:
+      while (true) {
+        switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+        case SQL_FN_WHITESPACE:
+          ;
+          break;
+        default:
+          jj_la1[8] = jj_gen;
+          break label_5;
+        }
+        jj_consume_token(SQL_FN_WHITESPACE);
+      }
+      jj_consume_token(SQL_FN_PAREN);
+      label_6:
+      while (true) {
+        switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+        case SQL_FN_WHITESPACE:
+          ;
+          break;
+        default:
+          jj_la1[9] = jj_gen;
+          break label_6;
+        }
+        jj_consume_token(SQL_FN_WHITESPACE);
+      }
+      id1 = jj_consume_token(SQL_FN_IDENTIFIER);
+      label_7:
+      while (true) {
+        switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+        case SQL_FN_WHITESPACE:
+          ;
+          break;
+        default:
+          jj_la1[10] = jj_gen;
+          break label_7;
+        }
+        jj_consume_token(SQL_FN_WHITESPACE);
+      }
+      jj_consume_token(SQL_FN_COMMA);
+      label_8:
+      while (true) {
+        switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+        case SQL_FN_WHITESPACE:
+          ;
+          break;
+        default:
+          jj_la1[11] = jj_gen;
+          break label_8;
+        }
+        jj_consume_token(SQL_FN_WHITESPACE);
+      }
+      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+      case SQL_FN_PSTART:
+        t = jj_consume_token(SQL_FN_PSTART);
+        break;
+      default:
+        jj_la1[12] = jj_gen;
+        ;
+      }
+      id2 = jj_consume_token(SQL_FN_IDENTIFIER);
+      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+      case SQL_FN_PEND:
+        jj_consume_token(SQL_FN_PEND);
+        break;
+      default:
+        jj_la1[13] = jj_gen;
+        ;
+      }
+      label_9:
+      while (true) {
+        switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+        case SQL_FN_WHITESPACE:
+          ;
+          break;
+        default:
+          jj_la1[14] = jj_gen;
+          break label_9;
+        }
+        jj_consume_token(SQL_FN_WHITESPACE);
+      }
+      jj_consume_token(SQL_FN_END);
+         if (t == null) {
+           frag = new SqlSubstitutionFragment(new LiteralFragment("(" + id1.image + " IN (" + id2.image + ")"));
+         } else {
+           frag = new SqlSubstitutionFragment(new LiteralFragment("(" + id1.image + " IN ("),
+                                        new ReflectionFragment(id2.image),
+                                        new LiteralFragment("))"));
+         }
+      break;
+    default:
+      jj_la1[15] = jj_gen;
+      jj_consume_token(-1);
+      throw new ParseException();
+    }
+    jj_consume_token(END_EXPRESSION);
+      {if (true) return frag;}
+    throw new Error("Missing return statement in function");
+  }
+
+//
+// parse a param sub inside of a jdbc escape
+//
+  final public SqlFragment parseReflect() throws ParseException {
+   Token t, tt = null;
+   SqlFragment frag;
+    jj_consume_token(JDBC_PARAM);
+    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+    case PARAM_IDENTIFIER:
+      t = jj_consume_token(PARAM_IDENTIFIER);
+      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+      case PARAM_REFLECT_SEP:
+        jj_consume_token(PARAM_REFLECT_SEP);
+        tt = jj_consume_token(IDENTIFIER);
+        break;
+      default:
+        jj_la1[16] = jj_gen;
+        ;
+      }
+            frag = new ReflectionFragment(t.image, (tt == null) ? null : tt.image);
+      break;
+    case PARAM_LITERAL:
+      t = jj_consume_token(PARAM_LITERAL);
+              frag = new LiteralFragment(t.image);
+      break;
+    default:
+      jj_la1[17] = jj_gen;
+      jj_consume_token(-1);
+      throw new ParseException();
+    }
+    jj_consume_token(PARAM_END);
+      {if (true) return frag;}
+    throw new Error("Missing return statement in function");
+  }
+
+//
+// parse a jdbc escape sequence
+//
+  final public JdbcFragment parseJdbcEscape() throws ParseException {
+  Token lit, c;
+  JdbcFragment jfrag = new JdbcFragment();
+  jfrag.addChild(new LiteralFragment("{"));
+  SqlFragment frag = null;
+    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+    case JDBC_CALL:
+      c = jj_consume_token(JDBC_CALL);
+      break;
+    case JDBC_RET:
+      c = jj_consume_token(JDBC_RET);
+      break;
+    case JDBC_DATE:
+      c = jj_consume_token(JDBC_DATE);
+      break;
+    case JDBC_ESCAPE:
+      c = jj_consume_token(JDBC_ESCAPE);
+      break;
+    case JDBC_FUNCTION:
+      c = jj_consume_token(JDBC_FUNCTION);
+      break;
+    case JDBC_TIME:
+      c = jj_consume_token(JDBC_TIME);
+      break;
+    case JDBC_TIMESTAMP:
+      c = jj_consume_token(JDBC_TIMESTAMP);
+      break;
+    case JDBC_OUTERJOIN:
+      c = jj_consume_token(JDBC_OUTERJOIN);
+      break;
+    default:
+      jj_la1[18] = jj_gen;
+      jj_consume_token(-1);
+      throw new ParseException();
+    }
+         jfrag.addChild(new LiteralFragment(c.image));
+    label_10:
+    while (true) {
+      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+      case JDBC_LIT:
+        lit = jj_consume_token(JDBC_LIT);
+                           jfrag.addChild(new LiteralFragment(lit.image));
+        break;
+      case JDBC_PARAM:
+        frag = parseReflect();
+                                  jfrag.addChild(frag);
+        break;
+      default:
+        jj_la1[19] = jj_gen;
+        jj_consume_token(-1);
+        throw new ParseException();
+      }
+      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
+      case JDBC_LIT:
+      case JDBC_PARAM:
+        ;
+        break;
+      default:
+        jj_la1[20] = jj_gen;
+        break label_10;
+      }
+    }
+    jj_consume_token(JDBC_END);
+      jfrag.addChild(new LiteralFragment("}"));
+      {if (true) return jfrag;}
+    throw new Error("Missing return statement in function");
+  }
+
+  public SqlGrammarTokenManager token_source;
+  SimpleCharStream jj_input_stream;
+  public Token token, jj_nt;
+  private int jj_ntk;
+  private int jj_gen;
+  final private int[] jj_la1 = new int[21];
+  static private int[] jj_la1_0;
+  static private int[] jj_la1_1;
+  static {
+      jj_la1_0();
+      jj_la1_1();
+   }
+   private static void jj_la1_0() {
+      jj_la1_0 = new int[] {0xe,0xe,0x100000,0x100,0x2ffe00,0x100000,0x600,0x40000000,0x40000000,0x40000000,0x40000000,0x40000000,0x10000000,0x20000000,0x40000000,0xe00,0x0,0x0,0xff000,0x0,0x0,};
+   }
+   private static void jj_la1_1() {
+      jj_la1_1 = new int[] {0x0,0x0,0x0,0x0,0x0,0x0,0x0,0x0,0x0,0x0,0x0,0x0,0x0,0x0,0x0,0x0,0x10,0x28,0x0,0x6,0x6,};
+   }
+
+  public SqlGrammar(java.io.InputStream stream) {
+    jj_input_stream = new SimpleCharStream(stream, 1, 1);
+    token_source = new SqlGrammarTokenManager(jj_input_stream);
+    token = new Token();
+    jj_ntk = -1;
+    jj_gen = 0;
+    for (int i = 0; i < 21; i++) jj_la1[i] = -1;
+  }
+
+  public void ReInit(java.io.InputStream stream) {
+    jj_input_stream.ReInit(stream, 1, 1);
+    token_source.ReInit(jj_input_stream);
+    token = new Token();
+    jj_ntk = -1;
+    jj_gen = 0;
+    for (int i = 0; i < 21; i++) jj_la1[i] = -1;
+  }
+
+  public SqlGrammar(java.io.Reader stream) {
+    jj_input_stream = new SimpleCharStream(stream, 1, 1);
+    token_source = new SqlGrammarTokenManager(jj_input_stream);
+    token = new Token();
+    jj_ntk = -1;
+    jj_gen = 0;
+    for (int i = 0; i < 21; i++) jj_la1[i] = -1;
+  }
+
+  public void ReInit(java.io.Reader stream) {
+    jj_input_stream.ReInit(stream, 1, 1);
+    token_source.ReInit(jj_input_stream);
+    token = new Token();
+    jj_ntk = -1;
+    jj_gen = 0;
+    for (int i = 0; i < 21; i++) jj_la1[i] = -1;
+  }
+
+  public SqlGrammar(SqlGrammarTokenManager tm) {
+    token_source = tm;
+    token = new Token();
+    jj_ntk = -1;
+    jj_gen = 0;
+    for (int i = 0; i < 21; i++) jj_la1[i] = -1;
+  }
+
+  public void ReInit(SqlGrammarTokenManager tm) {
+    token_source = tm;
+    token = new Token();
+    jj_ntk = -1;
+    jj_gen = 0;
+    for (int i = 0; i < 21; i++) jj_la1[i] = -1;
+  }
+
+  final private Token jj_consume_token(int kind) throws ParseException {
+    Token oldToken;
+    if ((oldToken = token).next != null) token = token.next;
+    else token = token.next = token_source.getNextToken();
+    jj_ntk = -1;
+    if (token.kind == kind) {
+      jj_gen++;
+      return token;
+    }
+    token = oldToken;
+    jj_kind = kind;
+    throw generateParseException();
+  }
+
+  final public Token getNextToken() {
+    if (token.next != null) token = token.next;
+    else token = token.next = token_source.getNextToken();
+    jj_ntk = -1;
+    jj_gen++;
+    return token;
+  }
+
+  final public Token getToken(int index) {
+    Token t = token;
+    for (int i = 0; i < index; i++) {
+      if (t.next != null) t = t.next;
+      else t = t.next = token_source.getNextToken();
+    }
+    return t;
+  }
+
+  final private int jj_ntk() {
+    if ((jj_nt=token.next) == null)
+      return (jj_ntk = (token.next=token_source.getNextToken()).kind);
+    else
+      return (jj_ntk = jj_nt.kind);
+  }
+
+  private java.util.Vector jj_expentries = new java.util.Vector();
+  private int[] jj_expentry;
+  private int jj_kind = -1;
+
+  public ParseException generateParseException() {
+    jj_expentries.removeAllElements();
+    boolean[] la1tokens = new boolean[39];
+    for (int i = 0; i < 39; i++) {
+      la1tokens[i] = false;
+    }
+    if (jj_kind >= 0) {
+      la1tokens[jj_kind] = true;
+      jj_kind = -1;
+    }
+    for (int i = 0; i < 21; i++) {
+      if (jj_la1[i] == jj_gen) {
+        for (int j = 0; j < 32; j++) {
+          if ((jj_la1_0[i] & (1<<j)) != 0) {
+            la1tokens[j] = true;
+          }
+          if ((jj_la1_1[i] & (1<<j)) != 0) {
+            la1tokens[32+j] = true;
+          }
+        }
+      }
+    }
+    for (int i = 0; i < 39; i++) {
+      if (la1tokens[i]) {
+        jj_expentry = new int[1];
+        jj_expentry[0] = i;
+        jj_expentries.addElement(jj_expentry);
+      }
+    }
+    int[][] exptokseq = new int[jj_expentries.size()][];
+    for (int i = 0; i < jj_expentries.size(); i++) {
+      exptokseq[i] = (int[])jj_expentries.elementAt(i);
+    }
+    return new ParseException(token, exptokseq, tokenImage);
+  }
+
+  final public void enable_tracing() {
+  }
+
+  final public void disable_tracing() {
+  }
+
+}

Propchange: beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammar.java
------------------------------------------------------------------------------
    svn:eol-style = native

Added: beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammar.jj
URL: http://svn.apache.org/viewvc/beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammar.jj?rev=421473&view=auto
==============================================================================
--- beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammar.jj (added)
+++ beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammar.jj Wed Jul 12 18:34:03 2006
@@ -0,0 +1,314 @@
+/*
+ * Copyright 2005 The Apache Software Foundation.
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ *
+ * $Header:$
+ */
+
+options {
+  STATIC = false;
+  UNICODE_INPUT = true;
+  DEBUG_TOKEN_MANAGER = false;
+  DEBUG_PARSER = false;
+}
+
+//
+// parser declarations
+//
+PARSER_BEGIN(SqlGrammar)
+
+package org.apache.beehive.controls.system.jdbc.parser;
+import java.io.StringReader;
+
+public class SqlGrammar
+{
+    private StringBuilder buffer = new StringBuilder();
+    public static void main(String[] args) throws Exception
+    {
+        SqlGrammar parser = new SqlGrammar(new StringReader(args[0]));
+        SqlStatement statement = parser.parse();
+        System.out.println(statement.toString());
+    }
+}
+
+PARSER_END(SqlGrammar)
+
+//
+// token mgr decls
+//
+TOKEN_MGR_DECLS : { }
+
+//
+// default token mgr state -- just collect anything until a { or ' is read
+//
+<DEFAULT> TOKEN:
+{
+        < NON_EXPRESSION_TEXT : (~["{","}","'"])+ >
+      | < START_EXPRESSION    : "{"> : IN_EXPRESSION
+      | < SQUOTE              : "'"> : IN_LITERAL
+}
+
+//
+// this token mgr state is used to skip over literal values which occur in non_expression_text,
+// they need to be skipped in this state since they may contain a '{}' which needs to be ignored.
+//
+<IN_LITERAL> TOKEN:
+{
+       <STRING_LITERAL :  (((~["'", "\\", "\n", "\r"])|<ECMA_ESCAPE_SEQUENCE>)* "'") > : DEFAULT
+     | <#ECMA_ESCAPE_SEQUENCE: "\\" |
+       (
+        ["n", "t", "b", "r", "f", "\\", "\""] |
+        ["0"-"7"] (["0"-"7"])? |
+        ["0"-"3"] ["0"-"7"] ["0"-"7"] |
+        ["x","X"] <HIT> <HIT> |
+        ["u","U"] <HIT> <HIT> <HIT> <HIT>
+       )
+      >
+     | <#HIT: ["0"-"9","a"-"f","A"-"F"] >
+}
+
+//
+// state for parse db control sql expressions, delimited by {}
+//
+<IN_EXPRESSION> TOKEN [IGNORE_CASE]:
+{
+       <END_EXPRESSION : "}" > { SwitchTo(DEFAULT); }
+     | <REFLECT_SEP    : "|">
+     | <SQL_ESCAPE     : "sql:"(<WHITESPACE>)+>
+     | <SQL_SUBST      : "sql:"(<WHITESPACE>)*"subst"(<WHITESPACE>)+>
+     | <SQL_FN         : "sql:"(<WHITESPACE>)*"fn"(<WHITESPACE>)+> : IN_SQLFN
+     | <JDBC_CALL      : "call"(<WHITESPACE>)+> : IN_JDBC
+     | <JDBC_RET       : "?"(<WHITESPACE>)*"="(<WHITESPACE>)*> : IN_JDBC
+     | <JDBC_DATE      : "d"(<WHITESPACE>)+> : IN_JDBC
+     | <JDBC_TIME      : "t"(<WHITESPACE>)+> : IN_JDBC
+     | <JDBC_TIMESTAMP : "ts"(<WHITESPACE>)+> : IN_JDBC
+     | <JDBC_FUNCTION  : "fn"(<WHITESPACE>)+> : IN_JDBC
+     | <JDBC_ESCAPE    : "escape"(<WHITESPACE>)+> : IN_JDBC
+     | <JDBC_OUTERJOIN : "oj"(<WHITESPACE>)+> : IN_JDBC
+     | <WHITESPACE     : " " | "\t" | "\r" | "\n">
+     | <IDENTIFIER     : (<LETTER>) (<LETTER>|<DIGIT>|".")* >
+     | < #LETTER       :
+        [
+          "\u0024",
+          "\u0041"-"\u005a",
+          "\u005f",
+          "\u0061"-"\u007a",
+          "\u00c0"-"\u00d6",
+          "\u00d8"-"\u00f6",
+          "\u00f8"-"\u00ff",
+          "\u0100"-"\u1fff",
+          "\u3040"-"\u318f",
+          "\u3300"-"\u337f",
+          "\u3400"-"\u3d2d",
+          "\u4e00"-"\u9fff",
+          "\uf900"-"\ufaff"
+       ]
+      >
+    | < #DIGIT        :
+       [
+         "\u0030"-"\u0039",
+         "\u0660"-"\u0669",
+         "\u06f0"-"\u06f9",
+         "\u0966"-"\u096f",
+         "\u09e6"-"\u09ef",
+         "\u0a66"-"\u0a6f",
+         "\u0ae6"-"\u0aef",
+         "\u0b66"-"\u0b6f",
+         "\u0be7"-"\u0bef",
+         "\u0c66"-"\u0c6f",
+         "\u0ce6"-"\u0cef",
+         "\u0d66"-"\u0d6f",
+         "\u0e50"-"\u0e59",
+         "\u0ed0"-"\u0ed9",
+         "\u1040"-"\u1049"
+       ]
+      >
+}
+
+//
+// special state for the sql:fn constuct
+//
+<IN_SQLFN> TOKEN [IGNORE_CASE]:
+{
+     <SQL_FN_END        : ")" > : IN_EXPRESSION
+   | <SQL_FN_NM         : "in">
+   | <SQL_FN_PAREN      : "(">
+   | <SQL_FN_COMMA      : ",">
+   | <SQL_FN_PSTART     : <START_EXPRESSION>>
+   | <SQL_FN_PEND       : <END_EXPRESSION>>
+   | <SQL_FN_WHITESPACE : <WHITESPACE>>
+   | <SQL_FN_IDENTIFIER : <IDENTIFIER> >
+}
+
+<IN_JDBC> TOKEN:
+{
+     <JDBC_END          : <END_EXPRESSION> > { SwitchTo(DEFAULT); }
+   | <JDBC_LIT          : (~["{","}"])+ >
+   | <JDBC_PARAM        : <START_EXPRESSION> > : IN_PARAM
+}
+
+<IN_PARAM> TOKEN:
+{
+     <PARAM_IDENTIFIER  : <IDENTIFIER> >
+   | <PARAM_REFLECT_SEP : <REFLECT_SEP> >
+   | <PARAM_LITERAL     : ("'" ((~["'",  "\\", "\n", "\r"])|<ECMA_ESCAPE_SEQUENCE>)* "'") >
+   | <PARAM_END         : <END_EXPRESSION> > { SwitchTo(IN_JDBC); }
+}
+
+
+//
+// Parse methods
+//
+
+
+//
+// Main parse method
+//
+SqlStatement parse() :
+{
+    SqlStatement statement = new SqlStatement();
+    SqlFragment frag;
+    Token t, sq;
+}
+{
+    (
+     (
+       (t=<NON_EXPRESSION_TEXT> {statement.addChild(new LiteralFragment(t.image));})
+      |
+       (sq=<SQUOTE>t=<STRING_LITERAL> {statement.addChild(new LiteralFragment(sq.image + t.image));})
+      |
+       (frag=parseExpression() {statement.addChild(frag);})
+     )
+    )* <EOF>
+
+    {
+      return statement;
+    }
+}
+
+//
+// Parse an expression delimited by '{}'
+//
+SqlFragment parseExpression() :
+{
+    Token t, tt = null;
+    SqlFragment frag = null;
+}
+{
+    <START_EXPRESSION>(<WHITESPACE>)*
+    (
+     frag = parseSqlEscape()
+     | frag = parseJdbcEscape()
+     | (t=<IDENTIFIER> (<REFLECT_SEP>tt=<IDENTIFIER>)? <END_EXPRESSION> {frag = new ReflectionFragment(t.image,(tt == null) ? null : tt.image);})
+    )
+    (<WHITESPACE>)*
+    //<END_EXPRESSION>
+
+    {
+     return frag;
+    }
+}
+
+//
+// parse an sql: escape sequence
+//
+SqlSubstitutionFragment parseSqlEscape() :
+{
+    Token id1, id2; 
+    Token t = null;
+    SqlSubstitutionFragment frag;
+    String func = null;
+}
+{
+(
+    (
+     (
+      (<SQL_ESCAPE> | <SQL_SUBST>) t=<IDENTIFIER>)
+         {
+           if (t != null) {
+             frag = new SqlSubstitutionFragment(new ReflectionFragment(t.image));
+           } else {
+             frag = new SqlSubstitutionFragment(new LiteralFragment(func));
+           }
+         }
+     )
+    |
+     (
+      (
+       <SQL_FN> (<SQL_FN_WHITESPACE>)* <SQL_FN_NM> (<SQL_FN_WHITESPACE>)* <SQL_FN_PAREN> (<SQL_FN_WHITESPACE>)*
+       id1=<SQL_FN_IDENTIFIER> (<SQL_FN_WHITESPACE>)* <SQL_FN_COMMA> (<SQL_FN_WHITESPACE>)* (t=<SQL_FN_PSTART>)?
+       id2=<SQL_FN_IDENTIFIER> (<SQL_FN_PEND>)? (<SQL_FN_WHITESPACE>)* <SQL_FN_END>
+      )
+       {
+         if (t == null) {
+           frag = new SqlSubstitutionFragment(new LiteralFragment("(" + id1.image + " IN (" + id2.image + ")"));
+         } else {
+           frag = new SqlSubstitutionFragment(new LiteralFragment("(" + id1.image + " IN ("),
+                                        new ReflectionFragment(id2.image),
+                                        new LiteralFragment("))"));
+         }
+       }
+     )
+) <END_EXPRESSION>
+
+    { return frag; } 
+}
+
+//
+// parse a param sub inside of a jdbc escape
+//
+SqlFragment parseReflect() :
+{
+   Token t, tt = null;
+   SqlFragment frag;
+} 
+{
+     <JDBC_PARAM>
+       (((t=<PARAM_IDENTIFIER>)(<PARAM_REFLECT_SEP>tt=<IDENTIFIER>)?
+          { frag = new ReflectionFragment(t.image, (tt == null) ? null : tt.image); })
+          
+       |
+        ((t=<PARAM_LITERAL>)
+            { frag = new LiteralFragment(t.image); }))
+     <PARAM_END>
+
+     {return frag;}
+}
+
+//
+// parse a jdbc escape sequence
+//
+JdbcFragment parseJdbcEscape() :
+{
+  Token lit, c;
+  JdbcFragment jfrag = new JdbcFragment();
+  jfrag.addChild(new LiteralFragment("{"));
+  SqlFragment frag = null;
+}
+
+{
+     (c=<JDBC_CALL>|c=<JDBC_RET>|c=<JDBC_DATE>|c=<JDBC_ESCAPE>|c=<JDBC_FUNCTION>|c=<JDBC_TIME>|c=<JDBC_TIMESTAMP>|c=<JDBC_OUTERJOIN>)
+        {jfrag.addChild(new LiteralFragment(c.image));}
+       (
+          (lit=<JDBC_LIT> {jfrag.addChild(new LiteralFragment(lit.image));}
+        | (frag=parseReflect()) { jfrag.addChild(frag);})
+       )+
+      <JDBC_END>
+
+    {
+      jfrag.addChild(new LiteralFragment("}"));
+      return jfrag;
+    }
+}
+

Propchange: beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammar.jj
------------------------------------------------------------------------------
    svn:eol-style = native

Added: beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammarConstants.java
URL: http://svn.apache.org/viewvc/beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammarConstants.java?rev=421473&view=auto
==============================================================================
--- beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammarConstants.java (added)
+++ beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammarConstants.java Wed Jul 12 18:34:03 2006
@@ -0,0 +1,95 @@
+/* Generated By:JavaCC: Do not edit this line. SqlGrammarConstants.java */
+package org.apache.beehive.controls.system.jdbc.parser;
+
+public interface SqlGrammarConstants {
+
+  int EOF = 0;
+  int NON_EXPRESSION_TEXT = 1;
+  int START_EXPRESSION = 2;
+  int SQUOTE = 3;
+  int STRING_LITERAL = 4;
+  int ECMA_ESCAPE_SEQUENCE = 5;
+  int HIT = 6;
+  int END_EXPRESSION = 7;
+  int REFLECT_SEP = 8;
+  int SQL_ESCAPE = 9;
+  int SQL_SUBST = 10;
+  int SQL_FN = 11;
+  int JDBC_CALL = 12;
+  int JDBC_RET = 13;
+  int JDBC_DATE = 14;
+  int JDBC_TIME = 15;
+  int JDBC_TIMESTAMP = 16;
+  int JDBC_FUNCTION = 17;
+  int JDBC_ESCAPE = 18;
+  int JDBC_OUTERJOIN = 19;
+  int WHITESPACE = 20;
+  int IDENTIFIER = 21;
+  int LETTER = 22;
+  int DIGIT = 23;
+  int SQL_FN_END = 24;
+  int SQL_FN_NM = 25;
+  int SQL_FN_PAREN = 26;
+  int SQL_FN_COMMA = 27;
+  int SQL_FN_PSTART = 28;
+  int SQL_FN_PEND = 29;
+  int SQL_FN_WHITESPACE = 30;
+  int SQL_FN_IDENTIFIER = 31;
+  int JDBC_END = 32;
+  int JDBC_LIT = 33;
+  int JDBC_PARAM = 34;
+  int PARAM_IDENTIFIER = 35;
+  int PARAM_REFLECT_SEP = 36;
+  int PARAM_LITERAL = 37;
+  int PARAM_END = 38;
+
+  int DEFAULT = 0;
+  int IN_LITERAL = 1;
+  int IN_EXPRESSION = 2;
+  int IN_SQLFN = 3;
+  int IN_JDBC = 4;
+  int IN_PARAM = 5;
+
+  String[] tokenImage = {
+    "<EOF>",
+    "<NON_EXPRESSION_TEXT>",
+    "\"{\"",
+    "\"\\\'\"",
+    "<STRING_LITERAL>",
+    "<ECMA_ESCAPE_SEQUENCE>",
+    "<HIT>",
+    "\"}\"",
+    "\"|\"",
+    "<SQL_ESCAPE>",
+    "<SQL_SUBST>",
+    "<SQL_FN>",
+    "<JDBC_CALL>",
+    "<JDBC_RET>",
+    "<JDBC_DATE>",
+    "<JDBC_TIME>",
+    "<JDBC_TIMESTAMP>",
+    "<JDBC_FUNCTION>",
+    "<JDBC_ESCAPE>",
+    "<JDBC_OUTERJOIN>",
+    "<WHITESPACE>",
+    "<IDENTIFIER>",
+    "<LETTER>",
+    "<DIGIT>",
+    "\")\"",
+    "\"in\"",
+    "\"(\"",
+    "\",\"",
+    "<SQL_FN_PSTART>",
+    "<SQL_FN_PEND>",
+    "<SQL_FN_WHITESPACE>",
+    "<SQL_FN_IDENTIFIER>",
+    "<JDBC_END>",
+    "<JDBC_LIT>",
+    "<JDBC_PARAM>",
+    "<PARAM_IDENTIFIER>",
+    "<PARAM_REFLECT_SEP>",
+    "<PARAM_LITERAL>",
+    "<PARAM_END>",
+  };
+
+}

Propchange: beehive/sandbox/hornet/controls/samples/jdbc/src/main/java/org/apache/beehive/controls/system/jdbc/parser/SqlGrammarConstants.java
------------------------------------------------------------------------------
    svn:eol-style = native