Return a string result from a named query in hibernate

Question

How to return String type result in a named query which is of type Query.... the code i tried

public String getTargetEmail(){
    Query query= em.createNamedQuery("BC_READ_SYSTEM_PROPERTIES_BY_NAME");
    return (String)query.toString();
}

but this return something else like org.hibernate.ejb.QueryImpl@3e4d072b

dimcookies · Accepted Answer · 2012-12-31 13:25:18Z

3

Calling toString on Query object, you just get a string representation of it. You need actually to execute the query like this

return (String) query.getSingleResult();

Ensure that the query always returns only one result, otherwise calling getSingleResult, will throw a NonUniqueResultException exception in case more one result that one is returned, or NoResultException in case no result is returned (check documentation here)

edited Dec 31, 2012 at 13:25

answered Dec 31, 2012 at 13:03

dimcookies

1,9307 gold badges31 silver badges37 bronze badges

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

1 Comment

dimcookies Over a year ago

If your query returns multiple rows you should use getResultList instead

Collectives™ on Stack Overflow

Return a string result from a named query in hibernate

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