10 Replies Latest reply on Oct 29, 2007 8:40 PM by Terry

    getter method called hundereds of times

    Terry Apprentice

      I have a jsf list (search) page based on seam-gen project. In MyEntityList object I've got simple getter/setter methods to set property in MyEntityList object. The jsf list/search page has 6 input fields (a dynamic selectOne pulldown, 3 inputText, 2 rich:Calendar). Just select 2 rich:Calendar fields and submitting the search calls my getter methods in MyEntityList "225" times.

      Is this normal? What if get methods has some complex code in it. Output attached.

      
      15:05:05,218 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,234 INFO [OrgUserService] Loading organisationUserListAll...
      15:05:05,249 INFO [STDOUT] Hibernate:
       /* select
       organisationUser
       from
       OrganisationUser organisationUser
       order by
       username asc */ select
       top 25 organisati0_.ID as ID22_,
       organisati0_.Password as Password22_,
       organisati0_.Status as Status22_,
       organisati0_.Username as Username22_,
       organisati0_.LastUpdateDate as LastUpda5_22_,
       organisati0_.InsertDate as InsertDate22_,
       organisati0_.LastLoginDate as LastLogi7_22_,
       organisati0_.LoginAttempts as LoginAtt8_22_,
       organisati0_.Email as Email22_,
       organisati0_.OrganisationID as Organis11_22_,
       organisati0_.LockedDate as LockedDate22_
       from
       OrganisationUser organisati0_
       order by
       organisati0_.Username asc
      15:05:05,280 INFO [OrgUserService] Loaded loadOrganisationUserListAll: 2
      15:05:05,327 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,327 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,327 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,359 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,437 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,437 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,468 INFO [STDOUT] Hibernate:
       /* select
       organisationUserActivityLog
       from
       OrganisationUserActivityLog organisationUserActivityLog
       order by
       organisationUserActivityLog.insertDate desc,
       organisationUser.username asc,
       organisationUserActivityLog.action asc */ select
       top 25 organisati0_.ID as ID23_,
       organisati0_.Description as Descript2_23_,
       organisati0_.Action as Action23_,
       organisati0_.LastUpdateDate as LastUpda4_23_,
       organisati0_.InsertDate as InsertDate23_,
       organisati0_.IPAddress as IPAddress23_,
       organisati0_.OrganisationUserID as Organisa7_23_
       from
       organisationUserActivityLog organisati0_,
       OrganisationUser organisati1_
       where
       organisati0_.OrganisationUserID=organisati1_.ID
       order by
       organisati0_.InsertDate desc,
       organisati1_.Username asc,
       organisati0_.Action asc
      15:05:05,515 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,515 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,515 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,530 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,530 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,562 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,562 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,577 INFO [STDOUT] Hibernate:
       /* select
       count(*)
       from
       OrganisationUserActivityLog organisationUserActivityLog */ select
       count(*) as col_0_0_
       from
       organisationUserActivityLog organisati0_
      15:05:05,593 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,609 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,609 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,609 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,624 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,624 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,640 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,655 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,655 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,671 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,671 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,687 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,702 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,702 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,718 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,718 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,734 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,765 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,780 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,780 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,796 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,796 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,812 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,843 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,859 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,874 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,890 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,890 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,905 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,921 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,921 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,937 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,937 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,952 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,968 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,968 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,984 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,999 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:05,999 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,015 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,015 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,030 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,030 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,030 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,030 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,046 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,046 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,046 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,062 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,062 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,062 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,062 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,062 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,062 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,062 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,077 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,077 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,077 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,077 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,093 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,093 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,093 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,093 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:06,109 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:07,655 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:07,734 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,124 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,140 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,171 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,171 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,187 INFO [STDOUT] Hibernate:
       /* select
       organisationUserActivityLog
       from
       OrganisationUserActivityLog organisationUserActivityLog
       order by
       organisationUserActivityLog.insertDate desc,
       organisationUser.username asc,
       organisationUserActivityLog.action asc */ select
       top 25 organisati0_.ID as ID23_,
       organisati0_.Description as Descript2_23_,
       organisati0_.Action as Action23_,
       organisati0_.LastUpdateDate as LastUpda4_23_,
       organisati0_.InsertDate as InsertDate23_,
       organisati0_.IPAddress as IPAddress23_,
       organisati0_.OrganisationUserID as Organisa7_23_
       from
       organisationUserActivityLog organisati0_,
       OrganisationUser organisati1_
       where
       organisati0_.OrganisationUserID=organisati1_.ID
       order by
       organisati0_.InsertDate desc,
       organisati1_.Username asc,
       organisati0_.Action asc
      15:05:16,218 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,218 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,234 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,234 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,249 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,249 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,249 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,390 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,390 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,390 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,390 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,421 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,421 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,421 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,437 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,468 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,468 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,484 INFO [STDOUT] Hibernate:
       /* select
       organisationUserActivityLog
       from
       OrganisationUserActivityLog organisationUserActivityLog
       order by
       organisationUserActivityLog.insertDate desc,
       organisationUser.username asc,
       organisationUserActivityLog.action asc */ select
       top 25 organisati0_.ID as ID23_,
       organisati0_.Description as Descript2_23_,
       organisati0_.Action as Action23_,
       organisati0_.LastUpdateDate as LastUpda4_23_,
       organisati0_.InsertDate as InsertDate23_,
       organisati0_.IPAddress as IPAddress23_,
       organisati0_.OrganisationUserID as Organisa7_23_
       from
       organisationUserActivityLog organisati0_,
       OrganisationUser organisati1_
       where
       organisati0_.OrganisationUserID=organisati1_.ID
       order by
       organisati0_.InsertDate desc,
       organisati1_.Username asc,
       organisati0_.Action asc
      15:05:16,780 INFO [STDOUT] Hibernate:
       /* select
       organisationUserActivityLog
       from
       OrganisationUserActivityLog organisationUserActivityLog
       where
       organisationUserActivityLog.insertDate >= :el6
       and organisationUserActivityLog.insertDate <= :el7
       order by
       organisationUserActivityLog.insertDate desc,
       organisationUser.username asc,
       organisationUserActivityLog.action asc */ select
       top 25 organisati0_.ID as ID23_,
       organisati0_.Description as Descript2_23_,
       organisati0_.Action as Action23_,
       organisati0_.LastUpdateDate as LastUpda4_23_,
       organisati0_.InsertDate as InsertDate23_,
       organisati0_.IPAddress as IPAddress23_,
       organisati0_.OrganisationUserID as Organisa7_23_
       from
       organisationUserActivityLog organisati0_,
       OrganisationUser organisati1_
       where
       organisati0_.OrganisationUserID=organisati1_.ID
       and organisati0_.InsertDate>=?
       and organisati0_.InsertDate<=?
       order by
       organisati0_.InsertDate desc,
       organisati1_.Username asc,
       organisati0_.Action asc
      15:05:16,812 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,812 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,827 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,827 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,827 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,827 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,843 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,843 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,859 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:16,937 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,937 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,952 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,952 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,952 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,952 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,952 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,952 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:16,968 INFO [STDOUT] Hibernate:
       /* select
       count(*)
       from
       OrganisationUserActivityLog organisationUserActivityLog
       where
       organisationUserActivityLog.insertDate >= :el6
       and organisationUserActivityLog.insertDate <= :el7 */ select
       count(*) as col_0_0_
       from
       organisationUserActivityLog organisati0_
       where
       organisati0_.InsertDate>=?
       and organisati0_.InsertDate<=?
      15:05:17,015 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,015 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,015 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,015 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,030 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,046 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,046 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,062 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,077 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,124 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,140 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,140 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,155 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,155 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,171 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,171 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,171 INFO [STDOUT] Hibernate:
       /* load au.edu.tisc.entity.OrganisationUser */ select
       organisati0_.ID as ID22_0_,
       organisati0_.Password as Password22_0_,
       organisati0_.Status as Status22_0_,
       organisati0_.Username as Username22_0_,
       organisati0_.LastUpdateDate as LastUpda5_22_0_,
       organisati0_.InsertDate as InsertDate22_0_,
       organisati0_.LastLoginDate as LastLogi7_22_0_,
       organisati0_.LoginAttempts as LoginAtt8_22_0_,
       organisati0_.Email as Email22_0_,
       organisati0_.OrganisationID as Organis11_22_0_,
       organisati0_.LockedDate as LockedDate22_0_
       from
       OrganisationUser organisati0_
       where
       organisati0_.ID=?
      15:05:17,218 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,234 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,234 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,249 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,265 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,280 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,296 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,296 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,312 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,312 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,343 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,359 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,359 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,359 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,390 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,390 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,390 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,405 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,405 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:17,421 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:17,421 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:17,421 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:17,609 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:17,624 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:17,624 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:17,640 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:17,734 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:17,734 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:17,749 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:17,749 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:17,749 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,749 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:17,984 INFO [STDOUT] Hibernate:
       /* select
       organisationUserActivityLog
       from
       OrganisationUserActivityLog organisationUserActivityLog
       where
       organisationUserActivityLog.insertDate >= :el6
       and organisationUserActivityLog.insertDate <= :el7
       order by
       organisationUserActivityLog.insertDate desc,
       organisationUser.username asc,
       organisationUserActivityLog.action asc */ select
       top 25 organisati0_.ID as ID23_,
       organisati0_.Description as Descript2_23_,
       organisati0_.Action as Action23_,
       organisati0_.LastUpdateDate as LastUpda4_23_,
       organisati0_.InsertDate as InsertDate23_,
       organisati0_.IPAddress as IPAddress23_,
       organisati0_.OrganisationUserID as Organisa7_23_
       from
       organisationUserActivityLog organisati0_,
       OrganisationUser organisati1_
       where
       organisati0_.OrganisationUserID=organisati1_.ID
       and organisati0_.InsertDate>=?
       and organisati0_.InsertDate<=?
       order by
       organisati0_.InsertDate desc,
       organisati1_.Username asc,
       organisati0_.Action asc
      15:05:18,093 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:18,093 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:18,093 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:18,109 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:18,109 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:18,109 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:18,562 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:18,577 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,155 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,187 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,187 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,187 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,187 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,187 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,234 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,234 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,234 INFO [STDOUT] Hibernate:
       /* select
       organisationUserActivityLog
       from
       OrganisationUserActivityLog organisationUserActivityLog
       where
       organisationUserActivityLog.insertDate >= :el6
       and organisationUserActivityLog.insertDate <= :el7
       order by
       organisationUserActivityLog.insertDate desc,
       organisationUser.username asc,
       organisationUserActivityLog.action asc */ select
       top 25 organisati0_.ID as ID23_,
       organisati0_.Description as Descript2_23_,
       organisati0_.Action as Action23_,
       organisati0_.LastUpdateDate as LastUpda4_23_,
       organisati0_.InsertDate as InsertDate23_,
       organisati0_.IPAddress as IPAddress23_,
       organisati0_.OrganisationUserID as Organisa7_23_
       from
       organisationUserActivityLog organisati0_,
       OrganisationUser organisati1_
       where
       organisati0_.OrganisationUserID=organisati1_.ID
       and organisati0_.InsertDate>=?
       and organisati0_.InsertDate<=?
       order by
       organisati0_.InsertDate desc,
       organisati1_.Username asc,
       organisati0_.Action asc
      15:05:19,249 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,249 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,249 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,249 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,249 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,249 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,265 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,265 INFO [STDOUT] Hibernate:
       /* select
       count(*)
       from
       OrganisationUserActivityLog organisationUserActivityLog
       where
       organisationUserActivityLog.insertDate >= :el6
       and organisationUserActivityLog.insertDate <= :el7 */ select
       count(*) as col_0_0_
       from
       organisationUserActivityLog organisati0_
       where
       organisati0_.InsertDate>=?
       and organisati0_.InsertDate<=?
      15:05:19,265 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,265 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,265 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,265 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,280 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,280 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,296 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,296 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,312 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,343 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,562 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,577 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,593 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,624 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,624 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,640 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,640 INFO [STDOUT] Hibernate:
       /* load au.edu.tisc.entity.OrganisationUser */ select
       organisati0_.ID as ID22_0_,
       organisati0_.Password as Password22_0_,
       organisati0_.Status as Status22_0_,
       organisati0_.Username as Username22_0_,
       organisati0_.LastUpdateDate as LastUpda5_22_0_,
       organisati0_.InsertDate as InsertDate22_0_,
       organisati0_.LastLoginDate as LastLogi7_22_0_,
       organisati0_.LoginAttempts as LoginAtt8_22_0_,
       organisati0_.Email as Email22_0_,
       organisati0_.OrganisationID as Organis11_22_0_,
       organisati0_.LockedDate as LockedDate22_0_
       from
       OrganisationUser organisati0_
       where
       organisati0_.ID=?
      15:05:19,749 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,765 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,780 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,796 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,812 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,827 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,843 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,859 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,890 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,890 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:19,905 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:20,890 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:20,890 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:20,905 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:20,905 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:20,937 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:20,937 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:20,952 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is NOT null ....
      15:05:22,374 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      15:05:23,140 INFO [STDOUT] *** getSelectedInsertDateFrom() - property is null....
      







        • 1. Re: getter method called hundereds of times
          Terry Apprentice

          For anyone interested, MyEntityList code:

          
          package au.edu.tisc.entity;
          
          import java.util.Arrays;
          import java.util.Calendar;
          import java.util.Date;
          import java.util.List;
          
          import org.jboss.seam.annotations.Name;
          import org.jboss.seam.framework.EntityQuery;
          
          import au.edu.tisc.util.DateTime;
          import au.edu.tisc.util.Strings;
          
          @Name("organisationUserActivityLogList")
          public class OrganisationUserActivityLogList extends EntityQuery {
          
           private static final String[] RESTRICTIONS = {
           "lower(organisationUserActivityLog.id) like concat('%', lower(#{organisationUserActivityLogList.organisationUserActivityLog.id}),'%')",
           "lower(organisationUserActivityLog.ipaddress) like concat('%', lower(#{organisationUserActivityLogList.organisationUserActivityLog.ipaddress}),'%')",
           "lower(organisationUserActivityLog.action) like concat('%', lower(#{organisationUserActivityLogList.organisationUserActivityLog.action}),'%')",
           "lower(organisationUserActivityLog.description) like concat('%', lower(#{organisationUserActivityLogList.organisationUserActivityLog.description}),'%')",
           "lower(organisationUserActivityLog.organisationUser.id) like concat('%', '%',lower(#{organisationUserActivityLogList.selectedOrgUserId}),'%')",
           "organisationUserActivityLog.insertDate >= #{organisationUserActivityLogList.selectedInsertDateFrom}",
           "organisationUserActivityLog.insertDate <= #{organisationUserActivityLogList.selectedInsertDateTo}",
           };
          
           private OrganisationUserActivityLog organisationUserActivityLog = new OrganisationUserActivityLog();
          
           private String selectedOrgUserId = null;
           private Date selectedInsertDateFrom = null;
           private Date selectedInsertDateTo = null;
          
           @Override
           public String getEjbql() {
           return "select organisationUserActivityLog from OrganisationUserActivityLog organisationUserActivityLog";
           }
          
           @Override
           public Integer getMaxResults() {
           return 25;
           }
          
           public OrganisationUserActivityLog getOrganisationUserActivityLog() {
           return organisationUserActivityLog;
           }
          
           @Override
           public List<String> getRestrictions() {
           return Arrays.asList(RESTRICTIONS);
           }
          
           public String getSelectedOrgUserId() {
           return this.selectedOrgUserId;
           }
          
           public void setSelectedOrgUserId(String selectedOrgUserId) {
           this.selectedOrgUserId = selectedOrgUserId;
           }
          
           public Date getSelectedInsertDateFrom() {
          
           if (this.selectedInsertDateFrom != null) {
           System.out.println("*** getSelectedInsertDateFrom() - property is null....");
           } else {
           System.out.println("*** getSelectedInsertDateFrom() - property is null....");
           }
          
           return this.selectedInsertDateFrom;
           }
          
           public void setSelectedInsertDateFrom(Date selectedInsertDateFrom) {
           this.selectedInsertDateFrom = selectedInsertDateFrom;
           }
          
           public Date getSelectedInsertDateTo() {
          
           if (selectedInsertDateTo != null) {
          
           Calendar cal= Calendar.getInstance();
           cal.setTime(selectedInsertDateTo);
          
           if (!DateTime.hasTime(cal)) {
           DateTime.setDayEnd(cal);
           }
           return (cal.getTime());
           } else {
           return this.selectedInsertDateTo;
           }
           }
          
           public void setSelectedInsertDateTo(Date selectedInsertDateTo) {
           this.selectedInsertDateTo = selectedInsertDateTo;
           }
          
           @Override
           public String getOrder() {
           String order = super.getOrder();
           if (Strings.isNull(order)) {
           order = "organisationUserActivityLog.insertDate desc, organisationUser.username asc, organisationUserActivityLog.action asc";
           }
           return order;
           }
          }
          
          
          


          • 2. Re: getter method called hundereds of times
            Pete Muir Master

            Probably this is normal. Post the view too.

            • 3. Re: getter method called hundereds of times
              Terry Apprentice

              Pete, it came down to 113 calls (half of as in my initial post), after I removed a4j:support call from form submission button (h:commandButton ...). but removing other a4j calls didn't make difference. 113 calls still seems too many. application im working towards will be used by hundereds of users at one time.

              organisation-user-activity-log-list.xhtml
              <!DOCTYPE composition PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
               "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
              
              <ui:composition xmlns="http://www.w3.org/1999/xhtml"
               xmlns:s="http://jboss.com/products/seam/taglib"
               xmlns:ui="http://java.sun.com/jsf/facelets"
               xmlns:f="http://java.sun.com/jsf/core"
               xmlns:h="http://java.sun.com/jsf/html"
               xmlns:a4j="http://richfaces.org/a4j"
               xmlns:rich="http://richfaces.org/rich"
               template="layout/template.xhtml">
              
              <ui:define name="content">
              
               <div class="section">
              
               <h1>Organisation User Activity Log - Search
                <a4j:status><f:facet name="start"><h:graphicImage value="/img/dinkus/spinner.gif"/></f:facet></a4j:status>
               </h1>
               <p/>
               <div>
               <h:messages id="globalMessages" globalOnly="true" layout="table" styleClass="message-error" rendered="#{!empty facesContext.maximumSeverity}"/>
               </div>
              
               <h:form id="organisationUserActivityLog" styleClass="edit">
              
               <div class="dialog">
               <h:panelGrid columns="2" rowClasses="prop" columnClasses="name,value">
              
               <h:outputLabel for="organisationUserId">Oranisation user</h:outputLabel>
               <h:selectOneMenu value="#{organisationUserActivityLogList.selectedOrgUserId}" id="organisationUserId">
               <f:selectItem itemLabel="All users" itemValue=""/>
               <f:selectItems value="#{organisationUserListAll}"/>
               </h:selectOneMenu>
              
               <h:outputLabel for="action">Activity</h:outputLabel>
               <h:inputText id="action" value="#{organisationUserActivityLogList.organisationUserActivityLog.action}">
               <a4j:support event="onkeyup" requestDelay="1000" reRender="organisationUserActivityLogSearchResults"/>
               </h:inputText>
              
               <h:outputLabel for="description">Description</h:outputLabel>
               <h:inputText id="description" value="#{organisationUserActivityLogList.organisationUserActivityLog.description}">
               <a4j:support event="onkeyup" requestDelay="1000" reRender="organisationUserActivityLogSearchResults"/>
               </h:inputText>
              
               <h:outputLabel for="ipaddress">IP Address</h:outputLabel>
               <h:inputText id="ipaddress" value="#{organisationUserActivityLogList.organisationUserActivityLog.ipaddress}">
               <a4j:support event="onkeyup" requestDelay="1000" reRender="organisationUserActivityLogSearchResults"/>
               </h:inputText>
               <h:outputLabel for="selectedInsertDateFrom">Log date from</h:outputLabel>
               <h:panelGrid id="selectedInsertDateFromPanel" columns="2" width="100%" rowClasses="calendar-row" columnClasses="ecol1, ecol2">
               <a4j:outputPanel id="selectedInsertDateFrom" layout="block">
               <rich:calendar value="#{organisationUserActivityLogList.selectedInsertDateFrom}"
               popup="true" datePattern="dd/MM/yyyy" enableManualInput="false"/>
               </a4j:outputPanel>
               </h:panelGrid>
              
               <h:outputLabel for="selectedInsertDateTo">Log date to</h:outputLabel>
               <h:panelGrid id="selectedInsertDateToPanel" columns="2" width="100%" rowClasses="calendar-row" columnClasses="ecol1, ecol2">
               <a4j:outputPanel id="selectedInsertDateTo" layout="block">
               <rich:calendar value="#{organisationUserActivityLogList.selectedInsertDateTo}"
               popup="true" datePattern="dd/MM/yyyy" enableManualInput="false"/>
               </a4j:outputPanel>
               </h:panelGrid>
               </h:panelGrid>
              
               <table>
               <tr class="prop">
               <td class="name"> </td>
               <td class="value">
               <div class="actionButtons">
               <h:commandButton id="search" value="Search" action="/organisation-user-activity-log-list.xhtml"/>
               <h:commandButton value="Reset" onclick="resetForm(document.organisationUserActivityLog); return false;">
               <a4j:support event="onmouseup" requestDelay="1000" reRender="organisationUserActivityLogSearchResults"/>
               </h:commandButton>
               <s:button view="/organisation-user-activity-log-edit.xhtml" id="create" value="Create Organisation User Activity Log" rendered="#{empty from}">
               <f:param name="organisationUserActivityLogId"/>
               </s:button>
               <s:button id="cancel" value="Cancel" view="/#{from}.xhtml" rendered="#{!empty from}"/>
               </div>
               </td>
               </tr>
               </table>
               </div>
               </h:form>
              
               <a4j:outputPanel id="organisationUserActivityLogSearchResults">
               <div class="results" id="organisationUserActivityLogList">
               <p/>
               <h1>Search Results</h1>
               <p/>
               <h:outputText value="No organisation user activity log exists." rendered="#{empty organisationUserActivityLogList.resultList}"/>
               <h:outputText value="Found #{organisationUserActivityLogList.resultCount} records." rendered="#{not empty organisationUserActivityLogList.resultList}"/>
              
               <h:dataTable id="organisationUserActivityLogList" var="organisationUserActivityLog" value="#{organisationUserActivityLogList.resultList}"
               rendered="#{not empty organisationUserActivityLogList.resultList}" border="1">
              
               <h:column>
               <f:facet name="header">
               <s:link styleClass="columnHeader"
               value="Inserted #{organisationUserActivityLogList.order=='insertDate asc' ? messages.down : ( organisationUserActivityLogList.order=='insertDate desc' ? messages.up : '' )}">
               <f:param name="order" value="#{organisationUserActivityLogList.order=='insertDate asc' ? 'insertDate desc' : 'insertDate asc'}"/>
               </s:link>
               </f:facet>
               <h:outputText value="#{organisationUserActivityLog.insertDate}"><s:convertDateTime type="both" dateStyle="default"/></h:outputText>
               </h:column>
               <h:column>
               <f:facet name="header">
               <s:link styleClass="columnHeader"
               value="Activity #{organisationUserActivityLogList.order=='action asc' ? messages.down : ( organisationUserActivityLogList.order=='action desc' ? messages.up : '' )}">
               <f:param name="order" value="#{organisationUserActivityLogList.order=='action asc' ? 'action desc' : 'action asc'}"/>
               </s:link>
               </f:facet>
               #{organisationUserActivityLog.action}
               </h:column>
               <h:column>
               <f:facet name="header">
               <s:link styleClass="columnHeader"
               value="Organisation User #{organisationUserActivityLogList.order=='organisationUser.id asc' ? messages.down : ( organisationUserActivityLogList.order=='organisationUser.id desc' ? messages.up : '' )}">
               <f:param name="order" value="#{organisationUserActivityLogList.order=='organisationUser.id asc' ? 'organisationUser.id desc' : 'organisationUser.id asc'}"/>
               </s:link>
               </f:facet>
               #{organisationUserActivityLog.organisationUser.username}
               </h:column>
               <h:column>
               <f:facet name="header">
               <s:link styleClass="columnHeader"
               value="Description #{organisationUserActivityLogList.order=='description asc' ? messages.down : ( organisationUserActivityLogList.order=='description desc' ? messages.up : '' )}">
               <f:param name="order" value="#{organisationUserActivityLogList.order=='description asc' ? 'description desc' : 'description asc'}"/>
               </s:link>
               </f:facet>
               #{organisationUserActivityLog.description}
               </h:column>
               <h:column>
               <f:facet name="header">
               <s:link styleClass="columnHeader"
               value="IP Address #{organisationUserActivityLogList.order=='ipaddress asc' ? messages.down : ( organisationUserActivityLogList.order=='ipaddress desc' ? messages.up : '' )}">
               <f:param name="order" value="#{organisationUserActivityLogList.order=='ipaddress asc' ? 'ipaddress desc' : 'ipaddress asc'}"/>
               </s:link>
               </f:facet>
               #{organisationUserActivityLog.ipaddress}
               </h:column>
               <h:column>
               <f:facet name="header">Action</f:facet>
               <s:link view="/organisation-user-activity-log.xhtml" value="View" id="organisationUserActivityLog">
               <f:param name="organisationUserActivityLogId" value="#{organisationUserActivityLog.id}"/>
               </s:link>
               </h:column>
               </h:dataTable>
              
               </div>
              
               <div class="tableControl">
              
               <s:link view="/organisation-user-activity-log-list.xhtml" rendered="#{organisationUserActivityLogList.previousExists}"
               value="#{messages.left}#{messages.left} First Page" id="firstPage">
               <f:param name="firstResult" value="0"/>
               </s:link>
              
               <s:link view="/organisation-user-activity-log-list.xhtml" rendered="#{organisationUserActivityLogList.previousExists}"
               value="#{messages.left} Previous Page" id="previousPage">
               <f:param name="firstResult" value="#{organisationUserActivityLogList.previousFirstResult}"/>
               </s:link>
              
               <s:link view="/organisation-user-activity-log-list.xhtml" rendered="#{organisationUserActivityLogList.nextExists}"
               value="Next Page #{messages.right}" id="nextPage">
               <f:param name="firstResult" value="#{organisationUserActivityLogList.nextFirstResult}"/>
               </s:link>
              
               <s:link view="/organisation-user-activity-log-list.xhtml" rendered="#{organisationUserActivityLogList.nextExists}"
               value="Last Page #{messages.right}#{messages.right}" id="lastPage">
               <f:param name="firstResult" value="#{organisationUserActivityLogList.lastFirstResult}"/>
               </s:link>
              
               </div>
               </a4j:outputPanel>
               <p/>
              </div>
              
               <SCRIPT LANGUAGE="JavaScript">
              
               function resetForm(form) {
               setValue(form.elements('organisationUserActivityLog:organisationUserId'), '');
               setValue(form.elements('organisationUserActivityLog:action'), '');
               setValue(form.elements('organisationUserActivityLog:description'), '');
               setValue(form.elements('organisationUserActivityLog:ipaddress'), '');
               return false;
               }
               </SCRIPT>
              </ui:define>
              </ui:composition>
              



              • 4. Re: getter method called hundereds of times
                Pete Muir Master

                 

                "terryb" wrote:
                113 calls still seems too many.


                Why?

                • 5. Re: getter method called hundereds of times
                  Terry Apprentice

                  I was just wondering if that is correct behavious? or something caused by how I programmed it. I ccouldn't figure out which process need to call the getter so many times.

                  • 6. Re: getter method called hundereds of times
                    Pete Muir Master

                    JSF doesn't cache the value got from a backing bean - it just invokes the value binding every time. Whether this is the ideal behaviour is up for discussion. So don't put expensive logic in your getter!

                    • 7. Re: getter method called hundereds of times
                      Ronald van Kuijk Master

                      how many results are there in your page?

                      • 8. Re: getter method called hundereds of times
                        Terry Apprentice

                        Pete, thanks for explaining it.

                        kukeltje: just 2 records, for testing purpose.

                        • 9. Re: getter method called hundereds of times
                          Ronald van Kuijk Master

                          just 2 records and then 113 calls? seems a lot to me to, regardles of caching. But I might overlook something.

                          I'll see what happens on my site when I just make a small testcase.

                          • 10. Re: getter method called hundereds of times
                            Terry Apprentice

                            seems that's how jsf works. would be interested to know what you find out.