Metacat

		"jdbc:oracle:thin:@localhost:test",

/**

 *        Name: DBSAXWriter.java

 *     Purpose: A Class that reads in an XML text document and

 *              write its contents to a database connection using SAX

 * Institution: National Center for Ecological Analysis and Synthesis

 *   Copyright: 2000

 *     Authors: Matt Jones

 *

 *     Version: '$Id$'

 */

import org.xml.sax.*;

import java.io.*;

import java.net.URL;

import java.net.MalformedURLException;

import java.sql.*;

import java.util.Stack;

// Extensions to the SAX Interfaces for Namespace support.

import oracle.xml.parser.v2.XMLDocumentHandler;

import oracle.xml.parser.v2.DefaultXMLDocumentHandler;

import oracle.xml.parser.v2.NSName;

import oracle.xml.parser.v2.SAXAttrList;

import oracle.xml.parser.v2.SAXParser;

public class DBSAXWriter {

  static  String 	defaultDB = "jdbc:oracle:thin:@localhost:1521:test";

  private Connection	conn = null;

  static public void main(String[] args) {

     if (args.length < 3)

     {

        System.err.println("Wrong number of arguments!!!");

        System.err.println("USAGE: java DBSAXWriter " +

                           "<filename> <user> <password> [dbstring]");

        return;

     } else {

        try {

          String filename = args[0];

          String user     = args[1];

          String password = args[2];

          String dbstring = null;

          if (args.length <= 3) {

            dbstring = defaultDB;

          } else {

            dbstring = args[3];

          }

          new DBSAXWriter(filename, user, password, dbstring);

        } catch (Exception e) {

          System.err.println("EXCEPTION HANDLING REQUIRED");

          System.err.println(e.getMessage());

          e.printStackTrace(System.err);

        }

     }

  }

  private DBSAXWriter( String filename, String user, 

                  String password, String dbstring) 

                  throws IOException, 

                         SQLException, 

                         ClassNotFoundException

   {

     // Open a connection to the database

     conn = openDBConnection(

                "oracle.jdbc.driver.OracleDriver",

                dbstring, user, password);

     //

     // Set up the SAX document handlers for parsing

     //

     try {

        // Use the XMLDocumentHandler interface for namespace support

        // instead of org.xml.sax.DocumentHandler

        XMLDocumentHandler xmlDocHandler = new XMLDocumentHandlerImpl();

        // For all the other interface use the default provided by

        // Handler base

        HandlerBase defHandler = new HandlerBase();

        // Get an instance of the parser

        SAXParser parser = new SAXParser();

        // Set Handlers in the parser

        // Set the DocumentHandler to XMLDocumentHandler

        parser.setDocumentHandler(xmlDocHandler);

        // Set the other Handler to the defHandler

        parser.setErrorHandler(defHandler);

        parser.setEntityResolver(defHandler);

        parser.setDTDHandler(defHandler);

        try

        {

           parser.parse(fileToURL(new File(filename)).toString());

        }

        catch (SAXParseException e)

        {

           System.err.println(filename + ": " + e.getMessage());

        }

        catch (SAXException e)

        {

           System.err.println(filename + ": " + e.getMessage());

        }

     }

     catch (Exception e)

     {

        System.err.println(e.toString());

     }

   }

    private Connection openDBConnection(String dbDriver, String connection,

                String user, String password)

                throws SQLException, ClassNotFoundException {

      // Load the Oracle JDBC driver

      Class.forName (dbDriver);

      // Connect to the database

      Connection conn = 

                 DriverManager.getConnection( connection, user, password);

      return conn;

    }

  static public URL fileToURL(File file) 

   {

    String path = file.getAbsolutePath();

    String fSep = System.getProperty("file.separator");

    if (fSep != null && fSep.length() == 1)

      path = path.replace(fSep.charAt(0), '/');

    if (path.length() > 0 && path.charAt(0) != '/')

      path = '/' + path;

    try {

      return new URL("file", null, path);

    }

    catch (java.net.MalformedURLException e) {

      /* According to the spec this could only happen if the file

	 protocol were not recognized. */

      throw new Error("unexpected MalformedURLException");

    }

  }

}

   /***********************************************************************

     Implementation of XMLDocumentHandler interface. Only the new

     startElement and endElement interfaces are implemented here. All other

     interfaces are implemented in the class HandlerBase.

     **********************************************************************/

