Project

General

Profile

Revision 4574

Added by daigle about 12 years ago

change some info and warn statements to debug

View differences:

src/edu/ucsb/nceas/metacat/DBQuery.java
603 603
          query = queryBuffer.toString();
604 604
      } 
605 605
      String ownerQuery = getOwnerQuery(user);
606
      logMetacat.info("\n\n\n query: " + query);
607
      logMetacat.info("\n\n\n owner query: "+ownerQuery);
606
      //logMetacat.debug("query: " + query);
607
      logMetacat.debug("owner query: "+ownerQuery);
608 608
      // if query is not the owner query, we need to check the permission
609 609
      // otherwise we don't need (owner has all permission by default)
610 610
      if (!query.equals(ownerQuery))
......
621 621
        }
622 622
        
623 623
      }
624
      logMetacat.warn("============ final selection query: " + query);
624
      logMetacat.debug("============ final selection query: " + query);
625 625
      String selectionAndExtendedQuery = null;
626 626
      // we only get cache for public
627 627
      if (user != null && user.equalsIgnoreCase("public") 
......
648 648
      rs = pstmt.executeQuery();
649 649

  
650 650
      double queryExecuteTime = System.currentTimeMillis() / 1000;
651
      logMetacat.warn("Time to execute select docid query is "
651
      logMetacat.debug("Time to execute select docid query is "
652 652
                    + (queryExecuteTime - startTime));
653 653
      MetaCatUtil.writeDebugToFile("\n\n\n\n\n\nExecute selection query  "
654 654
              + (queryExecuteTime - startTime));
......
665 665
      int currentIndex = 0;
666 666
      while (tableHasRows)
667 667
      {
668
        logMetacat.info("############getting result: " + currentIndex);
668
        logMetacat.debug("############getting result: " + currentIndex);
669 669
        docid = rs.getString(1).trim();
670
        logMetacat.info("############processing: " + docid);
670
        logMetacat.debug("############processing: " + docid);
671 671
        docname = rs.getString(2);
672 672
        doctype = rs.getString(3);
673
        logMetacat.info("############processing: " + doctype);
673
        logMetacat.debug("############processing: " + doctype);
674 674
        createDate = rs.getString(4);
675 675
        updateDate = rs.getString(5);
676 676
        rev = rs.getInt(6);
......
678 678
         Vector returndocVec = qspec.getReturnDocList();
679 679
       if (returndocVec.size() == 0 || returndocVec.contains(doctype))
680 680
        {
681
          logMetacat.info("NOT Back tracing now...");
681
          logMetacat.debug("NOT Back tracing now...");
682 682
           document = new StringBuffer();
683 683

  
684 684
           String completeDocid = docid
......
723 723
          docListResult = new ResultDocumentSet();
724 724
        }
725 725
       
726
       logMetacat.info("currentIndex: " + currentIndex);
727
       logMetacat.info("page comparator: " + (pagesize * pagestart) + pagesize);
726
       logMetacat.debug("currentIndex: " + currentIndex);
727
       logMetacat.debug("page comparator: " + (pagesize * pagestart) + pagesize);
728 728
       if(currentIndex >= ((pagesize * pagestart) + pagesize))
729 729
       {
730 730
         ResultDocumentSet pagedResultsHash = new ResultDocumentSet();

Also available in: Unified diff