Metacat

/**

 *  '$RCSfile$'

 *    Purpose: A Class that manages database access of xml access  

 *             information.

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

 *             National Center for Ecological Analysis and Synthesis

 *    Authors: Michael Daigle

 * 

 *   '$Author: daigle $'

 *     '$Date: 2009-03-23 13:56:56 -0800 (Mon, 23 Mar 2009) $'

 * '$Revision: 4854 $'

 *

 * This program is free software; you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation; either version 2 of the License, or

 * (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

 */

package edu.ucsb.nceas.metacat.accesscontrol;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.List;

import java.util.Vector;

import org.apache.log4j.Logger;

import edu.ucsb.nceas.metacat.AccessionNumber;

import edu.ucsb.nceas.metacat.AccessionNumberException;

import edu.ucsb.nceas.metacat.DBUtil;

import edu.ucsb.nceas.metacat.IdentifierManager;

import edu.ucsb.nceas.metacat.McdbDocNotFoundException;

import edu.ucsb.nceas.metacat.database.DBConnection;

import edu.ucsb.nceas.metacat.database.DBConnectionPool;

import edu.ucsb.nceas.metacat.shared.AccessException;

import edu.ucsb.nceas.metacat.shared.BaseAccess;

public class XMLAccessAccess extends BaseAccess {

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

	private static String DOCID = "docid";

	private static String GUID = "guid";

	private String idAttribute = DOCID;

	// Constructor

	public XMLAccessAccess() throws AccessException {}

	public XMLAccessAccess(boolean useGuid) {

		if (useGuid) {

			idAttribute = GUID;

		}

	}

	/**

	 * Get all xml access for a document

	 * 

	 * @param id

	 *            the id of the document

	 * @return an xml access DAO list

	 */ 

	public Vector<XMLAccessDAO> getXMLAccessForDoc(String id) throws AccessException {

		Vector<XMLAccessDAO> xmlAccessList = new Vector<XMLAccessDAO>();

		if (id == null) {

			throw new AccessException("XMLAccessAccess.getXMLAccessForDoc - doc id " + 

					"must be specified when selecting xml_access record");

		}

		// first get the xml access from the db and put it into a DAO list

		PreparedStatement pstmt = null;

		DBConnection conn = null;

		int serialNumber = -1;

		try {			

			conn = DBConnectionPool.getDBConnection("XMLAccessAccess.getXMLAccessForDoc");

    		serialNumber = conn.getCheckOutSerialNumber();

			String sql = "SELECT * FROM xml_access WHERE " + idAttribute + " = ?";

			pstmt = conn.prepareStatement(sql);

			pstmt.setString(1, id);

			String sqlReport = "XMLAccessAccess.getXMLAccessForDoc - SQL: " + sql;

			sqlReport += " [" + id + "]";

			logMetacat.info(sqlReport);

			pstmt.execute();

			ResultSet resultSet = pstmt.getResultSet();

			while (resultSet.next()) {

				XMLAccessDAO xmlAccessDAO = populateDAO(resultSet);

				xmlAccessList.add(xmlAccessDAO);

			}

			// make sure permission orders do not conflict in the database

			validateDocXMLAccessList(xmlAccessList);

			return xmlAccessList;

		} catch (SQLException sqle) {

			throw new AccessException("XMLAccessAccess.getXMLAccessForDoc - SQL error when getting access " + 

					" for id: " + id  + " : "  + sqle.getMessage());

		} catch (PermOrderException poe) {

			String errorStr = "XMLAccessAccess.getXMLAccessForDoc - Permission order error when getting " + 

				"access record for doc id: " + id + " : "  + poe.getMessage();

			logMetacat.error(errorStr);

			throw new AccessException(errorStr);

		} finally {

			closeDBObjects(pstmt, conn, serialNumber, logMetacat);

		}		

	}

	/**

	 * Get all xml access for a principal for a certain document

	 * 

	 * @param id

	 *            the id of the document

	 * @param principalName

	 *            the credentials of the principal in the database

	 * @return an xml access DAO list

	 */ 

	public Vector<XMLAccessDAO> getXMLAccessForPrincipal(String id, String principalName) 