class XMLDocumentHandlerImpl extends DefaultXMLDocumentHandler

{

   boolean  debug = false;

   boolean  stackCreated = false;

   private  Stack 	elementStack;

   public void XMLDocumentHandlerImpl()

   {

   }

   public void startElement(NSName name, SAXAttrList atts) throws SAXException 

   {

      // Use the methods getQualifiedName(), getLocalName(), getNamespace()

      // and getExpandedName() in NSName interface to get Namespace

      // information.

      String qName;

      String localName;

      String nsName;

      String expName;

      DBSAXElement currentElement;

      qName = name.getQualifiedName();

      localName = name.getLocalName();

      nsName = name.getNamespace();

      expName = name.getExpandedName();

      // Create the current element representation

      currentElement = new DBSAXElement(1, localName, false, 0);

      System.out.println("Element created:" + currentElement.getTagName());

      // Add all of the attributes

      for (int i=0; i<atts.getLength(); i++)

      {

      // Use the methods getQualifiedName(), getLocalName(), getNamespace()

      // and getExpandedName() in SAXAttrList interface to get Namespace

      // information.

         qName = atts.getQualifiedName(i);

         localName = atts.getLocalName(i);

         nsName = atts.getNamespace(i);

         expName = atts.getExpandedName(i);

         // You can get the type and value of the attributes either

         // by index or by the Qualified Name.

         String type = atts.getType(qName);

         String value = atts.getValue(qName);

         currentElement.setAttribute(localName, value);

         System.out.println(" Added ATTRIBUTE Name:" + localName);

         System.out.println("                 Type:" + type);

         System.out.println("                Value:" + value);

         System.out.println();

      }      

      // Create the stack for keeping track of element context

      // if it doesn't already exist

      if (!stackCreated) {

        elementStack = new Stack();

        stackCreated = true;

      }

      // Add the element to the stack, so that any text data can be 

      // added as it is encountered

      elementStack.push(currentElement);

   }

   public void characters(char[] cbuf, int start, int len)

   {

      DBSAXElement currentElement = (DBSAXElement)elementStack.peek();

      currentElement.appendContent(cbuf,start,len);

      System.out.println("   Characters: " + new String(cbuf,start,len));

      System.out.println("     Appended: " + currentElement.getContent());

   }

   public void ignorableWhitespace(char[] cbuf, int start, int len)

   {

      System.out.println("IgnorableWhiteSpace");

   }

   public void endElement(NSName name) throws SAXException 

   {

      // Use the methods getQualifiedName(), getLocalName(), getNamespace()

      // and getExpandedName() in NSName interface to get Namespace

      // information.

      String expName = name.getExpandedName();

      // Remove the element from the stack

      DBSAXElement currentElement = (DBSAXElement)elementStack.pop();

      System.out.println("Final content: " + currentElement.getContent());

      System.out.println("Closing element: " + expName);

   }

   public void db(int flag) {

     if (debug) {

       System.err.println("DEBUG POSITION " + flag);

     }

   }   

}

/**

 *        Name: DBSAXElement.java

 *     Purpose: A Class that represents an XML element and its contents

 * Institution: National Center for Ecological Analysis and Synthesis

 *   Copyright: 2000

 *     Authors: Matt Jones

 *

 *     Version: '$Id$'

 */

//package project;

import java.sql.*;

import java.io.IOException;

import java.util.Hashtable;

import java.util.Enumeration;

public class DBSAXElement {

    private long		element_id;

    private String		tagname;

    private StringBuffer	content;

    private boolean		isEmpty;

    private long		parent_id;

    private Hashtable		attributes;

    public DBSAXElement (long element_id, String tagname, 

                         boolean isEmpty, long parent_id) {

      this.element_id = element_id;

      this.tagname = tagname;

      this.isEmpty = isEmpty;

      this.parent_id = parent_id;

      content = new StringBuffer();

      attributes = new Hashtable(); 

    };

    // used by JTree to display this node

    public String toString ()

    {

	StringBuffer	value = new StringBuffer ();

	value.append ('<');

	value.append (getTagName ());

	value.append (getAttributes ().toString ());

	value.append ('>');

	return value.toString ();

    }

    /** Get the name of this element */

