How to return int from query?

Question

I have this method in my dao implementation, and im trying to return int from the query and put it in the roomNumber int variable, but im not sure if it`s the right syntax... and probably there are other errors. In debug mode i see that the int roomNumber field doesnt get any value, its value is 0 when i step over it.

@Override
    public int getRoomNumber(int bookingId) {
        Session session = sessionFactory.getCurrentSession();

        Query query = session.createQuery("select room.roomId from Booking where bookingId=:bookingId");

        query.setParameter("bookingId", bookingId);

        int roomNumber = query.getFirstResult();

        return roomNumber;
    }

Booking table in db:

for the query i have tried also this:

select room_room_id from Booking where bookingId=:bookingId

Community · Accepted Answer · 2017-05-23 11:53:29Z

2

For these purposes there is method uniqueResult():

int roomNumber = ((Number)query.uniqueResult()).intValue();

EDIT: if you use hibernate version > 5.2.2 you possibly will want change this to method getSingleResult():

Hibernate UniqueResult Deprecated

edited May 23, 2017 at 11:53

CommunityBot

11 silver badge

answered Feb 11, 2017 at 13:35

Andremoniy

35.2k25 gold badges143 silver badges259 bronze badges

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

3 Comments

john Over a year ago

Thanks for your help... just a quick question, im getting a warning about uniqueResult(): "The method uniqueResult() from the type Query is deprecated" - this won't be a problem?

Andremoniy Over a year ago

Oh, you are using Hibernate 5.x.x, right? I thought it is version < 5. Please see my updated answer

john Over a year ago

Thanks for the follow up answer.

Collectives™ on Stack Overflow

How to return int from query?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related