HQL error : could not execute query

zomurn · **Joined:** Wed Jul 15, 2009 1:47 pm **Posts:** 4

Hi,

Can you tell me why this HQL is wrong :

Code:

<query name="FluxDao.getLast">
      select f from Flux f where f.id = (select max(f.id) from f where f.courrier.nodeRefId=:courrier_nid)
     </query>

And the calling method :

Code:

HibernateCallback getLastCallback = new HibernateCallback() {

         public Object doInHibernate(Session session) {

            Query query = session.getNamedQuery( "FluxDao.getLast" );
            query.setString( "courrier_nid", pNodeRefId );
            return query.uniqueResult();
         }
      };
      Flux lFlux = (Flux) ht.execute( getLastCallback );

Help me please for the syntax error.

wolli · **Posted:** Wed Jul 22, 2009 7:17 am

You're using the same alias in the query and the subquery. Try to use f1,f2 or f, ff ...

zomurn · **Joined:** Wed Jul 15, 2009 1:47 pm **Posts:** 4

Absolutely right !

Thank you very much :)