    public String  getTagName() { return tagname; }

    /** Get the attributes as a string */

    public String getAttributes() {

      StringBuffer buf = new StringBuffer();

      String attName = null;

      String attValue = null;

      Enumeration attList = attributes.keys();

      while (attList.hasMoreElements()) {

        attName = (String)attList.nextElement();

        attValue = (String)attributes.get(attName);

        buf.append(" ").append(attName).append("=").append(attValue);        

      }

      return buf.toString();      

    }

    /** Add a new attribute to this element, or set its value */

    public void setAttribute(String attName, String attValue) {

      if (attName != null) {

        attributes.put(attName, attValue);

      } else {

        System.err.println("Attribute name must not be null!");

      }

    }

    /** Get an attribute value by name */

    public String getAttribute(String attName) {

      return (String)attributes.get(attName);

    }

    /** Append to the content of the element */

    public void appendContent(char[] cbuf, int start, int len) {

      this.content.append( cbuf, start, len );

    }

    /** Append to the content of the element */

    public void appendContent(String new_content) {

      this.content.append( new_content );

    }

    /** Get the content of the element */

    public String getContent() {

      return this.content.toString();

    }

}

/**

 *        Name: DBSAXElement.java

 *     Purpose: A Class that represents an XML element and its contents

 * Institution: National Center for Ecological Analysis and Synthesis

 *   Copyright: 2000

 *     Authors: Matt Jones

 *

 *     Version: '$Id$'

 */

//package project;

import java.sql.*;

import java.io.IOException;

import java.util.Hashtable;

import java.util.Enumeration;

public class DBSAXElement {

    private long		element_id;

    private String		tagname;

    private StringBuffer	content;

    private boolean		isEmpty;

    private long		parent_id;

    private Hashtable		attributes;

    public DBSAXElement (long element_id, String tagname, 

                         boolean isEmpty, long parent_id) {

      this.element_id = element_id;

      this.tagname = tagname;

      this.isEmpty = isEmpty;

      this.parent_id = parent_id;

      content = new StringBuffer();

      attributes = new Hashtable(); 

    };

    // used by JTree to display this node

    public String toString ()

    {

	StringBuffer	value = new StringBuffer ();

	value.append ('<');

	value.append (getTagName ());

	value.append (getAttributes ().toString ());

	value.append ('>');

	return value.toString ();

    }

    /** Get the name of this element */

    public String  getTagName() { return tagname; }

    /** Get the attributes as a string */

    public String getAttributes() {

      StringBuffer buf = new StringBuffer();

      String attName = null;

      String attValue = null;

      Enumeration attList = attributes.keys();

      while (attList.hasMoreElements()) {

        attName = (String)attList.nextElement();

        attValue = (String)attributes.get(attName);

        buf.append(" ").append(attName).append("=").append(attValue);        

      }

      return buf.toString();      

    }

    /** Add a new attribute to this element, or set its value */

    public void setAttribute(String attName, String attValue) {

      if (attName != null) {

        attributes.put(attName, attValue);

      } else {

        System.err.println("Attribute name must not be null!");

      }

    }

    /** Get an attribute value by name */

    public String getAttribute(String attName) {

      return (String)attributes.get(attName);

    }

    /** Append to the content of the element */

    public void appendContent(char[] cbuf, int start, int len) {

      this.content.append( cbuf, start, len );

    }

    /** Append to the content of the element */

    public void appendContent(String new_content) {

      this.content.append( new_content );

    }

    /** Get the content of the element */

    public String getContent() {

      return this.content.toString();

    }

}

/**

 *        Name: DBSAXWriter.java

 *     Purpose: A Class that reads in an XML text document and

 *              write its contents to a database connection using SAX

 * Institution: National Center for Ecological Analysis and Synthesis

 *   Copyright: 2000

 *     Authors: Matt Jones

 *

 *     Version: '$Id$'

 */

import org.xml.sax.*;

import java.io.*;

import java.net.URL;

import java.net.MalformedURLException;

import java.sql.*;

import java.util.Stack;

// Extensions to the SAX Interfaces for Namespace support.

import oracle.xml.parser.v2.XMLDocumentHandler;

import oracle.xml.parser.v2.DefaultXMLDocumentHandler;

import oracle.xml.parser.v2.NSName;

import oracle.xml.parser.v2.SAXAttrList;

import oracle.xml.parser.v2.SAXParser;

public class DBSAXWriter {

  static  String 	defaultDB = "jdbc:oracle:thin:@localhost:1521:test";

  private Connection	conn = null;

  static public void main(String[] args) {

     if (args.length < 3)

     {

        System.err.println("Wrong number of arguments!!!");

        System.err.println("USAGE: java DBSAXWriter " +

                           "<filename> <user> <password> [dbstring]");

        return;

     } else {

        try {

          String filename = args[0];

          String user     = args[1];

          String password = args[2];

          String dbstring = null;

          if (args.length <= 3) {

            dbstring = defaultDB;

          } else {

            dbstring = args[3];

          }

          new DBSAXWriter(filename, user, password, dbstring);

        } catch (Exception e) {

          System.err.println("EXCEPTION HANDLING REQUIRED");

          System.err.println(e.getMessage());

          e.printStackTrace(System.err);

        }

     }

  }

  private DBSAXWriter( String filename, String user, 

                  String password, String dbstring) 

                  throws IOException, 

                         SQLException, 

                         ClassNotFoundException

   {

     // Open a connection to the database

     conn = openDBConnection(

                "oracle.jdbc.driver.OracleDriver",

                dbstring, user, password);

     //

     // Set up the SAX document handlers for parsing

     //

     try {

        // Use the XMLDocumentHandler interface for namespace support

        // instead of org.xml.sax.DocumentHandler

        XMLDocumentHandler xmlDocHandler = new XMLDocumentHandlerImpl();

        // For all the other interface use the default provided by

        // Handler base

        HandlerBase defHandler = new HandlerBase();

        // Get an instance of the parser

        SAXParser parser = new SAXParser();

        // Set Handlers in the parser

        // Set the DocumentHandler to XMLDocumentHandler

        parser.setDocumentHandler(xmlDocHandler);

        // Set the other Handler to the defHandler

        parser.setErrorHandler(defHandler);

        parser.setEntityResolver(defHandler);

        parser.setDTDHandler(defHandler);

        try

        {

           parser.parse(fileToURL(new File(filename)).toString());

        }

        catch (SAXParseException e)

        {

           System.err.println(filename + ": " + e.getMessage());

        }

        catch (SAXException e)

        {

           System.err.println(filename + ": " + e.getMessage());

        }

     }

     catch (Exception e)

     {

        System.err.println(e.toString());

     }

   }

    private Connection openDBConnection(String dbDriver, String connection,

                String user, String password)

                throws SQLException, ClassNotFoundException {

      // Load the Oracle JDBC driver

      Class.forName (dbDriver);

      // Connect to the database

      Connection conn = 

                 DriverManager.getConnection( connection, user, password);

      return conn;

    }

  static public URL fileToURL(File file) 

   {

    String path = file.getAbsolutePath();

    String fSep = System.getProperty("file.separator");

    if (fSep != null && fSep.length() == 1)

      path = path.replace(fSep.charAt(0), '/');

    if (path.length() > 0 && path.charAt(0) != '/')

      path = '/' + path;

    try {

      return new URL("file", null, path);

    }

    catch (java.net.MalformedURLException e) {

      /* According to the spec this could only happen if the file

	 protocol were not recognized. */

      throw new Error("unexpected MalformedURLException");

    }

  }

}

   /***********************************************************************

     Implementation of XMLDocumentHandler interface. Only the new

     startElement and endElement interfaces are implemented here. All other

     interfaces are implemented in the class HandlerBase.

     **********************************************************************/

class XMLDocumentHandlerImpl extends DefaultXMLDocumentHandler

{

   boolean  debug = false;

   boolean  stackCreated = false;

   private  Stack 	elementStack;

   public void XMLDocumentHandlerImpl()

   {

   }

   public void startElement(NSName name, SAXAttrList atts) throws SAXException 

