cvs commit: jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/test Tester.java

[hammant]

hammant     01/11/04 03:26:14

  Modified:    apps/db/src/java/org/apache/avalon/db/bcel/parser
                        LXSQLParser.java
               apps/db/src/java/org/apache/avalon/db/test Tester.java
  Log:
  Trying to get the lxsql parsing running
  
  Revision  Changes    Path
  1.3       +17 -5     
jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/bcel/parser/LXSQLParser.java
  
  Index: LXSQLParser.java
  ===================================================================
  RCS file: 
/home/cvs/jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/bcel/parser/LXSQLParser.java,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- LXSQLParser.java  2001/11/03 13:59:59     1.2
  +++ LXSQLParser.java  2001/11/04 11:26:14     1.3
  @@ -51,6 +51,7 @@
   import org.w3c.dom.DocumentType;
   import org.w3c.dom.NodeList;
   import org.w3c.dom.Node;
  +import org.w3c.dom.NamedNodeMap;
   import org.xml.sax.InputSource;
   import org.xml.sax.SAXException;
   
  @@ -62,6 +63,7 @@
   import java.io.Reader;
   import java.io.StringReader;
   import java.io.IOException;
  +import java.io.ByteArrayInputStream;
   
   
   /**
  @@ -69,7 +71,7 @@
    *
    *
    * @author Paul Hammant <a href="mailto:[EMAIL PROTECTED]">[EMAIL 
PROTECTED]</a>
  - * @version $Revision: 1.2 $
  + * @version $Revision: 1.3 $
    */
   public class LXSQLParser extends BaseBCELParser {
   
  @@ -131,14 +133,24 @@
   //</create-table>
   
   
  +        String docStr = XMLHDR + request.getSql();
  +        System.out.println("docStr=" + docStr);
   
  -        StringReader sr = new StringReader(XMLHDR + request.getSql());
  -        InputSource is = new InputSource(sr);
  +        //StringReader sr = new StringReader(XMLHDR + request.getSql());
  +        //InputSource is = new InputSource(sr);
  +        //StringReader sr2 = new StringReader(XMLHDR + request.getSql());
  +        ByteArrayInputStream bais = new 
ByteArrayInputStream(docStr.getBytes());
  +
           try
           {
  -            Document doc = mDocumentBuilder.parse(is);
  +            Document doc = mDocumentBuilder.parse(bais);
   
  -            String tableName = 
doc.getAttributes().getNamedItem("name").getNodeValue();
  +            System.out.println("doc" + doc);
  +            NamedNodeMap nnm = doc.getAttributes();
  +            System.out.println("nnm= " + nnm);
  +            Node n = nnm.getNamedItem("name");
  +            System.out.println("n=" + n);
  +            String tableName = n.getNodeValue();
   
               NodeList columnNodes = 
doc.getElementsByTagName("columns/column");
   
  
  
  
  1.3       +1 -1      
jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/test/Tester.java
  
  Index: Tester.java
  ===================================================================
  RCS file: 
/home/cvs/jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/test/Tester.java,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- Tester.java       2001/11/04 10:22:13     1.2
  +++ Tester.java       2001/11/04 11:26:14     1.3
  @@ -25,7 +25,7 @@
   
       private void test() throws Exception {
           Statement st = mCon.createStatement();
  -        st.executeUpdate("<create-table name=\"Fred\"><columns><column 
name=\"wilma\" type=\"varchar\" max=\"20\"/><column name=\"barney\" 
type=\"varchar\" max=\"20\"/></columns></create-table>");
  +        st.executeUpdate("<create-table><table 
name=\"Fred\"/><columns><column name=\"wilma\" type=\"varchar\" 
max=\"20\"/><column name=\"barney\" type=\"varchar\" 
max=\"20\"/></columns></create-table>");
       }
   
       private void close() throws Exception {
  
  
  

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>