hi,

I am using Hibernate 2.1.7 with DB2 UDB.

I need to execute a SQL Query (in order to use sql functions like COALESCE or CASE ... WHEN .. THEN).

So I tried to use the CreateSQLQuery() statement like this
requete = new StringBuffer()
.append(" select ")
.append(" {declaca0.*} ")
.append(" from DECLAFOU.DECLACA {declaca0} ")
.append(" where {declaca0}.AACC_NUMERO='1' ");
Query quer = session.createSQLQuery( requete.toString(),
new String[] {"declaca0"},
new Class[] {Declaca.class});

It works fine when the request retrieves full managed entity objects.

But when I want to select only few columns, it throws me an "Invalid column name" exception.

Maybe i don't use createSQLQuery in the rigth way. Or maybe there is an easiest way to execute SQL select directly (with callBacks??).

I read in this forum that it is possible to addScalar to the query but I can't find this method in the Query class.

In fact, i am a bit lost :-((

Thx in advance for any help

The manual says:


That is, for each column you want to use in the SQL command, you must alias the property so that hibernate put the real column name taken from mapping.

Let's say column AACC_NUMERO is mapped in property 'numero', then you'll have: