[jbossseam-issues] [JBoss JIRA] Created: (JBSEAM-3694) Double database requests in contactlist

[Bernard Pons (JIRA)]

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