public void addJournalNote(DocumentNote documentNote) throws Exception {

    kLogger.fine("Adding journal note for document: id=" + documentNote.getDocumentId());

    Connection connection = ConnectionPoolManager.getInstance().getConnection();

    PreparedStatement psInsert = connection.prepareStatement(SQL_INSERT_JOURNALNOTE);

    int i = 1;

    psInsert.setString(i++, documentNote.getNoteData());
    psInsert.setString(i++, documentNote.getUserName().toUpperCase());
    psInsert.setInt(i++, documentNote.getDocumentId());
    psInsert.setString(i++, documentNote.getNoteType());

    int recCount = psInsert.executeUpdate();

    psInsert.close();
    connection.commit();
    connection.close();

    if (recCount == 0) {
      kLogger.warning(
          "Unable to add journal note for document: id=" + documentNote.getDocumentId());
      throw new Exception(
          "Unable to add journal note for document: id=" + documentNote.getDocumentId());
    }
  }
  public void updateJournalNote(DocumentNote documentNote) throws Exception {

    kLogger.fine("Updating journal notes id=" + documentNote.getNoteId());

    Connection connection = ConnectionPoolManager.getInstance().getConnection();

    PreparedStatement psUpdate = connection.prepareStatement(SQL_UPDATE_JOURNALNOTE);

    int i = 1;

    psUpdate.setString(i++, documentNote.getNoteData());
    psUpdate.setString(i++, documentNote.getUserName().toUpperCase());
    psUpdate.setString(i++, documentNote.getCreated());
    if (documentNote.isActive()) {
      psUpdate.setString(i++, "Y");
    } else {
      psUpdate.setString(i++, "N");
    }
    psUpdate.setInt(i++, documentNote.getDocumentId());
    psUpdate.setString(i++, documentNote.getNoteType());

    psUpdate.setInt(i++, documentNote.getNoteId());

    int recCount = psUpdate.executeUpdate();

    psUpdate.close();
    connection.commit();
    connection.close();

    if (recCount == 0) {
      kLogger.warning("Unable to update journal notes id=" + documentNote.getNoteId());
      throw new Exception("Unable to update journal notes id=" + documentNote.getNoteId());
    }
  }