/ - Diff - Metacat - Ecoinformatics Redmine

     import java.util.Hashtable;
     import java.util.Enumeration;
     import edu.ucsb.nceas.dbadapter.DBAdapter;
     /**
      * A suite of utility classes for the metadata catalog server
      */
     public class MetaCatUtil {
       private PropertyResourceBundle options = null;
       private String propertiesFile = "edu.ucsb.nceas.metacat.metacat";
       private Hashtable connectionPool = new Hashtable();
       public static DBAdapter dbAdapter;
       private static PropertyResourceBundle options = null;
       private static String propertiesFile = "edu.ucsb.nceas.metacat.metacat";
       private static boolean debug = false;
       private Hashtable connectionPool = new Hashtable();
       /**
        * Determine our db adapter class and create an instance of that class
        */
       static {
         try {
           dbAdapter = (DBAdapter)createObject(getOption("dbAdapter"));
         } catch (Exception e) {
           System.err.println("Error in MetaCatUtil static block:" + e.getMessage());
+        }
+      }
     // CONSTRUCTORS NOT NEEDED
     //  /**
     //   * Construct an instance of the utility class
     //   */
     //  public MetaCatUtil() {
     //
     //    options = (PropertyResourceBundle)
     //          PropertyResourceBundle.getBundle(propertiesFile);
     //  }
     //
     //  /**
     //   * This constructor allows the usage of a different properties file
     //   * @param propFile the properties file that you wish to use.
     //   */
     //  public MetaCatUtil(String propFile)  {
     //
     //    propertiesFile = propFile;
     //  }
       /**
        * Construct an instance of the utility class
        * Instantiate a class using the name of the class at runtime
+       *
        * @param className the fully qualified name of the class to instantiate
        */
       public MetaCatUtil() {
         options = (PropertyResourceBundle)
       public static Object createObject(String className) throws Exception {
         Object object = null;
         try {
           Class classDefinition = Class.forName(className);
           object = classDefinition.newInstance();
         } catch (InstantiationException e) {
           throw e;
         } catch (IllegalAccessException e) {
           throw e;
         } catch (ClassNotFoundException e) {
           throw e;
+        }
         return object;
+      }
       /**
        * Utility method to get an option value from the properties file
+       *
        * @param optionName the name of the option requested
        */
       public static String getOption(String optionName) {
           // Get the configuration file information
           if (options == null) {
             options = (PropertyResourceBundle)
               PropertyResourceBundle.getBundle(propertiesFile);
+          }
           String value = (String)options.handleGetObject(optionName);
           return value;
+      }
       /**
        * This constructor allows the usage of a different properties file
        * @param propFile the properties file that you wish to use.
       /**
        * Utility method to get an option value from a properties file
+       *
        * @param optionName the name of the option requested
        * @param propFile the name of the file where to get the properties from
        */
       public MetaCatUtil(String propFile)
+      {
         propertiesFile = propFile;
       public String getOption(String optionName, String propFile) {
         // Get the configuration file information
         PropertyResourceBundle options = (PropertyResourceBundle)
                                          PropertyResourceBundle.getBundle(propFile);
         String value = (String)options.handleGetObject(optionName);
         return value;
+      }
       /**
-...
          return conn;
+      }
       /**
        * Utility method to get an option value from the properties file
+       *
        * @param option_name the name of the option requested
        */
       public String getOption(String option_name) {
           // Get the configuration file information
           if (options == null) {
             options = (PropertyResourceBundle)
               PropertyResourceBundle.getBundle(propertiesFile);
+          }
           String value = (String)options.handleGetObject(option_name);
           return value;
+      }
       /* Utility method to create and return a pool of Connection objects */
       public Hashtable getConnectionPool()
                     throws SQLException, ClassNotFoundException {

     import java.net.URL;
     import edu.ucsb.nceas.dbadapter.DBAdapter;
     /**
      * A class that represents an XML document. It can be created with a simple
      * document identifier from a database connection.  It also will write an
-...
       static final int ALL = 1;
       static final int WRITE = 2;
       static final int READ = 4;
       private static final DBAdapter dbAdapter = MetaCatUtil.dbAdapter;
       private Connection conn = null;
       private String docid = null;
-...
       private void writeDocumentToDB(String action, String user, String pub,
                                      String catalogid, int serverCode)
                    throws SQLException, Exception {
         String sysdate = dbAdapter.getDateString();
         try {
           PreparedStatement pstmt = null;
-...
                     "(docid, rootnodeid, docname, doctype, " +
                     "user_owner, user_updated, date_created, date_updated, " +
                     "public_access, catalog_id, server_location) " +
                     "VALUES (?, ?, ?, ?, ?, ?, sysdate, sysdate, ?, ?, ?)");
                     "VALUES (?, ?, ?, ?, ?, ?, " + sysdate + ", " + sysdate +
                     ", ?, ?, ?)");
             //note that the server_location is set to 1.
             //this means that "localhost" in the xml_replication table must
             //always be the first entry!!!!!
-...
             pstmt = conn.prepareStatement(
                 "UPDATE xml_documents " +
                 "SET rootnodeid = ?, docname = ?, doctype = ?, " +
                 "user_updated = ?, date_updated = sysdate, " +
                 "user_updated = ?, date_updated = " + sysdate + ", " +
                 "server_location = ?, rev = ?, public_access = ?, catalog_id = ? " +
                 "WHERE docid LIKE ?");
             // Bind the values to the query
-...
       private static void archiveDocRevision(Connection conn, String docid,
                                              String user)
                                              throws SQLException {
         String sysdate = dbAdapter.getDateString();
         // create a record in xml_revisions table
         // for that document as selected from xml_documents
         PreparedStatement pstmt = conn.prepareStatement(
-...
             "user_owner, user_updated, date_created, date_updated, " +
             "server_location, rev, public_access, catalog_id) " +
           "SELECT null, ?, rootnodeid, docname, doctype, " +
             "user_owner, ?, sysdate, sysdate, server_location, rev, " +
             "public_access, catalog_id " +
             "user_owner, ?, " + sysdate + ", " + sysdate + ", "+
             "server_location, rev, public_access, catalog_id " +
           "FROM xml_documents " +
           "WHERE docid = ?");
         // Bind the values to the query and execute it
-...
         } catch (McdbException me) {
           me.toXml(new PrintWriter(System.err));
         } catch (AccessionNumberException ane) {
           System.out.println("ERROR: Couldn't delete document!!! ");
           System.out.println(ane.getMessage());
         } catch (Exception e) {
           System.err.println("EXCEPTION HANDLING REQUIRED");

     import oracle.jdbc.driver.*;
     import org.xml.sax.SAXException;
     import edu.ucsb.nceas.dbadapter.DBAdapter;
     /**
      * A Class that represents an XML node and its contents and
      * can write its own representation to a database connection
-...
       private Connection	conn;
       private DBSAXNode	parentNode;
       private static final DBAdapter dbAdapter = MetaCatUtil.dbAdapter;
       /**
        * Construct a new node instance for DOCUMENT nodes
-...
        * @param conn the JDBC Connection to which all information is written
        */
       public DBSAXNode (Connection conn, String docid) throws SAXException {
         super();
         this.conn = conn;
         this.parentNode = null;
-...
                         throws SAXException {
         super(tagname);
         this.conn = conn;
         this.parentNode = parentNode;
         setParentID(parentNode.getNodeID());
         setRootNodeID(rootnodeid);
         setDocID(docid);
         setNodeIndex(parentNode.incChildNum());
         this.conn = conn;
         this.parentNode = parentNode;
         writeChildNodeToDB("ELEMENT", getTagName(), null, docid);
         //No writing XML Index from here. New Thread used instead.
         //updateNodeIndex(docid, doctype);
-...
+          }
           // Bind the values to the query
           long nid = generateNodeID();
           // NOT USED; USED DBAdapter.getUniqueID() instead
           //long nid = generateNodeID();
           long nid = dbAdapter.getUniqueID(conn, "xml_nodes");
           pstmt.setLong(1, nid);
           pstmt.setString(2, nodetype);
           pstmt.setString(3, nodename);

     import java.net.*;
     import java.sql.*;
     import edu.ucsb.nceas.dbadapter.DBAdapter;
     /**
      * (on insert of XML document)
      * Generates a unique Accession Number or if provided check it
-...
      */
     public class AccessionNumber  {
       private static final DBAdapter dbAdapter = MetaCatUtil.dbAdapter;
       private Connection conn = null;
       private String sitecode = null;
       private String sep = null;
-...
             // get a new docid
             if ( docid == null ) {
               String sitecode = getSitecode();
               String uniqueid = getUniqueID();
               // NOT USED; USED DBAdapter.getUniqueID() instead
               //String uniqueid = getUniqueID();
               String uniqueid = "" + dbAdapter.getUniqueID(conn,"xml_documents");
               return sitecode + sep + uniqueid;

Project

General

Profile

Metacat

Revision 747

Added by bojilova over 23 years ago