Uploaded image for project: 'Seam 2'
  1. Seam 2
  2. JBSEAM-4478

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

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.2.0.GA
    • Fix Version/s: None
    • Component/s: EJB3
    • Labels:
      None

      Description

      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                atdavie Andrew Davie
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated: