Project

General

Profile

« Previous | Next » 

Revision 2759

Added by sgarg almost 19 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