   {

      // Use the methods getQualifiedName(), getLocalName(), getNamespace()

      // and getExpandedName() in NSName interface to get Namespace

      // information.

      String qName;

      String localName;

      String nsName;

      String expName;

      DBSAXElement currentElement;

      qName = name.getQualifiedName();

      localName = name.getLocalName();

      nsName = name.getNamespace();

      expName = name.getExpandedName();

      // Create the current element representation

      currentElement = new DBSAXElement(1, localName, false, 0);

      System.out.println("Element created:" + currentElement.getTagName());

      // Add all of the attributes

      for (int i=0; i<atts.getLength(); i++)

      {

      // Use the methods getQualifiedName(), getLocalName(), getNamespace()

      // and getExpandedName() in SAXAttrList interface to get Namespace

      // information.

         qName = atts.getQualifiedName(i);

         localName = atts.getLocalName(i);

         nsName = atts.getNamespace(i);

         expName = atts.getExpandedName(i);

         // You can get the type and value of the attributes either

         // by index or by the Qualified Name.

         String type = atts.getType(qName);

         String value = atts.getValue(qName);

         currentElement.setAttribute(localName, value);

         System.out.println(" Added ATTRIBUTE Name:" + localName);

         System.out.println("                 Type:" + type);

         System.out.println("                Value:" + value);

         System.out.println();

      }      

      // Create the stack for keeping track of element context

      // if it doesn't already exist

      if (!stackCreated) {

        elementStack = new Stack();

        stackCreated = true;

      }

      // Add the element to the stack, so that any text data can be 

      // added as it is encountered

      elementStack.push(currentElement);

   }

   public void characters(char[] cbuf, int start, int len)

   {

      DBSAXElement currentElement = (DBSAXElement)elementStack.peek();

      currentElement.appendContent(cbuf,start,len);

      System.out.println("   Characters: " + new String(cbuf,start,len));

      System.out.println("     Appended: " + currentElement.getContent());

   }

   public void ignorableWhitespace(char[] cbuf, int start, int len)

   {

      System.out.println("IgnorableWhiteSpace");

   }

   public void endElement(NSName name) throws SAXException 

   {

      // Use the methods getQualifiedName(), getLocalName(), getNamespace()

      // and getExpandedName() in NSName interface to get Namespace

      // information.

      String expName = name.getExpandedName();

      // Remove the element from the stack

      DBSAXElement currentElement = (DBSAXElement)elementStack.pop();

      System.out.println("Final content: " + currentElement.getContent());

      System.out.println("Closing element: " + expName);

   }

   public void db(int flag) {

     if (debug) {

       System.err.println("DEBUG POSITION " + flag);

     }

   }   

}

/**

 *        Name: DBSAXElement.java

 *     Purpose: A Class that represents an XML element and its contents

 * Institution: National Center for Ecological Analysis and Synthesis

 *   Copyright: 2000

 *     Authors: Matt Jones

 *

 *     Version: '$Id$'

 */

//package project;

import java.sql.*;

import java.io.IOException;

import java.util.Hashtable;

import java.util.Enumeration;

public class DBSAXElement {

    private long		element_id;

    private String		tagname;

    private StringBuffer	content;

    private boolean		isEmpty;

    private long		parent_id;

    private Hashtable		attributes;

    public DBSAXElement (long element_id, String tagname, 

                         boolean isEmpty, long parent_id) {

      this.element_id = element_id;

      this.tagname = tagname;

      this.isEmpty = isEmpty;

      this.parent_id = parent_id;

      content = new StringBuffer();

      attributes = new Hashtable(); 

    };

    // used by JTree to display this node

    public String toString ()

    {

	StringBuffer	value = new StringBuffer ();

	value.append ('<');

	value.append (getTagName ());

	value.append (getAttributes ().toString ());

	value.append ('>');

	return value.toString ();

    }

    /** Get the name of this element */

    public String  getTagName() { return tagname; }

    /** Get the attributes as a string */

    public String getAttributes() {

      StringBuffer buf = new StringBuffer();

      String attName = null;

      String attValue = null;

      Enumeration attList = attributes.keys();

      while (attList.hasMoreElements()) {

        attName = (String)attList.nextElement();

        attValue = (String)attributes.get(attName);

        buf.append(" ").append(attName).append("=").append(attValue);        

      }

      return buf.toString();      

    }

    /** Add a new attribute to this element, or set its value */

    public void setAttribute(String attName, String attValue) {

      if (attName != null) {

        attributes.put(attName, attValue);

      } else {

        System.err.println("Attribute name must not be null!");

      }

    }

    /** Get an attribute value by name */

    public String getAttribute(String attName) {

      return (String)attributes.get(attName);

    }

    /** Append to the content of the element */

    public void appendContent(char[] cbuf, int start, int len) {

      this.content.append( cbuf, start, len );

    }

    /** Append to the content of the element */

    public void appendContent(String new_content) {

      this.content.append( new_content );

    }

    /** Get the content of the element */

    public String getContent() {

      return this.content.toString();

    }

}

CPATH=/home/httpd/servlets/xsql/lib/xmlparserv2.jar$(SEP)$(ORACLE_HOME)/jdbc/lib/classes111.zip$(SEP).

default: orasax

orasax:

		DBSAXWriter.java \

		DBSAXElement.java

sundom:

	javac -classpath "$(CPATH)" \

test:

	java -cp $(CPATH) DBSAXWriter test.xml jones kinkaj0u

test1:

	java -cp $(CPATH) DBSAXWriter test.xml jones kinkaj0u \

		jdbc:oracle:thin:@24.237.22.245:1521:test

test2:

	java -cp $(CPATH) DBSAXWriter test.xml jones kinkaj0u \

		jdbc:oracle:thin:@localhost:1521:test

/**

 *        Name: DBSAXWriter.java

 *     Purpose: A Class that reads in an XML text document and

 *              write its contents to a database connection using SAX

 * Institution: National Center for Ecological Analysis and Synthesis

 *   Copyright: 2000

 *     Authors: Matt Jones

 *

 *     Version: '$Id$'

 */

import org.xml.sax.*;

import java.io.*;

import java.net.URL;

import java.net.MalformedURLException;

import java.sql.*;

import java.util.Stack;

// Extensions to the SAX Interfaces for Namespace support.

import oracle.xml.parser.v2.XMLDocumentHandler;

import oracle.xml.parser.v2.DefaultXMLDocumentHandler;

import oracle.xml.parser.v2.NSName;

import oracle.xml.parser.v2.SAXAttrList;

import oracle.xml.parser.v2.SAXParser;

public class DBSAXWriter {

  static  String 	defaultDB = "jdbc:oracle:thin:@localhost:1521:test";

  private Connection	conn = null;

  static public void main(String[] args) {

     if (args.length < 3)

     {

        System.err.println("Wrong number of arguments!!!");

        System.err.println("USAGE: java DBSAXWriter " +

                           "<filename> <user> <password> [dbstring]");

        return;

     } else {

        try {

          String filename = args[0];

          String user     = args[1];

          String password = args[2];

          String dbstring = null;

          if (args.length <= 3) {

            dbstring = defaultDB;

          } else {

            dbstring = args[3];

          }

          new DBSAXWriter(filename, user, password, dbstring);

        } catch (Exception e) {

          System.err.println("EXCEPTION HANDLING REQUIRED");

          System.err.println(e.getMessage());

          e.printStackTrace(System.err);

        }

     }

  }

  private DBSAXWriter( String filename, String user, 

                  String password, String dbstring) 

                  throws IOException, 

                         SQLException, 

                         ClassNotFoundException

   {

     // Open a connection to the database

     conn = openDBConnection(

                "oracle.jdbc.driver.OracleDriver",

                dbstring, user, password);

     //

     // Set up the SAX document handlers for parsing

     //

     try {

        // Use the XMLDocumentHandler interface for namespace support

        // instead of org.xml.sax.DocumentHandler

        XMLDocumentHandler xmlDocHandler = new XMLDocumentHandlerImpl();

        // For all the other interface use the default provided by

        // Handler base

        HandlerBase defHandler = new HandlerBase();

        // Get an instance of the parser

        SAXParser parser = new SAXParser();

        // Set Handlers in the parser

        // Set the DocumentHandler to XMLDocumentHandler

        parser.setDocumentHandler(xmlDocHandler);

        // Set the other Handler to the defHandler

        parser.setErrorHandler(defHandler);

        parser.setEntityResolver(defHandler);

        parser.setDTDHandler(defHandler);

        try

        {

           parser.parse(fileToURL(new File(filename)).toString());

        }

        catch (SAXParseException e)

        {

           System.err.println(filename + ": " + e.getMessage());

        }

        catch (SAXException e)

        {

           System.err.println(filename + ": " + e.getMessage());

        }

     }

     catch (Exception e)

     {

        System.err.println(e.toString());

     }

   }

