Hibernate Community • View topic - Simple string names retrieving

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Simple string names retrieving

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

f_terlizzi

Post subject: Simple string names retrieving

Posted: Mon Jul 25, 2005 10:33 am

Newbie

Joined: Mon Jul 25, 2005 10:29 am
Posts: 1

I look for a simple example on how to retrieve a List of userNames from a User object (mapped to an Oracle 9 DB). What method has the best performances to retrieve only a List of strings (I have to populate a Struts html:options tag with these names)? I have to use, query, criteria, example or other?

Thank you very much.

Top

sven

Post subject:

Posted: Mon Jul 25, 2005 10:44 am

Expert

Joined: Thu Dec 04, 2003 12:36 pm
Posts: 275
Location: Bielefeld, Germany

Code:

Query query = session.createQuery("SELECT u.name FROM User u");
List names = query.list();

Of course, you could also use hand-written SQL, but there will probably be no performance boost for such a simple example.

Best regards
Sven

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