Double database requests in contactlist
---------------------------------------
Key: JBSEAM-3694
URL:
https://jira.jboss.org/jira/browse/JBSEAM-3694
Project: Seam
Issue Type: Bug
Components: Examples
Affects Versions: 2.0.2.SP1, 2.0.1.GA
Environment: Tomcat 6 / Embedded JBoss
Reporter: Bernard Pons
Any search initiated in contactlist example application generates the same request twice
:
Hibernate:
select
top ? contact0_.id as id4_,
contact0_.address as address4_,
contact0_.businessPhone as business3_4_,
contact0_.cellPhone as cellPhone4_,
contact0_.city as city4_,
contact0_.country as country4_,
contact0_.firstName as firstName4_,
contact0_.homePhone as homePhone4_,
contact0_.lastName as lastName4_,
contact0_.state as state4_,
contact0_.version as version4_,
contact0_.zip as zip4_
from
Contact contact0_
where
lower(contact0_.firstName) like lower((?||'%'))
order by
contact0_.lastName
Hibernate:
select
top ? contact0_.id as id4_,
contact0_.address as address4_,
contact0_.businessPhone as business3_4_,
contact0_.cellPhone as cellPhone4_,
contact0_.city as city4_,
contact0_.country as country4_,
contact0_.firstName as firstName4_,
contact0_.homePhone as homePhone4_,
contact0_.lastName as lastName4_,
contact0_.state as state4_,
contact0_.version as version4_,
contact0_.zip as zip4_
from
Contact contact0_
where
lower(contact0_.firstName) like lower((?||'%'))
order by
contact0_.lastName
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira