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

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