Hi all,

Our java application, deployed at Weblogic 10.3.3, is running at Ingres 9.2 using Hibernate 3.3.1. We have decided to upgrade the database version from Ingres 9.2 to 10.2. The jdbc driver of the the new Ingres has been installed to the application server. However the following error is thrown

Hibernate: select ie904messa0_.CD904A_ID as CD1_117_, ie904messa0_.HEADER_FK as HEADER7_117_, ie904messa0_.MESSAGE_FK as MESSAGE8_117_, ie904messa0_.AAD_REFERENCE_CODE as AAD2_117_, ie904messa0_.MESSAGE_TYPE_FK as MESSAGE9_117_, ie904messa0_.MOVEMENT_HISTORY_INDICATOR as MOVEMENT3_117_, ie904messa0_.SEQUENCE_NUMBER as SEQUENCE4_117_, ie904messa0_.STATUS_FK as STATUS5_117_, ie904messa0_.STATUS_REQUEST_MESSAGE_TYPE as STATUS6_117_ from T_CD904A ie904messa0_ where ie904messa0_.AAD_REFERENCE_CODE=char(?) and ie904messa0_.SEQUENCE_NUMBER=char(?) order by ie904messa0_.CD904A_ID desc
108204 DataServiceBean - retrieveAAD() - finish
108208 DataServiceBean - retrieveNotification(15IEI7PXO7NX00020WD52) - start
108216 SqlExceptionHelper - SQL Error: 2184, SQLState: 5000A
108224 SqlExceptionHelper - Sort column or expression not found in select list of distinct or grouped query.
108275 DefaultLogger - LogEvent[
DATE=10-06-2015 14:17:43,
ARC=Undefined,
LEVEL=ERROR,
SOURCE=class retrieveLatestAlertOrRejectionMessage,
COMMENTS=javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Sort column or expression not found in select list of distinct or grouped query.,
ERRORTYPE=SYSTEM,
IDENTIFIER=null,
KEY=null,
STATE=null,
ACTOR=System,

We performed some experiments with Hibernate Editions that implement JPA 2 using the Ingres10Dialect but the error persists.

Any ideas