r4574 - trunk/src/edu/ucsb/nceas/metacat

[daigle at ecoinformatics.org]

Author: daigle
Date: 2008-11-18 14:19:47 -0800 (Tue, 18 Nov 2008)
New Revision: 4574

Modified:
   trunk/src/edu/ucsb/nceas/metacat/DBQuery.java
Log:
change some info and warn statements to debug

Modified: trunk/src/edu/ucsb/nceas/metacat/DBQuery.java
===================================================================
--- trunk/src/edu/ucsb/nceas/metacat/DBQuery.java	2008-11-18 22:18:57 UTC (rev 4573)
+++ trunk/src/edu/ucsb/nceas/metacat/DBQuery.java	2008-11-18 22:19:47 UTC (rev 4574)
@@ -603,8 +603,8 @@
           query = queryBuffer.toString();
       } 
       String ownerQuery = getOwnerQuery(user);
-      logMetacat.info("\n\n\n query: " + query);
-      logMetacat.info("\n\n\n owner query: "+ownerQuery);
+      //logMetacat.debug("query: " + query);
+      logMetacat.debug("owner query: "+ownerQuery);
       // if query is not the owner query, we need to check the permission
       // otherwise we don't need (owner has all permission by default)
       if (!query.equals(ownerQuery))
@@ -621,7 +621,7 @@
         }
         
       }
-      logMetacat.warn("============ final selection query: " + query);
+      logMetacat.debug("============ final selection query: " + query);
       String selectionAndExtendedQuery = null;
       // we only get cache for public
       if (user != null && user.equalsIgnoreCase("public") 
@@ -648,7 +648,7 @@
       rs = pstmt.executeQuery();
 
       double queryExecuteTime = System.currentTimeMillis() / 1000;
-      logMetacat.warn("Time to execute select docid query is "
+      logMetacat.debug("Time to execute select docid query is "
                     + (queryExecuteTime - startTime));
       MetaCatUtil.writeDebugToFile("\n\n\n\n\n\nExecute selection query  "
               + (queryExecuteTime - startTime));
@@ -665,12 +665,12 @@
       int currentIndex = 0;
       while (tableHasRows)
       {
-        logMetacat.info("############getting result: " + currentIndex);
+        logMetacat.debug("############getting result: " + currentIndex);
         docid = rs.getString(1).trim();
-        logMetacat.info("############processing: " + docid);
+        logMetacat.debug("############processing: " + docid);
         docname = rs.getString(2);
         doctype = rs.getString(3);
-        logMetacat.info("############processing: " + doctype);
+        logMetacat.debug("############processing: " + doctype);
         createDate = rs.getString(4);
         updateDate = rs.getString(5);
         rev = rs.getInt(6);
@@ -678,7 +678,7 @@
          Vector returndocVec = qspec.getReturnDocList();
        if (returndocVec.size() == 0 || returndocVec.contains(doctype))
         {
-          logMetacat.info("NOT Back tracing now...");
+          logMetacat.debug("NOT Back tracing now...");
            document = new StringBuffer();
 
            String completeDocid = docid
@@ -723,8 +723,8 @@
           docListResult = new ResultDocumentSet();
         }
        
-       logMetacat.info("currentIndex: " + currentIndex);
-       logMetacat.info("page comparator: " + (pagesize * pagestart) + pagesize);
+       logMetacat.debug("currentIndex: " + currentIndex);
+       logMetacat.debug("page comparator: " + (pagesize * pagestart) + pagesize);
        if(currentIndex >= ((pagesize * pagestart) + pagesize))
        {
          ResultDocumentSet pagedResultsHash = new ResultDocumentSet();