Metacat

			// check out DBConnection

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

			serialNumber = conn.getCheckOutSerialNumber();

			String sql = "INSERT INTO xml_access " +

				"(docid, principal_name, permission, perm_type, perm_order ) " + 

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

			// check out DBConnection

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

			serialNumber = conn.getCheckOutSerialNumber();

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

				"WHERE docid = ? AND principal_name = ?";

			pstmt = conn.prepareStatement(sql);

		try {

			// check out DBConnection

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

			String sql = "DELETE FROM xml_access WHERE docid = ?";

			pstmt = conn.prepareStatement(sql);

		try {

			// check out DBConnection

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

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

			pstmt = conn.prepareStatement(sql);

		try {

			// check out DBConnection

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

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

			pstmt = conn.prepareStatement(sql);

		try {

			// check out DBConnection

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

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

				"AND perm_type = ? AND perm_order = ?";

			pstmt = conn.prepareStatement(sql);