[jbossseam-issues] [JBoss JIRA] Created: (JBSEAM-4478) seam-gen project generates invalid sql for screens which page data

[Andrew Davie (JIRA)]

seam-gen project generates invalid sql for screens which page data
------------------------------------------------------------------

                 Key: JBSEAM-4478
                 URL: https://jira.jboss.org/jira/browse/JBSEAM-4478
             Project: Seam
          Issue Type: Bug
          Components: EJB3
    Affects Versions: 2.2.0.GA
         Environment: Jboss Developer studio using jboss tools 3.02 running Jboss AS 5.1 on windows XP. Java 1.6.0.17
(Sybase 15, using jconn3.jar)
            Reporter: Andrew Davie


I have created a seam-gen ear project. 

I have correct one issue related to another bug:
https://jira.jboss.org/jira/browse/JBSEAM-4273

The next problem comes when I select a data page to view. If the number of records is small the page displays fine. However for larger data sets the data is paged and this is where it goes wrong.

This is quite possibly a bug in hibernate/seam mix. The following SQL is being generated:
    select
        count((irmotherle0_.idDealer,
        irmotherle0_.idTransaction)) as col_0_0_ 
    from
        FIApps_TST.dbo.irm_OtherLeads irmotherle0_

This is obviously an incorrect SQL statement - at least for Sybase.


-- 
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