Hello,

I have a query of this kind:



Now i just want to fetch only the "col2" column's value in my class.Please note that due to some constraints, i cannot change my query to just use col2 in my select clause.


So how can i achieve this ? Any help would be appreciated.


Hibernate version: 3.0.2

Name and version of the database you are using: Oracle 10g

Thanks,
Jignesh

I couldn't get your problem. Execution of query you mentioned will always fetch all columns in select statement. If you are interested in just one column , you can get its value from returned object array.