Metacat

/**

 *  '$RCSfile$'

 *    Purpose: A Class that implements org.xml.sax.DTDHandler interface

 *             for resolving external entities

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

 *             National Center for Ecological Analysis and Synthesis

 *    Authors: Jivka Bojilova

 *    Release: @release@

 *

 *   '$Author: jones $'

 *     '$Date: 2000-08-14 13:53:34 -0700 (Mon, 14 Aug 2000) $'

 * '$Revision: 349 $'

 */

package edu.ucsb.nceas.metacat;

import org.xml.sax.*;

import java.sql.*;

import java.net.URL;

import java.net.MalformedURLException;

import java.util.Stack;

import java.util.EmptyStackException;

/** 

 * A database aware Class implementing DTDHandler interface for the SAX 

 * parser to call when processing the XML stream and intercepting notations 

 * and unparsed entities

 */

public class DBDTDHandler implements DTDHandler

{

   private Connection	conn = null;

   /** Construct an instance of the DBDTDHandler clas

    *

    * @param conn the JDBC connection to which information is written

    */

   public DBDTDHandler(Connection conn)

   {

      this.conn = conn;

   }

   /** Notation declarations are not signaled */

   public void notationDecl(String name, String publicId, String systemId)

            throws SAXException

   {

    System.out.println("from DBDTDHandler.notationDecl");

    System.out.print(name);

    System.out.print(publicId);

    System.out.print(systemId);

    return;

   }

   /** All are reported after startDocument and before first 

    * startElement event

    */

   public void unparsedEntityDecl(String name, String publicId, 

                                  String systemId, String notationName)

            throws SAXException

   {

    System.out.println("from DBDTDHandler.unparsedEntityDecl");

    System.out.print(name);

    System.out.print(publicId);

    System.out.print(systemId);

    System.out.println(notationName);

    //String doctype = DBEntityResolver.doctype;

    //if ( getEntitySystemID(conn, doctype, publicId) == "" ) 

    //    registerEntityPublicID(conn, doctype, publicId, systemId);

    return;

   }

   /** 

    * Look at db XML Catalog to get System ID (if any) for that Public ID 

    * and doctype.

    * Return empty string if there are not 

    */

/*

   private String getEntitySystemID (Connection conn, String doctype, 

                                     String publicId)

   {

        String system_id = "";

        Statement stmt;

        try {

          stmt = conn.createStatement();

          stmt.execute("SELECT system_id FROM xml_catalog " + 

                       "WHERE entry_type = 'ENTITY' AND source_doctype = '" + 

                        doctype + "' AND public_id = '" + publicId + "'");

          try {

            ResultSet rs = stmt.getResultSet();

            try {

              boolean tableHasRows = rs.next();

              if (tableHasRows) {

                try {

                  system_id = rs.getString(1);

                } catch (SQLException e) {

                  System.out.println("DBDTDHandler.getEntitySystemID() " +

                         "- Error with getString: " + e.getMessage());

                }

              }

            } catch (SQLException e) {

              System.out.println("DBDTDHandler.getEntitySystemID() " +

                         "- Error with next: " + e.getMessage());

            }

          } catch (SQLException e) {

            System.out.println("DBDTDHandler.getEntitySystemID() " +

                         "- Error with getrset: " + e.getMessage());

          }

          stmt.close();

        } catch (SQLException e) {

          System.out.println("DBDTDHandler.getEntitySystemID() " +

                         "- Error getting id: " + e.getMessage());

        }

        // return the selected System ID

        return system_id;

   }

*/

   /** 

    * Register Public ID in db XML Catalog 

    */

/*

   private void registerEntityPublicID (Connection conn, String doctype, 

                                        String publicId, String systemId)

   {

        try {

          PreparedStatement pstmt;

          pstmt = conn.prepareStatement(

                "INSERT INTO xml_catalog (entity_id, entity_name, " +

                "entry_type, source_doctype, public_id, system_id) " +

                "VALUES (null, null, 'ENTITY', ?, ?, ?)");

          // Bind the values to the query

          pstmt.setString(1, doctype);

          pstmt.setString(2, publicId);

          pstmt.setString(3, systemId);

          // Do the insertion

          pstmt.execute();

          pstmt.close();

        } catch (SQLException e) {

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

        }

   }

*/

}

/**

 * '$Log$

 * 'Revision 1.10  2000/06/27 04:31:07  jones

 * 'Fixed bugs associated with the new UPDATE and DELETE functions of

 * 'DBWriter.  There were problematic interactions between some static

 * 'variables used in DBEntityResolver and the way in which the

 * 'Servlet objects are re-used across multiple client invocations.

 * '

 * 'Generally cleaned up error reporting.  Now all errors and success

 * 'results are reported as XML documents from MetaCatServlet.  Need

 * 'to make the command line tools do the same.

 * '

 * 'Revision 1.9  2000/06/26 10:35:04  jones

 * 'Merged in substantial changes to DBWriter and associated classes and to

 * 'the MetaCatServlet in order to accomodate the new UPDATE and DELETE

 * 'functions.  The command line tools and the parameters for the

 * 'servlet have changed substantially.

 * '

 * 'Revision 1.8.2.2  2000/06/25 23:38:16  jones

 * 'Added RCSfile keyword

 * '

 * 'Revision 1.8.2.1  2000/06/25 23:34:17  jones

 * 'Changed documentation formatting, added log entries at bottom of source files

 * ''

 */