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