Revision 4574
Added by daigle about 16 years ago
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
change some info and warn statements to debug