			throws AccessException {

		Vector<XMLAccessDAO> xmlAccessList = new Vector<XMLAccessDAO>();

		if (id == null) { 

			throw new AccessException("XMLAccessAccess.getXMLAccessForPrincipal - doc id " + 

					"must be specified when selecting xml_access record");

		}

		if (principalName == null) { 

			throw new AccessException("XMLAccessAccess.getXMLAccessForPrincipal - doc id " + 

					"must be specified when selecting xml_access record");

		}

		// first get the xml access for this principal from the db and put it into a DAO list

		PreparedStatement pstmt = null;

		DBConnection conn = null;

		int serialNumber = -1;

		try {

			conn = DBConnectionPool.getDBConnection("XMLAccessAccess.getXMLAccessForPrincipal");

    		serialNumber = conn.getCheckOutSerialNumber();

			String sql = "SELECT * FROM xml_access WHERE " + idAttribute + " = ? AND principal_name = ?";

			pstmt = conn.prepareStatement(sql);

			pstmt.setString(1, id);

			pstmt.setString(2, principalName);

			String sqlReport = "XMLAccessAccess.getXMLAccessForPrincipal - SQL: " + sql;

			sqlReport += " [" + id + "," + principalName + "]";

			logMetacat.info(sqlReport);

			pstmt.execute();

			ResultSet resultSet = pstmt.getResultSet();

			while (resultSet.next()) {

				XMLAccessDAO xmlAccessDAO = populateDAO(resultSet);

				xmlAccessList.add(xmlAccessDAO);

			}

			// make sure permission orders do not conflict in the database

			validatePrincipalXMLAccessList(xmlAccessList);

			return xmlAccessList;

		} catch (SQLException sqle) {

			throw new AccessException("XMLAccessAccess.getXMLAccessForPrincipal - SQL error when getting access " + 

					" for id: " + id + ", principal: " + principalName  + " : "  + sqle.getMessage());

		} catch (PermOrderException poe) {

			String errorStr = "XMLAccessAccess.getXMLAccessForPrincipal - Permission order error when getting " + 

				"access record for id: " + id + ", principal: " + principalName + " : "  + poe.getMessage();

			logMetacat.error(errorStr);

			throw new AccessException(errorStr);

		} finally {

			closeDBObjects(pstmt, conn, serialNumber, logMetacat); 

		}		

	}

	/**

	 * Get all xml access for a principal/permType/permOrder for a certain document

	 * 

	 * @param id

	 *            the id of the document

	 * @param principalName

	 *            the credentials of the principal in the database

	 * @return an xml access DAO list

	 */ 

	public Vector<XMLAccessDAO> getXMLAccessForPrincipal(String id, String principalName, String permType, String permOrder) 

