Hibernate Community • View topic - Looking for a feature like ResultSet.getString("colName

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Looking for a feature like ResultSet.getString("colName

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

j.gohel

Post subject: Looking for a feature like ResultSet.getString("colName

Posted: Tue Oct 23, 2007 8:49 am

Newbie

Joined: Fri Apr 13, 2007 10:58 am
Posts: 10

Hello,

I have a query of this kind:

Code:

select col1, col2,col3
from tab1
where <my-filters>

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

Top

sethrohit1977

Post subject:

Posted: Tue Oct 23, 2007 10:19 am

Regular

Joined: Mon Jan 22, 2007 10:32 am
Posts: 101

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.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum