Metacat

/**

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

 *  Copyright: 2000 Regents of the University of California and the

 *             National Center for Ecological Analysis and Synthesis

 *    Authors: Matt Jones

 *     '$Date$'

 * '$Revision$'

 * This program is free software; you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation; either version 2 of the License, or

 * (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

import java.sql.*;

import java.io.IOException;

import java.util.Hashtable;

import java.util.Enumeration;

 */

   * @param conn the JDBC Connection to which all information is written

   */

  /**

   * Construct a new node instance for ELEMENT nodes

   *

   * @param conn the JDBC Connection to which all information is written

   * @param tagname the name of the node

   * @param parentNode the parent node for this node being created

   */

                    String docid, String doctype)

                                               throws SAXException {

    setDocID(docid);

    //updateNodeIndex(docid, doctype);

  public void writeChildNodeToDB(String nodetype, String nodename,

                                 throws SAXException {

        try

        {

          MetaCatUtil util = new MetaCatUtil();

          conn = util.getConnection();

        }

        catch(Exception e)

        {

          MetaCatUtil.debug("Error while getting db connection in " +

                            "DBSAXNode: " + e.getMessage());

        }

      if (nodetype == "DOCUMENT") {

            "VALUES (?, ?, ?, ?)");

        // Increase DBConnection usage count

        connection.increaseUsageCount(1);

        connection.increaseUsageCount(1);

      if ( nodename != null && (idx = nodename.indexOf(":")) != -1 ) {

        pstmt.setString(2, nodename.substring(idx+1));

        pstmt.setString(3, nodename.substring(0,idx));

      } else {

        pstmt.setString(2, nodename);

        pstmt.setString(3, null);

      }

      pstmt.setString(4, docid);

        //pstmt.setLong(4, nid);

          pstmt.setLong(6, getParentID());

          pstmt.setString(7, data);

          pstmt.setInt(8, getNodeIndex());

          pstmt.setLong(6, getNodeID());

          pstmt.setString(7, data);

          pstmt.setInt(8, incChildNum());

      // Do the insertion

      pstmt.execute();

      pstmt.close();

      // get the generated unique id afterward

                         getUniqueID(connection.getConnections(), "xml_nodes");

      //should incease connection usage!!!!!!

        // Record the root node id that was generated from the database

        setRootNodeID(nid);

      }

        setNodeID(nid);

        setNodeType(nodetype);

      }

                                                     nodename + ", " +

   */

  public void updateRootNodeID(long nodeid) throws SAXException {

      try {

        PreparedStatement pstmt;

              "WHERE nodeid = ?");

        connection.increaseUsageCount(1);

        // Bind the values to the query

        pstmt.setLong(1, nodeid);

        pstmt.setLong(2, nodeid);

        // Do the update

        pstmt.execute();

        pstmt.close();

      } catch (SQLException e) {

        System.out.println("Error in DBSaxNode.updateRootNodeID: " +

                           e.getMessage());

        throw new SAXException(e.getMessage());

      }

  }

  /**

   * into DB connection

   */

        PreparedStatement pstmt;

              "WHERE nodeid = ?");

        connection.increaseUsageCount(1);

        pstmt.setString(1, nodename);

        pstmt.execute();

        pstmt.close();

      } catch (SQLException e) {

                           e.getMessage());

  }

      int serialNumber = -1;

        dbConn=DBConnectionPool.getDBConnection("DBSAXNode.generateNodeID");

        serialNumber=dbConn.getCheckOutSerialNumber();

        stmt = dbConn.createStatement();

        boolean tableHasRows = rs.next();

        if (tableHasRows) {

      } catch (SQLException e) {

                            e.getMessage());

      {

        // Return DBconnection

        DBConnectionPool.returnDBConnection(dbConn, serialNumber);

      }//finally

              throws SAXException {

      // Enter the attribute in the hash table

      super.setAttribute(attName, attValue);

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

  public void setNamespace(String prefix, String uri, String docid)

              throws SAXException {

    if (prefix != null) {

      // Enter the namespace in a hash table

      super.setNamespace(prefix, uri);

      // And enter the namespace in the database

      writeChildNodeToDB("NAMESPACE", prefix, uri, docid);

    } else {

      System.err.println("Namespace prefix must not be null!");

      throw new SAXException("Namespace prefix must not be null!");

    }

  }

   * USED FROM SEPARATE THREAD RUNNED from DBSAXHandler on endDocument()

   * Update the node index (xml_index) for this node by generating

   * test strings that represent all of the relative and absolute

   * paths through the XML tree from document root to this node

   */

  {

    Hashtable pathlist = new Hashtable();

    boolean atStartingNode = true;

    boolean atRootDocumentNode = false;

    DBSAXNode nodePointer = this;

    StringBuffer currentPath = new StringBuffer();

    int counter = 0;

    // Create a Hashtable of all of the paths to reach this node

    // including absolute paths and relative paths

    while (!atRootDocumentNode) {

      if (atStartingNode) {

        currentPath.insert(0, nodePointer.getTagName());

        pathlist.put(currentPath.toString(), new Long(getNodeID()));

        counter++;

        atStartingNode = false;

      } else {

        currentPath.insert(0, "/");

        currentPath.insert(0, nodePointer.getTagName());

        pathlist.put(currentPath.toString(), new Long(getNodeID()));

        counter++;

      }

      // advance to the next parent node

      nodePointer = nodePointer.getParentNode();

      // If we're at the DOCUMENT node (root of DOM tree), add

      // the root "/" to make the absolute path

      if (nodePointer.getNodeType().equals("DOCUMENT")) {

        currentPath.insert(0, "/");

        pathlist.put(currentPath.toString(), new Long(getNodeID()));

        counter++;

        atRootDocumentNode = true;

      }

    }

    try {

      // Create an insert statement to reuse for all of the path insertions

      PreparedStatement pstmt = conn.prepareStatement(

              "INSERT INTO xml_index (nodeid, path, docid, doctype, " +

               "parentnodeid) " +

              "VALUES (?, ?, ?, ?, ?)");

      conn.increaseUsageCount(1);

      pstmt.setString(3, docid);

      pstmt.setString(4, doctype);

      pstmt.setLong(5, getParentID());

      // Step through the hashtable and insert each of the path values

      while (en.hasMoreElements()) {

        String path = (String)en.nextElement();

        Long nodeid = (Long)pathlist.get(path);

        pstmt.setLong(1, nodeid.longValue());

        pstmt.setString(2, path);

      // Close the database statement

      pstmt.close();

    } catch (SQLException sqe) {

  }

  /** get the parent of this node */

  public DBSAXNode getParentNode() {

    return parentNode;

  }