org.hibernate.dialect.IngresDialect no longer works with paged queries ---------------------------------------------------------------------- Key: HHH-962 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-962 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.1 rc3 Environment: JBoss 4.0.3RC2, EJB3RC2, Java1.5_04, Ingres 3.0.2, WinXP Reporter: Stefan Lindner Attachments: IngresDialectFix.patch Thsi issue is related to the Ingres support of EJB/Hibernate 3.1 Beta 3 The following code fragment worked with EJB Beta1 Query q = manager.createQuery("Select org FROM OrganisationBean org"); query.setMaxResults(1); OrganisationBean ob = (OrganisationBean)(query.getSingleResult()); It does not work anymore with EJB3RC1/RC2. The error messge now is javax.ejb.EJBTransactionRolledbackException = null; CausedByException is: paged queries not supported My dialect is set to org.hibernate.dialect.IngresDialect <property name="hibernate.dialect" value="org.hibernate.dialect.IngresDialect" /> When I change the dialect to org.hibernate.dialect.GenericDialect the code works again with EJB3RC1+RC2. This means 1, Ingres supports paged queries 2. The dialect org.hibernate.dialect.IngresDialect properly managed paged queries in EJB3Beta1 3. The dialect org.hibernate.dialect.IngresDialect does not handle this correct anymore.