Details
-
Improvement
-
Resolution: Unresolved
-
Minor
-
None
-
2.0.2
-
None
Description
here are examples of queries:
select member0_.id as id24_, member0_.hibernate_version_number as hibernate2_24_, member0_.subject_id as subject3_24_, member0_.subject_source as subject4_24_, member0_.subject_type as subject5_24_, member0_.context_id as context6_24_, member0_.sort_string0 as sort7_24_, member0_.sort_string1 as sort8_24_, member0_.sort_string2 as sort9_24_, member0_.sort_string3 as sort10_24_, member0_.sort_string4 as sort11_24_, member0_.search_string0 as search12_24_, member0_.search_string1 as search13_24_, member0_.search_string2 as search14_24_, member0_.search_string3 as search15_24_, member0_.search_string4 as search16_24_, member0_.name as name24_, member0_.description as descrip18_24_ from grouper_members member0_ where member0_.id='3e08a467-59b5-4445-8a15-e592f568faeb'
2011/11/01 16:04:34:410, resultset: ALIASES: 0: ID24_, 1: HIBERNATE2_24_, 2: SUBJECT3_24_, 3: SUBJECT4_24_, 4: SUBJECT5_24_, 5: CONTEXT6_24_, 6: SORT7_24_, 7: SORT8_24_, 8: SORT9_24_, 9: SORT10_24_, 10: SORT11_24_, 11: SEARCH12_24_, 12: SEARCH13_24_, 13: SEARCH14_24_, 14: SEARCH15_24_, 15: SEARCH16_24_, 16: NAME24_, 17: DESCRIP18_24_
2011/11/01 16:04:34:422, 10ms, statement: NewProxyPreparedStatement.java.executeQuery() line 76, JDBCSourceAdapter2.java.search() line 623, JDBCSourceAdapter2.java.getSubject() line 448, SourcesXmlResolver.java.find() line 295, CachingResolver.java.find() line 123, ValidatingResolver.java.find() line 87, SubjectFinder.java.findByIdAndSource() line 256, Group.java.getCreateSubject() line 2447, GrouperSubject.java._populateCreateModifyTime() line 274, GrouperSubject.java.access$1() line 266, GrouperSubject.java.put() line 149, GrouperSubject.java.put() line 138, SubjectImpl.java.initVirtualAttributes() line 287, SubjectImpl.java.initAttributesIfNeeded() line 250, SubjectImpl.java.getAttributes() line 434, SubjectImpl.java.getAttributes() line 423, SubjectHelper.java.sortSetForSearch() line 115, SourcesXmlResolver.java.findPage() line 829, SourcesXmlResolver.java.findPageInStem() line 687, CachingResolver.java.findPageInStem() line 455, ValidatingResolver.java.findPageInStem() line 241, SubjectFinder.java.findPageInStem() line 1174, SimpleMembershipUpdateFilter.java.filterUsers() line 266, GrouperUtil.java.invokeMethod() line 3871, GrouperUtil.java.callMethod() line 3822, GrouperUiRestServlet.java.doGet() line 201, GrouperUiFilter.java.doFilter() line 804
select penn_id,name,description,description_lower,pennname,eppn,email,first_name,last_name,email_public,name_first_public,name_last_public,name_public,preferred_first_name from person_source_v where penn_id = '10018604'
2011/11/01 16:04:34:424, resultset: ALIASES: 0: PENN_ID, 1: NAME, 2: DESCRIPTION, 3: DESCRIPTION_LOWER, 4: PENNNAME, 5: EPPN, 6: EMAIL, 7: FIRST_NAME, 8: LAST_NAME, 9: EMAIL_PUBLIC, 10: NAME_FIRST_PUBLIC, 11: NAME_LAST_PUBLIC, 12: NAME_PUBLIC, 13: PREFERRED_FIRST_NAME
2011/11/01 16:04:34:440, 14ms, statement: ByHqlStatic.java.uniqueResult() line 297, Hib3MemberDAO.java.findBySubject() line 208, Hib3MemberDAO.java.findBySubject() line 179, MemberFinder.java.internal_findOrCreateBySubject() line 312, MemberFinder.java.internal_findBySubject() line 276, SourcesXmlResolver.java.updateMemberAttributes() line 562, SourcesXmlResolver.java.find() line 296, CachingResolver.java.find() line 123, ValidatingResolver.java.find() line 87, SubjectFinder.java.findByIdAndSource() line 256, Group.java.getCreateSubject() line 2447, GrouperSubject.java._populateCreateModifyTime() line 274, GrouperSubject.java.access$1() line 266, GrouperSubject.java.put() line 149, GrouperSubject.java.put() line 138, SubjectImpl.java.initVirtualAttributes() line 287, SubjectImpl.java.initAttributesIfNeeded() line 250, SubjectImpl.java.getAttributes() line 434, SubjectImpl.java.getAttributes() line 423, SubjectHelper.java.sortSetForSearch() line 115, SourcesXmlResolver.java.findPage() line 829, SourcesXmlResolver.java.findPageInStem() line 687, CachingResolver.java.findPageInStem() line 455, ValidatingResolver.java.findPageInStem() line 241, SubjectFinder.java.findPageInStem() line 1174, SimpleMembershipUpdateFilter.java.filterUsers() line 266, GrouperUtil.java.invokeMethod() line 3871, GrouperUtil.java.callMethod() line 3822, GrouperUiRestServlet.java.doGet() line 201, GrouperUiFilter.java.doFilter() line 804
select member0_.id as id24_, member0_.hibernate_version_number as hibernate2_24_, member0_.subject_id as subject3_24_, member0_.subject_source as subject4_24_, member0_.subject_type as subject5_24_, member0_.context_id as context6_24_, member0_.sort_string0 as sort7_24_, member0_.sort_string1 as sort8_24_, member0_.sort_string2 as sort9_24_, member0_.sort_string3 as sort10_24_, member0_.sort_string4 as sort11_24_, member0_.search_string0 as search12_24_, member0_.search_string1 as search13_24_, member0_.search_string2 as search14_24_, member0_.search_string3 as search15_24_, member0_.search_string4 as search16_24_, member0_.name as name24_, member0_.description as descrip18_24_ from grouper_members member0_ where member0_.subject_id='10018604' and member0_.subject_source='pennperson' and member0_.subject_type='person'
2011/11/01 16:04:34:442, resultset: ALIASES: 0: ID24_, 1: HIBERNATE2_24_, 2: SUBJECT3_24_, 3: SUBJECT4_24_, 4: SUBJECT5_24_, 5: CONTEXT6_24_, 6: SORT7_24_, 7: SORT8_24_, 8: SORT9_24_, 9: SORT10_24_, 10: SORT11_24_, 11: SEARCH12_24_, 12: SEARCH13_24_, 13: SEARCH14_24_, 14: SEARCH15_24_, 15: SEARCH16_24_, 16: NAME24_, 17: DESCRIP18_24_
2011/11/01 16:04:34:455, 6ms, statement: ByHqlStatic.java.uniqueResult() line 297, Hib3MemberDAO.java.findByUuid() line 245, Group.java.getCreateSubject() line 2445, GrouperSubject.java._populateCreateModifyTime() line 274, GrouperSubject.java.access$1() line 266, GrouperSubject.java.put() line 149, GrouperSubject.java.put() line 138, SubjectImpl.java.initVirtualAttributes() line 287, SubjectImpl.java.initAttributesIfNeeded() line 250, SubjectImpl.java.getAttributes() line 434, SubjectImpl.java.getAttributes() line 423, SubjectHelper.java.sortSetForSearch() line 115, SourcesXmlResolver.java.findPage() line 829, SourcesXmlResolver.java.findPageInStem() line 687, CachingResolver.java.findPageInStem() line 455, ValidatingResolver.java.findPageInStem() line 241, SubjectFinder.java.findPageInStem() line 1174, SimpleMembershipUpdateFilter.java.filterUsers() line 266, GrouperUtil.java.invokeMethod() line 3871, GrouperUtil.java.callMethod() line 3822, GrouperUiRestServlet.java.doGet() line 201, GrouperUiFilter.java.doFilter() line 804
select member0_.id as id24_, member0_.hibernate_version_number as hibernate2_24_, member0_.subject_id as subject3_24_, member0_.subject_source as subject4_24_, member0_.subject_type as subject5_24_, member0_.context_id as context6_24_, member0_.sort_string0 as sort7_24_, member0_.sort_string1 as sort8_24_, member0_.sort_string2 as sort9_24_, member0_.sort_string3 as sort10_24_, member0_.sort_string4 as sort11_24_, member0_.search_string0 as search12_24_, member0_.search_string1 as search13_24_, member0_.search_string2 as search14_24_, member0_.search_string3 as search15_24_, member0_.search_string4 as search16_24_, member0_.name as name24_, member0_.description as descrip18_24_ from grouper_members member0_ where member0_.id='3e2c783b-9041-43c9-bf79-9554ea56a2b1'
2011/11/01 16:04:34:456, resultset: ALIASES: 0: ID24_, 1: HIBERNATE2_24_, 2: SUBJECT3_24_, 3: SUBJECT4_24_, 4: SUBJECT5_24_, 5: CONTEXT6_24_, 6: SORT7_24_, 7: SORT8_24_, 8: SORT9_24_, 9: SORT10_24_, 10: SORT11_24_, 11: SEARCH12_24_, 12: SEARCH13_24_, 13: SEARCH14_24_, 14: SEARCH15_24_, 15: SEARCH16_24_, 16: NAME24_, 17: DESCRIP18_24_
2011/11/01 16:04:34:487, 30ms, statement: NewProxyPreparedStatement.java.executeQuery() line 76, JDBCSourceAdapter2.java.search() line 623, JDBCSourceAdapter2.java.getSubject() line 448, SourcesXmlResolver.java.find() line 295, CachingResolver.java.find() line 123, ValidatingResolver.java.find() line 87, SubjectFinder.java.findByIdAndSource() line 256, Group.java.getCreateSubject() line 2447, GrouperSubject.java._populateCreateModifyTime() line 274, GrouperSubject.java.access$1() line 266, GrouperSubject.java.put() line 149, GrouperSubject.java.put() line 138, SubjectImpl.java.initVirtualAttributes() line 287, SubjectImpl.java.initAttributesIfNeeded() line 250, SubjectImpl.java.getAttributes() line 434, SubjectImpl.java.getAttributes() line 423, SubjectHelper.java.sortSetForSearch() line 115, SourcesXmlResolver.java.findPage() line 829, SourcesXmlResolver.java.findPageInStem() line 687, CachingResolver.java.findPageInStem() line 455, ValidatingResolver.java.findPageInStem() line 241, SubjectFinder.java.findPageInStem() line 1174, SimpleMembershipUpdateFilter.java.filterUsers() line 266, GrouperUtil.java.invokeMethod() line 3871, GrouperUtil.java.callMethod() line 3822, GrouperUiRestServlet.java.doGet() line 201, GrouperUiFilter.java.doFilter() line 804