Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 2.1.7

hello,

I tried createSQLQuery with select * from a
and it works, i get all the attributes.

When I try to get a single attribute,
I get invalid colum name.

is this supported.
can createSQLQuery return a single attribute...?

if answer is yes..., then can we use it run, group by, count
etc sql queries...?

really appreciate your answer..
thanks,
reagrds

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

its in docs.

h2: no
h3: yes