Project

General

Profile

« Previous | Next » 

Revision 3068

Added by perry about 18 years ago

Ensure that spatial cache respects changed access constraints for updated documents

View differences:

src/edu/ucsb/nceas/metacat/spatial/SpatialDocument.java
89 89 
     */
90 90 
    String query = "SELECT path, nodedatanumerical, parentnodeid FROM xml_path_index"
91 91 
    + " WHERE docid = '" + docid.trim() + "'"
92 
    + " AND docid IN (SELECT distinct docid FROM xml_access WHERE docid = '" + docid.trim()
93 
    + "' AND principal_name = 'public' AND perm_type = 'allow')"
92 94 
    + " AND (path = '" + MetaCatUtil.getOption("westBoundingCoordinatePath") + "'"
93 95 
    + "  OR path = '" + MetaCatUtil.getOption("southBoundingCoordinatePath") + "'"
94 96 
    + "  OR path = '" + MetaCatUtil.getOption("eastBoundingCoordinatePath") + "'"
......
115 117 
      pstmt.close();
116 118 
    }
117 119 
    catch(Exception e) {
118 
      log.error(" ---- Error getting bounding coordinates for " + docid);
120 
      log.error(" ---- Could not get bounding coordinates for " + docid + );
119 121 
      e.printStackTrace();
120 122 
    }
121 123 

  		












Also available in:  Unified diff