Java query db issues. using hibernate and struts2

Question

I am getting into java here. Fun and frustrating all at the same time :)

I have a simple method called showUsernames():

public String showUsernames(){
    TimesheetUserDAO su = new TimesheetUserDAO();
    Session session = su.getSession();
    setUsers(su.findByUsername(_users));
    session.close();
    return SUCCESS;
}

...however, I am having a time getting just the usernames out of the database. It is possible with the Hibernate DAO to get this correct? I am able to use su.findAll() and return everything.

Any thoughts? Need more code? Thanks :)

JB Nizet · Accepted Answer · 2011-10-03 21:44:19Z

1

The DAO probably executee a request like

select u from User u where ...

Change the query to

select u.name from User u where ...

Of course, instead of having a List<User> as a result, you'll have a List<String>.

This is basic stuff described in the Hibernate reference documentation. Have you read it?

Also, getting the session from the DAO and closing it manually like this shows a design problem. This should be encapsulated by the service layer or, even better, by the declarative transaction handling.

answered Oct 3, 2011 at 21:44

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jasonflaherty Over a year ago

Thanks for the note. I'll read over the documentation some more.

Collectives™ on Stack Overflow

Java query db issues. using hibernate and struts2

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related