Metacat

import java.io.File;

import java.sql.Statement;

import org.apache.log4j.Logger;

import edu.ucsb.nceas.utilities.Options;

	private Logger logMetacat = Logger.getLogger(EML201DocumentCorrector.class);

      *  in both xml_nodes and xml_index table. Since xml_index has a foreign key (nodeid)which

      *  references nodeid in xml_nodes table, we should delete records in xml_index table first.

    	 DBConnection dbconn = null;

    	 int serialNumber = 0;

    	   try

    	      {

    	           //checkout the dbconnection

    	          dbconn = DBConnectionPool.getDBConnection("DBQuery.findDocuments");

    	          serialNumber = dbconn.getCheckOutSerialNumber();

    	          Statement deletingStatement = dbconn.createStatement();

    	          // delete the records in xml_index table 

    	          String deletingIndex = generateXML_IndexDeletingSQL();

    	          deletingStatement.execute(deletingIndex);

    	          // delete the records in xml_nodes table

    	          String deletingNode = generateXML_NodeDeletingSQL();

    	          deletingStatement.execute(deletingNode);

    	          //close statement and connection

    	          deletingStatement.close();

    	          dbconn.close();

    	      }

    	        catch (Exception ee)

    	        {

    	          logMetacat.error("Exception in DBQuery.findDocuments: "

    	                                   + ee.getMessage());

    	          ee.printStackTrace();

    	        }

    	        finally

    	        {

    	          DBConnectionPool.returnDBConnection(dbconn, serialNumber);

    	        } //finally

      * Generate the sql command to delete the records in xml_node table.

      * Since it is leaf node, so we can just delete it without any other side-effect.

    	 String sql ="delete from xml_nodes where nodetype='ATTRIBUTE' and nodename='system' and nodedata='document' "+

    	                     "(select docid from xml_documents where doctype ='eml://ecoinformatics.org/eml-2.0.1')";

    	 "(select docid from xml_documents where doctype ='eml://ecoinformatics.org/eml-2.0.1')";

     /**

      *  Runs the job to correct eml201 documents - deleting extral nodes in

      * @param argus

      * @throws Exception

      */

     public static void main(String[] argus) throws Exception

     {

    	 //initialize options and connection pool

    	 Options.initialize(new File("build/metacat.properties"));

    	 DBConnectionPool connPool = DBConnectionPool.getInstance();

    	 // run the thread

    	 EML201DocumentCorrector correct = new EML201DocumentCorrector();

    	 Thread thread = new Thread(correct);

    	 thread.start();

     }