[b]Hibernate version:2.1.6

Hi

just a stupid question - I have a table with columns
idclient
uid
...

I'm trying to call

List list = session.createSQLQuery("select {c}.idclient as
{c.idclient} FROM SupClient {c}", "c", SupClient.class).list();

- so I'm interresting about only one column from table
(the true story is much more complicated including
outer join of 4 tables).

The result is exception -
ERROR JDBCExceptionReporter: No such column name

Doesn't matter I'm selecting only one column, Hibernate
is trying to fetch also the next columns (uid, ...) and of course there're no aliases in my sql related to the ones.

Please, any idea?

as per docs (and said many times now ;), currently you can only fetch FULL entity objects with nativesql.

if you want projection sql use raw jdbc.