Metacat

import java.sql.Connection;

import java.sql.SQLException;

import java.sql.Statement;

 * to harvest a particular EML document.

  private Harvester harvester;              // The parent Harvester object

  private int harvestLogID;

  private HarvestDocument harvestDocument;  // The associated HarvestDocument

   * Creates a new instance of HarvestDetailLog and inserts the data into

   * the HARVEST_DETAIL_LOG table.

   *

   * @param  harvester       the Harvester parent object

   * @param  harvestLogID    foreign key value matching the HARVEST_LOG table

   * @param  harvestDocument HarvestDocument object that generated an error

   * @param  errorMessage    text of the error message

  public HarvestDetailLog(Harvester       harvester,

                          int             harvestLogID,

                          HarvestDocument harvestDocument,

                          String          errorMessage

                         ) {

    this.harvester = harvester;

    this.detailLogID = harvester.getDetailLogID();  // Primary key for record

    this.harvestLogID = harvestLogID;

    this.harvestDocument = harvestDocument;

    this.errorMessage = errorMessage;

   * contents of this HarvestDetailLog object.

  void dbInsertHarvestDetailLogEntry() {

    String insertString;

		Statement stmt;

    // Set the value of the HARVEST_LOG_ID to the current time in UTC seconds

    insertString = "INSERT INTO HARVEST_DETAIL_LOG " +

                   "(DETAIL_LOG_ID, HARVEST_LOG_ID, SCOPE," + 

                   " IDENTIFIER, REVISION," +

                   " DOCUMENT_URL, ERROR_MESSAGE, DOCUMENT_TYPE) " +

                   "values(" +

                   detailLogID + ", " +

                   harvestLogID + ", " +

                   "'" + harvestDocument.scope + "', " +

                   harvestDocument.identifier + ", " +

                   harvestDocument.revision + ", " +

                   "'" + harvestDocument.documentURL + "', " +

                   "'" + errorMessage + "'," +

                   "'" + harvestDocument.documentType + "'" +

                   ")";

		try {

			stmt = harvester.conn.createStatement();						

			stmt.executeUpdate(insertString);

			stmt.close();

		}

    catch(SQLException e) {

			System.out.println("SQLException: " + e.getMessage());

		}

  /**

   * Prints the contents of this HarvestLog object. Used in generating reports.

   */

  void printOutput() {

    System.out.println("detailLogID:          " + detailLogID);

    System.out.println("errorMessage:         " + errorMessage);

    harvestDocument.printOutput();

  }