			throws AccessException {

		Vector<XMLAccessDAO> xmlAccessList = new Vector<XMLAccessDAO>();

		if (id == null) { 

			throw new AccessException("XMLAccessAccess.getXMLAccessForPrincipal - doc id " + 

					"must be specified when selecting xml_access record");

		}

		if (principalName == null) { 

			throw new AccessException("XMLAccessAccess.getXMLAccessForPrincipal - doc id " + 

					"must be specified when selecting xml_access record");

		}

		if (permType == null) { 

			throw new AccessException("XMLAccessAccess.getXMLAccessForPrincipal - permission type " + 

					"must be specified when selecting xml_access record");

		}

		if (permOrder == null) { 

			throw new AccessException("XMLAccessAccess.getXMLAccessForPrincipal - permission order " + 

					"must be specified when selecting xml_access record");

		}

		// first get the xml access for this principal from the db and put it into a DAO list

		PreparedStatement pstmt = null;

		DBConnection conn = null;

		int serialNumber = -1;

		try {

			conn = DBConnectionPool.getDBConnection("XMLAccessAccess.getXMLAccessForPrincipal");

    		serialNumber = conn.getCheckOutSerialNumber();

			String sql = "SELECT * FROM xml_access WHERE " + idAttribute + " = ? AND principal_name = ? " + 

				"AND perm_type = ? AND perm_order = ?";

			pstmt = conn.prepareStatement(sql);

			pstmt.setString(1, id);

			pstmt.setString(2, principalName);

			pstmt.setString(3, permType);			

			pstmt.setString(4, permOrder);

			String sqlReport = "XMLAccessAccess.getXMLAccessForPrincipal - SQL: " + sql;

			sqlReport += " [" + id + "," + principalName + "," +  permType + "," + permOrder + "]";

			logMetacat.info(sqlReport);

			pstmt.execute();

			ResultSet resultSet = pstmt.getResultSet();

			while (resultSet.next()) {

				XMLAccessDAO xmlAccessDAO = populateDAO(resultSet);

				xmlAccessList.add(xmlAccessDAO);

			}

			validatePrincipalXMLAccessList(xmlAccessList);

			return xmlAccessList;

		} catch (SQLException sqle) {

			throw new AccessException("XMLAccessAccess.getXMLAccessForPrincipal - SQL error when getting access " + 

					" for id: " + id + ", principal: " + principalName  + " : "  + sqle.getMessage());

		} catch (PermOrderException poe) {

			String errorStr = "XMLAccessAccess.getXMLAccessForPrincipal - Permission order error when getting " + 

				"access record for id: " + id + ", principal: " + principalName + " : "  + poe.getMessage();

			logMetacat.error(errorStr);

			throw new AccessException(errorStr);

		} finally {

			closeDBObjects(pstmt, conn, serialNumber, logMetacat); 

		}		

	}

	/**

	 * Add permissions for a given principal on a given document. If the

	 * principal already exists, bitwise OR the permission to the existing

	 * permission and update.

	 * 

	 * @param id

	 *            document id

	 * @param principalName

	 *            principal credentials

	 * @param permission

	 *            permission bitmap

	 * @param permType

	 *            permission type

	 * @param permOrder

	 *            permission order

	 */

	public void addXMLAccess(String id, String principalName, Long permission, String permType, 

			String permOrder, String accessFileId, String subTreeId) throws AccessException, PermOrderException {

		permOrderConflict(id, permOrder);

		Vector<XMLAccessDAO> xmlAccessList = 

			getXMLAccessForPrincipal(id, principalName, permType, permOrder);

		// if more than one record exists for this principal on this document with the same

		// access type / access order combination, call cleanup to combine common access and then

		// re-retrieve the access list.

		if (xmlAccessList.size() == 0) {

			insertXMLAccess(id, principalName, permission, permType, permOrder, accessFileId, subTreeId);

			return;

		}

		if (xmlAccessList.size() > 1) {

			cleanupXMLAccessForPrincipal(xmlAccessList);

			xmlAccessList = getXMLAccessForPrincipal(id, principalName, permType, permOrder);

		}

		if (xmlAccessList.size() == 0) {

			throw new AccessException("XMLAccessAccess.addXMLAccess - xml access list is empty when " + 

				"it shouldn't be for id: " + id + ", prinicpal name: " + principalName + ", perm type " + 

				permType + ", perm order: " + permOrder);	

		}

		XMLAccessDAO xmlAccessDAO = xmlAccessList.get(0);

		// if the permission on the xml access dao does not already contain the permission we are 

		//trying to add, update the access record with the existing permission bitwis OR-ed with our

		// new permission

		if ((xmlAccessDAO.getPermission() & permission) != permission) {		

			updateXMLAccessPermission(id, principalName, xmlAccessDAO.getPermission() | permission);

		}

	}

	/**

	 * Set permissions for a given document. This means first removing all access control for the

	 * document and then adding the given rules.

	 * 

	 * @param id

	 *            document id

	 * @param xmlAccessList

	 *            list of xml access dao objects that hold new access for the document

	 */

	public void replaceAccess(String id, List<XMLAccessDAO> xmlAccessList) throws AccessException {

		deleteXMLAccessForDoc(id);

		// if more than one record exists for this principal on this document with the same

		// access type / access order combination, call cleanup to combine common access and then

		// re-retrieve the access list.

		for(XMLAccessDAO xmlAccessDAO : xmlAccessList) {

			insertXMLAccess(id, xmlAccessDAO.getPrincipalName(), xmlAccessDAO.getPermission(), 

					xmlAccessDAO.getPermType(), xmlAccessDAO.getPermOrder(), xmlAccessDAO.getAccessFileId(), xmlAccessDAO.getSubTreeId());

		}

	}

