[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-962) org.hibernate.dialect.IngresDialect no longer works with paged queries

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole closed HHH-962.
------------------------------


Closing stale resolved issues

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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira