Metacat

  /** 

   * Construct a new node instance for DTD nodes

   * This Node will write docname, publicId and systemId into db. Only

   * handle systemid  existed.(external dtd)

   *

   * @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

   */

  public DBSAXNode (DBConnection conn, String docName, String publicId, 

                    String systemId, DBSAXNode parentNode, long rootnodeid, 

                    String docid) throws SAXException 

  {

    super();

    this.connection = conn;

    this.parentNode = parentNode;

    setParentID(parentNode.getNodeID());

    setRootNodeID(rootnodeid);

    setDocID(docid);

    // insert dtd node only for external dtd definiation

    if (systemId != null)

    {

      //write docname to DB

      if (docName != null)

      {

        setNodeIndex(parentNode.incChildNum());

        writeDTDNodeToDB(DocumentImpl.DOCNAME, docName, docid);

      }

      //write publicId to DB

      if (publicId != null)

      {

        setNodeIndex(parentNode.incChildNum());

        writeDTDNodeToDB(DocumentImpl.PUBLICID, publicId, docid);

      }

      //write systemId to DB

      setNodeIndex(parentNode.incChildNum());

      writeDTDNodeToDB(DocumentImpl.SYSTEMID, systemId, docid);

    }

  }

 /** creates SQL code and inserts new node into DB connection */

  public long writeDTDNodeToDB(String nodename, String data, String docid) 

                                 throws SAXException 

  {

    long nid = -1;

    try 

    {

      PreparedStatement pstmt;

      MetaCatUtil.debugMessage("Insert dtd into db: "+nodename +" "+data, 45);

      pstmt = connection.prepareStatement(

            "INSERT INTO xml_nodes " +

            "(nodetype, nodename, docid, " +

            "rootnodeid, parentnodeid, nodedata, nodeindex) " +

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

       // Increase DBConnection usage count

      connection.increaseUsageCount(1);

      // Bind the values to the query

      pstmt.setString(1, DocumentImpl.DTD);

      pstmt.setString(2, nodename);

      pstmt.setString(3, docid);

      pstmt.setLong(4, getRootNodeID());

      pstmt.setLong(5, getParentID());

      pstmt.setString(6, data);

      pstmt.setInt(7, getNodeIndex());

      // Do the insertion

      pstmt.execute();

      pstmt.close();

      // get the generated unique id afterward

      nid = dbAdapter.getUniqueID(connection.getConnections(), "xml_nodes");

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

    } catch (SQLException e) {

      System.out.println("Error in DBSaxNode.writeDTDNodeToDB");

      System.err.println("Error inserting node: (" + DocumentImpl.DTD + ", " +

                                                     nodename + ", " + 

                                                     data + ")" );

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

      e.printStackTrace(System.err);

      throw new SAXException(e.getMessage());

    }

    return nid;

  }