Project

General

Profile

« Previous | Next » 

Revision 2759

Added by sgarg over 18 years ago

Using xml_path_index instead of xml_index to find documents which havnt been indexed.

View differences:

src/edu/ucsb/nceas/metacat/MetaCatServlet.java
197 197
    {
198 198
        // Close all db connection
199 199
        System.out.println("Destroying MetacatServlet");
200
        timer.cancel();
200 201
        DBConnectionPool.release();
201
        timer.cancel();
202 202
    }
203 203

  
204 204
    /** Handle "GET" method requests from HTTP clients */
src/edu/ucsb/nceas/metacat/IndexingTimerTask.java
56 56
	    	try{
57 57
	    		logMetacat.warn("Running indexing timer task");
58 58
	    		
59
	    		dbConn = DBConnectionPool.getDBConnection("IndexingThread.run");
59
	    		dbConn = DBConnectionPool.getDBConnection("IndexingThread");
60 60
	    		serialNumber = dbConn.getCheckOutSerialNumber();
61 61
	            Vector indexNamespaces = MetaCatUtil.getOptionList(MetaCatUtil.getOption("indexNamespaces"));
62 62
	            String nonJoinCriteria = "b.docid is NULL";
......
89 89
	    		
90 90
	    		String xmlDocumentsCheck = 
91 91
	    			MetaCatUtil.dbAdapter.getLeftJoinQuery("a.docid, a.rev", "xml_documents", 
92
	    					"xml_index", "a.docid = b.docid", nonJoinCriteria);
92
	    					"xml_path_index", "a.docid = b.docid", nonJoinCriteria);
93 93

  
94
	    		logMetacat.warn(xmlDocumentsCheck);
95 94
	    		PreparedStatement xmlDocCheck = dbConn.prepareStatement(xmlDocumentsCheck);
96 95
	    		
97 96
	    		// Increase usage count

Also available in: Unified diff