Project

General

Profile

« Previous | Next » 

Revision 3818

Added by Jing Tao over 16 years ago

Modify the delete xml_index table query.

View differences:

src/edu/ucsb/nceas/metacat/EML201DocumentCorrector.java
91 91
      */
92 92
     private String generateXML_IndexDeletingSQL()
93 93
     {
94
    	 String sql ="delete from xml_index where path ='references/@system' AND docid in "+ 
95
    	 "(select docid from xml_documents where doctype ='eml://ecoinformatics.org/eml-2.0.1')";
94
    	 String sql ="delete from xml_index where doctype ='eml://ecoinformatics.org/eml-2.0.1' AND nodeid in "+ 
95
    	 "(select nodeid from xml_index where path ='references/@system')";
96 96
    	 return sql;
97 97
     }
98 98
     
......
113 113
    	 EML201DocumentCorrector correct = new EML201DocumentCorrector();
114 114
    	 Thread thread = new Thread(correct);
115 115
    	 thread.start();
116
    	 //correct.run();
116 117
     }
117 118
}

Also available in: Unified diff