CODEWITHSUNDEEP
hibernatenamed-query
Lucky
Lucky

Reputation: 17365

Return a string result from a named query in hibernate

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

Upvotes: 1

Views: 8698

Answers (1)

dimcookies
dimcookies

Reputation: 1930

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)

Upvotes: 3

Related Questions