	/**

	 * Insert an xml access record.  It is assumed that the checks have already been made to 

	 * make sure the principal does not already have an access record for this document.  If 

	 * one does already exist, that record should be updated and this insert not called.

	 * 

	 * @param id

	 *            document id

	 * @param principal

	 *            principal credentials

	 * @param permission

	 *            permission bitmap

	 * @param permType

	 *            permission type

	 * @param permOrder

	 *            permission order

	 */

	private void insertXMLAccess(String id, String principalName, Long permission, String permType,

			String permOrder, String accessFileId, String subTreeId) throws AccessException {

	    //System.out.println("permission in insertXMLAccess: " + permission);

	    try

	    {

	        if(permission == -1)

	        {

	            throw new Exception("Permission is -1 in XMLAccessAccess.insertXMLAccess().");

	        }

	    }

	    catch(Exception e)

	    {

	        e.printStackTrace();

	        logMetacat.warn(e.getMessage());

	    }

		if (id == null) {

			throw new AccessException("XMLAccessAccess.insertXMLAccess - id is required when " + 

					"inserting XML access record");

		}

		if (principalName == null) {

			throw new AccessException("XMLAccessAccess.insertXMLAccess - principal is required when " + 

					"inserting XML access record");

		}

		if (permission == null) {

			throw new AccessException("XMLAccessAccess.insertXMLAccess - permission is required when " + 

					"inserting XML access record");

		}

		if (permType == null) {

			throw new AccessException("XMLAccessAccess.insertXMLAccess - permType is required when " + 

					"inserting XML access record");

		}

		if (permOrder == null) {

			permOrder = AccessControlInterface.ALLOWFIRST;

		}

	    PreparedStatement pstmt = null;

		DBConnection conn = null;

		int serialNumber = -1;

		try {

			// check out DBConnection

			conn = DBConnectionPool.getDBConnection("XMLAccessAccess.insertXMLAccess");

			serialNumber = conn.getCheckOutSerialNumber();

			String sql = "INSERT INTO xml_access " +

				"(docid, guid, principal_name, permission, perm_type, perm_order, accessfileid, subtreeid ) " + 

				"VALUES (?,?,?,?,?,?,?,?)";

			pstmt = conn.prepareStatement(sql);

			String guid = null;

			String docid = null;

			if (idAttribute.equals(GUID)) {

				guid = id;

				try {

					String localId = IdentifierManager.getInstance().getLocalId(id);

					// Parse the localId into scope and rev parts, strip off the rev

		            AccessionNumber acc = new AccessionNumber(localId, "NOACTION");

		            docid = acc.getDocid();

				} catch (McdbDocNotFoundException e) {

					//ignore

					logMetacat.warn("No local id mapping found for guid: " + id);

				} catch (NumberFormatException e) {

                    logMetacat.warn("LocalId could not be parsed for guid: " + id);

                } catch (AccessionNumberException e) {

                    logMetacat.warn("LocalId could not be parsed for guid: " + id);

                }

			} else {

				int rev = DBUtil.getLatestRevisionInDocumentTable(id);

				try {

					guid = IdentifierManager.getInstance().getGUID(id, rev);

				} catch (McdbDocNotFoundException e) {

					//ignore

					logMetacat.warn("No guid mapping found for docid: " + id + "." + rev);

				}

				docid = id;

			}

			// Bind the values to the query

			pstmt.setString(1, docid);

			pstmt.setString(2, guid);

			pstmt.setString(3, principalName);

			pstmt.setLong(4, permission);

			pstmt.setString(5, permType);

			pstmt.setString(6, permOrder);

			pstmt.setString(7, accessFileId);

			pstmt.setString(8, subTreeId);

			String sqlReport = "XMLAccessAccess.insertXMLAccess - SQL: " + sql;

			sqlReport += " [" + docid + "," + guid + "," + principalName + "," +  permission + "," +  permType + "," + permOrder + "]";

			logMetacat.info(sqlReport);

			pstmt.execute();

		} catch (SQLException sqle) {

			throw new AccessException("XMLAccessAccess.insertXMLAccess - SQL error when inserting"

					+ "xml access permissions for id: " + id + ", principal: " + 

					principalName + ":" + sqle.getMessage());

		} finally {

			closeDBObjects(pstmt, conn, serialNumber, logMetacat); 

		}   

	}

	/**

	 * Update existing xml access permissions in the db.  The permission value should be the combined

	 * value of pre-existing permissions plus new permissions.

	 * 

	 * @param id

	 *            document id

	 * @param principalName

	 *            principal credentials

	 * @param permission

	 *            permission bitmap

	 */

	private void updateXMLAccessPermission(String id, String principalName, Long permission)

			throws AccessException {

		if (id == null) {

			throw new AccessException("XMLAccessAccess.updateXMLAccessPermission - id is required when " + 

					"updating XML access record");

		}

		if (principalName == null) {

			throw new AccessException("XMLAccessAccess.updateXMLAccessPermission - principal is required when " + 

					"updating XML access record");

		}

		if (permission == null) {

			throw new AccessException("XMLAccessAccess.updateXMLAccessPermission - permission is required when " + 

					"updating XML access record");

		}

	    PreparedStatement pstmt = null;

		DBConnection conn = null;

		int serialNumber = -1;

		try {

			// check out DBConnection

			conn = DBConnectionPool.getDBConnection("XMLAccessAccess.updateXMLAccessPermission");

			serialNumber = conn.getCheckOutSerialNumber();

			String sql = "UPDATE xml_access SET permission = ?" +

				"WHERE " + idAttribute + " = ? AND principal_name = ?";

			pstmt = conn.prepareStatement(sql);

			// Bind the values to the query

			pstmt.setLong(1, permission);

			pstmt.setString(2, id);

			pstmt.setString(3, principalName);

			String sqlReport = "XMLAccessAccess.updateXMLAccessPermission - SQL: " + sql;

			sqlReport += " [" + permission + "," + id + "," + principalName + "]";

			logMetacat.info(sqlReport);

			pstmt.execute();

		} catch (SQLException sqle) {

			throw new AccessException("XMLAccessAccess.updateXMLAccessPermission - SQL error when updating"

					+ "xml access permissions for id: " + id + ", principal: " + 

					principalName + ":" + sqle.getMessage());

		} finally {

			closeDBObjects(pstmt, conn, serialNumber, logMetacat); 

		}

	}

	/**

	 * Remove xml access.  This modifies the access in the database for a principal 

	 * for a given document.  If the provided permission is exactly the same as what 

	 * the principal has, the record is deleted from the database.

	 * 

	 * @param id

	 *            document id

	 * @param principalName

	 *            principal credentials

	 */

	public void removeXMLAccessForPrincipal(String id, String principalName, Long permission) throws AccessException {

		if (id == null) {

			throw new AccessException("XMLAccessAccess.removeXMLAccessForPrincipal - id is required when " + 

					"removing XML access");

		}

		if (principalName == null) {

			throw new AccessException("XMLAccessAccess.removeXMLAccessForPrincipal - principal is required when " + 

					"deleting XML access");

		}

		if (permission == null) {

			throw new AccessException("XMLAccessAccess.removeXMLAccessForPrincipal - permission is required when " + 

					"updating XML access");

		}

		Vector<XMLAccessDAO> xmlAccessList = getXMLAccessForPrincipal(id, principalName);

		if (xmlAccessList.size() == 0) {

			logMetacat.warn("XMLAccessAccess.removeXMLAccessForPrincipal - attempting to remove access when no " +

				"access record exists for id: " + id + ", principal: " + principalName);

		} else {

			long permissionMask = 0;

			for (XMLAccessDAO xmlAccessDAO : xmlAccessList) {

				permissionMask |= xmlAccessDAO.getPermission();

			}

			permissionMask |= permission;

			// in this case, the only existing permissions are the ones we want to remove, so 

			// delete the record(s) for this principal on this document

			if ((permissionMask & permission) == permission) {

				deleteXMLAccessForPrincipal(id, principalName);

			}

			if (xmlAccessList.size() > 1) {

			} else {

				updateXMLAccessPermission(id, principalName, permission);

			}

		}

	}