    private Connection openDBConnection(String dbDriver, String connection,

                String user, String password)

                throws SQLException, ClassNotFoundException {

      // Load the Oracle JDBC driver

      Class.forName (dbDriver);

      // Connect to the database

      Connection conn = 

                 DriverManager.getConnection( connection, user, password);

      return conn;

    }

  static public URL fileToURL(File file) 

   {

    String path = file.getAbsolutePath();

    String fSep = System.getProperty("file.separator");

    if (fSep != null && fSep.length() == 1)

      path = path.replace(fSep.charAt(0), '/');

    if (path.length() > 0 && path.charAt(0) != '/')

      path = '/' + path;

    try {

      return new URL("file", null, path);

    }

    catch (java.net.MalformedURLException e) {

      /* According to the spec this could only happen if the file

	 protocol were not recognized. */

      throw new Error("unexpected MalformedURLException");

    }

  }

}

   /***********************************************************************

     Implementation of XMLDocumentHandler interface. Only the new

     startElement and endElement interfaces are implemented here. All other

     interfaces are implemented in the class HandlerBase.

     **********************************************************************/

class XMLDocumentHandlerImpl extends DefaultXMLDocumentHandler

{

   boolean  debug = false;

   boolean  stackCreated = false;

   private  Stack 	elementStack;

   public void XMLDocumentHandlerImpl()

   {

   }

   public void startElement(NSName name, SAXAttrList atts) throws SAXException 

   {

      // Use the methods getQualifiedName(), getLocalName(), getNamespace()

      // and getExpandedName() in NSName interface to get Namespace

      // information.

      String qName;

      String localName;

      String nsName;

      String expName;

      DBSAXElement currentElement;

      qName = name.getQualifiedName();

      localName = name.getLocalName();

      nsName = name.getNamespace();

      expName = name.getExpandedName();

      // Create the current element representation

      currentElement = new DBSAXElement(1, localName, false, 0);

      System.out.println("Element created:" + currentElement.getTagName());

      // Add all of the attributes

      for (int i=0; i<atts.getLength(); i++)

      {

      // Use the methods getQualifiedName(), getLocalName(), getNamespace()

      // and getExpandedName() in SAXAttrList interface to get Namespace

      // information.

         qName = atts.getQualifiedName(i);

         localName = atts.getLocalName(i);

         nsName = atts.getNamespace(i);

         expName = atts.getExpandedName(i);

         // You can get the type and value of the attributes either

         // by index or by the Qualified Name.

         String type = atts.getType(qName);

         String value = atts.getValue(qName);

         currentElement.setAttribute(localName, value);

         System.out.println(" Added ATTRIBUTE Name:" + localName);

         System.out.println("                 Type:" + type);

         System.out.println("                Value:" + value);

         System.out.println();

      }      

      // Create the stack for keeping track of element context

      // if it doesn't already exist

      if (!stackCreated) {

        elementStack = new Stack();

        stackCreated = true;

      }

      // Add the element to the stack, so that any text data can be 

      // added as it is encountered

      elementStack.push(currentElement);

   }

   public void characters(char[] cbuf, int start, int len)

   {

      DBSAXElement currentElement = (DBSAXElement)elementStack.peek();

      currentElement.appendContent(cbuf,start,len);

      System.out.println("   Characters: " + new String(cbuf,start,len));

      System.out.println("     Appended: " + currentElement.getContent());

   }

   public void ignorableWhitespace(char[] cbuf, int start, int len)

   {

      System.out.println("IgnorableWhiteSpace");

   }

   public void endElement(NSName name) throws SAXException 

   {

      // Use the methods getQualifiedName(), getLocalName(), getNamespace()

      // and getExpandedName() in NSName interface to get Namespace

      // information.

      String expName = name.getExpandedName();

      // Remove the element from the stack

      DBSAXElement currentElement = (DBSAXElement)elementStack.pop();

      System.out.println("Final content: " + currentElement.getContent());

      System.out.println("Closing element: " + expName);

   }

   public void db(int flag) {

     if (debug) {

       System.err.println("DEBUG POSITION " + flag);

     }

   }   

}

<?xml version="1.0"?>

<testroot>

  <a testatt="attvalue1">

    <b>Value1</b>

    <c newatt="89766">Value2</c>

  </a>

</testroot>