	/**

	 * Delete xml access.  This removes all access records from the database for a given document

	 * 

	 * @param id

	 *            document id

	 */

	public void deleteXMLAccessForDoc(String id) throws AccessException {

		if (id == null) {

			throw new AccessException("XMLAccessAccess.deleteXMLAccessForPrincipal - id is required when " + 

					"deleting XML access record");

		}

	    PreparedStatement pstmt = null;

		DBConnection conn = null;

		int serialNumber = -1;

		try {

			// check out DBConnection

			conn = DBConnectionPool.getDBConnection("XMLAccessAccess.deleteXMLAccessForDoc");

    		serialNumber = conn.getCheckOutSerialNumber();

			String sql = "DELETE FROM xml_access WHERE " + idAttribute + " = ?";

			pstmt = conn.prepareStatement(sql);

			// Bind the values to the query

			pstmt.setString(1, id);

			String sqlReport = "XMLAccessAccess.deleteXMLAccessForDoc - SQL: " + sql;

			sqlReport += " [" + id + "]";

			logMetacat.info(sqlReport);

			pstmt.execute();

		} catch (SQLException sqle) {

			throw new AccessException("XMLAccessAccess.deleteXMLAccessForDoc - SQL error when deleting"

					+ "xml access permissions for id: " + id + ":" + sqle.getMessage());

		} finally {

			closeDBObjects(pstmt, conn, serialNumber, logMetacat); 

		}	   

	}

	/**

	 * Delete xml access.  This removes all access records from the database for a principal 

	 * for a given document

	 * 

	 * @param id

	 *            document id

	 * @param principal

	 *            principal credentials

	 */

	private void deleteXMLAccessForPrincipal(String id, String principalName) throws AccessException {

		if (id == null) {

			throw new AccessException("XMLAccessAccess.deleteXMLAccessForPrincipal - id is required when " + 

					"deleting XML access record");

		}

		if (principalName == null) {

			throw new AccessException("XMLAccessAccess.deleteXMLAccessForPrincipal - principal is required when " + 

					"deleting XML access record");

		}

	    PreparedStatement pstmt = null;

		DBConnection conn = null;

		int serialNumber = -1;

		try {

			// check out DBConnection

			conn = DBConnectionPool.getDBConnection("XMLAccessAccess.deleteXMLAccessForPrincipal");

    		serialNumber = conn.getCheckOutSerialNumber();

			String sql = "DELETE FROM xml_access WHERE " + idAttribute + " = ? AND principal_name = ?";

			pstmt = conn.prepareStatement(sql);

			// Bind the values to the query

			pstmt.setString(1, id);

			pstmt.setString(2, principalName);

			String sqlReport = "XMLAccessAccess.deleteXMLAccessForPrincipal - SQL: " + sql;

			sqlReport += " [" + id + "," + principalName + "]";

			logMetacat.info(sqlReport);

			pstmt.execute();

		} catch (SQLException sqle) {

			throw new AccessException("XMLAccessAccess.deleteXMLAccessForPrincipal - SQL error when deleting"

					+ "xml access permissions for id: " + id + ", principal: " + 

					principalName + ":" + sqle.getMessage());

		} finally {

			closeDBObjects(pstmt, conn, serialNumber, logMetacat);

		}	   

	}

	/**

	 * Checks to see if there is a permission order conflict for a given document.  Each 

	 * document is only allowed to have a single permission order

	 * 

	 * @param id

	 *            document id

	 * @param principal

	 *            principal credentials

	 */

	private void permOrderConflict(String id, String permOrder) throws AccessException, PermOrderException {

		if (id == null) {

			throw new AccessException("XMLAccessAccess.permOrderConflict - id is required when " + 

					"determining perm order conflict");

		}

		if (permOrder == null) {

			throw new AccessException("XMLAccessAccess.permOrderConflict - perm order is required when " + 

					"determining perm order conflict");

		}

	    PreparedStatement pstmt = null;

		DBConnection conn = null;

		int serialNumber = -1;

		try {

			// check out DBConnection

			conn = DBConnectionPool.getDBConnection("XMLAccessAccess.permOrderConflict");

    		serialNumber = conn.getCheckOutSerialNumber();

			String sql = "SELECT * FROM xml_access WHERE " + idAttribute + " = ? AND perm_order != ?";

			pstmt = conn.prepareStatement(sql);

			// Bind the values to the query

			pstmt.setString(1, id);

			pstmt.setString(2, permOrder);

			String sqlReport = "XMLAccessAccess.permOrderConflict - SQL: " + sql;

			sqlReport += " [" + id + "," + permOrder + "]";

			logMetacat.info(sqlReport);

			pstmt.execute();

			ResultSet resultSet = pstmt.getResultSet();

			if (resultSet.next()) {			

				throw new PermOrderException("XMLAccessAccess.addXMLAccess - cannot add permission " + 

					"record for id: " + id + "with permOrder: " + permOrder + " due to permOrder conflict");

			}

		} catch (SQLException sqle) {

			throw new AccessException("XMLAccessAccess.permOrderConflict - SQL error when checking"

					+ "for perm order conflict on: " + id + ":" + sqle.getMessage());

		} finally {

			closeDBObjects(pstmt, conn, serialNumber, logMetacat); 

		}

	}

	/**

	 * Delete xml access.  This removes all access records from the database for a principal 

	 * for a given document, perm type and perm order

	 * 

	 * @param id

	 *            document id

	 * @param principal

	 *            principal credentials

	 */

	private void deleteXMLAccessForPrincipal(String id, String principalName, String permType, String permOrder) throws AccessException {

		if (id == null) {

			throw new AccessException("XMLAccessAccess.deleteXMLAccessForPrincipal - id is required when " + 

					"deleting XML access record");

		}

		if (principalName == null) {

			throw new AccessException("XMLAccessAccess.deleteXMLAccessForPrincipal - principal is required when " + 

					"deleting XML access record");

		}

		if (permType == null) {

			throw new AccessException(

					"XMLAccessAccess.deleteXMLAccessForPrincipal - perm type is required when "

							+ "deleting XML access record");

		}

		if (permOrder == null) {

			throw new AccessException(

					"XMLAccessAccess.deleteXMLAccessForPrincipal - perm order is required when "

							+ "deleting XML access record");

		}

	    PreparedStatement pstmt = null;

		DBConnection conn = null;

		int serialNumber = -1;

		try {

			// check out DBConnection

			conn = DBConnectionPool.getDBConnection("XMLAccessAccess.deleteXMLAccessForPrincipal");

    		serialNumber = conn.getCheckOutSerialNumber();

			String sql = "DELETE FROM xml_access WHERE " + idAttribute + " = ? AND principal_name = ? " +

				"AND perm_type = ? AND perm_order = ?";

			pstmt = conn.prepareStatement(sql);

			// Bind the values to the query

			pstmt.setString(1, id);

			pstmt.setString(2, principalName);

			pstmt.setString(3, permType);

			pstmt.setString(4, permOrder);

			String sqlReport = "XMLAccessAccess.deleteXMLAccessForPrincipal - SQL: " + sql;

			sqlReport += " [" + id + "," + principalName + "," + permType + "," + permOrder + "]";

			logMetacat.info(sqlReport);

			pstmt.execute();

		} catch (SQLException sqle) {

			throw new AccessException("XMLAccessAccess.deleteXMLAccessForPrincipal - SQL error when deleting"

					+ "xml access permissions for id: " + id + ", principal: " + 

					principalName + ":" + sqle.getMessage());

		} finally {

			closeDBObjects(pstmt, conn, serialNumber, logMetacat); 

		}

	}

	/**

	 * Make sure that only one record exists per principal/permType/document. If

	 * more than one record exists, delete the existing records, consolidate the

	 * permissions insert the new record.

	 * 

	 * @param xmlAccessList the access dao list

	 */

	private void cleanupXMLAccessForPrincipal(Vector<XMLAccessDAO> xmlAccessList) throws AccessException{

		int numAllowRecords = 0;

		int numDenyRecords = 0;

		long allowPermissionMask = 0;

		long denyPermissionMask = 0;

		String id = null;

		String principalName = null;

		String permType = null;

		String permOrder = null;

		// TODO: handle these fields

		String accessFileId = null;

		String subTreeId = null;

		// iterate through the list of access dao objects and bttwise or the permissions.  Most

		// of this is just doing some error checking to make sure each record is valid.

		for (XMLAccessDAO xmlAccessDAO : xmlAccessList) {

			String daoId = xmlAccessDAO.getDocId();

			if (idAttribute.equals(GUID)) {

				daoId = xmlAccessDAO.getGuid();

			}

			if (id == null) {

				id = daoId;

			} else {

				if (!id.equals(daoId)) {

					throw new AccessException("XMLAccessAccess.cleanupXMLAccessForPrincipal - " + 

							" Conflicting ids " + daoId + " and " + id);

				}

			}

			if (principalName == null) {

				principalName = xmlAccessDAO.getPrincipalName();

			} else {

				if (!principalName.equals(xmlAccessDAO.getPrincipalName())) {

					throw new AccessException("XMLAccessAccess.cleanupXMLAccessForPrincipal - " + 

							" Conflicting prinicpal names " + xmlAccessDAO.getPrincipalName() +

							" and principalName " + principalName);

				}

			}

			if (permType == null) {

				permType = xmlAccessDAO.getPermType();

			} else {

				if (!permType.equals(xmlAccessDAO.getPermType())) {

					throw new AccessException("XMLAccessAccess.cleanupXMLAccessForPrincipal - " + 

							" Conflicting permission orders for document " + daoId +

							"principalName " + principalName + ". Database intervention required ");

				}

			}

			if (permOrder == null) {

				permOrder = xmlAccessDAO.getPermOrder();

			} else {

				if (!permOrder.equals(xmlAccessDAO.getPermOrder())) {

					throw new AccessException("XMLAccessAccess.cleanupXMLAccessForPrincipal - " + 

							" Conflicting permission types for document " + daoId +

							"principalName " + principalName + ". Database intervention required ");

				}

			}

			if (permType == null) {

				permType = xmlAccessDAO.getPermType();

			} else {

				if (!permType.equals(xmlAccessDAO.getPermType())) {

					throw new AccessException("XMLAccessAccess.cleanupXMLAccessForPrincipal - " + 

							" Conflicting permission orders for document " + daoId +

							"principalName " + principalName + ". Database intervention required ");

				}

			}

			if (permType.equals(AccessControlInterface.ALLOW)) {

				numAllowRecords++;

				allowPermissionMask |= xmlAccessDAO.getPermission();

			} else if (permType.equals(AccessControlInterface.DENY)) {

				numDenyRecords++;

				denyPermissionMask |= xmlAccessDAO.getPermission();

			}

			if (accessFileId == null) {

				accessFileId = xmlAccessDAO.getAccessFileId();

			}

			if (subTreeId == null) {

				subTreeId = xmlAccessDAO.getSubTreeId();

			}

		}

		// if there was more than one allow record, remove all allow records for this user on this doc 

		// with this perm type and perm order then insert a single record 

		if (numAllowRecords > 1) {

			deleteXMLAccessForPrincipal(id, principalName, AccessControlInterface.ALLOW, permOrder);

			insertXMLAccess(id, principalName, allowPermissionMask, AccessControlInterface.ALLOW, permOrder, accessFileId, subTreeId);

		}

		// if there was more than one deny record, remove all deny records for this user on this doc 

		// with this perm type and perm order then insert a single record 

		if (numDenyRecords > 1) {

			deleteXMLAccessForPrincipal(id, principalName, AccessControlInterface.DENY, permOrder);

			insertXMLAccess(id, principalName, denyPermissionMask, AccessControlInterface.DENY, permOrder, accessFileId, subTreeId);

		}