Returning a single (object , row, or column)

zulufire · **Joined:** Thu Jul 27, 2006 10:35 am **Posts:** 16

Hi All

I am using Hibernate version2.

I am currently using HQL , Criteria & createSQLQuery to fetch data.
What I observed is all these return List & never a single object.

From the calling client I have to unnecessarily sift through a list even when I know the underlying query is going to return only 1 instance.

Does any one have a solution to avoid retreiving from a list

Regards,

pepelnm · **Posted:** Thu Aug 10, 2006 8:16 am

From Hibernate API documentation:

Interface Query

Code:

public Object uniqueResult()

Convenience method to return a single instance that matches the query, or null if the query returns no results.
Returns: the single result or null.

I've used it and it works.

Don't forget to rate me if I helped you.

zulufire · **Joined:** Thu Jul 27, 2006 10:35 am **Posts:** 16

I reckon this is available with Hibernate version 3.

How can I do the same with Hibernate version2

CWitherow · **Posted:** Thu Aug 10, 2006 1:33 pm

H2 supported .uniqueResult() (at least later revisions)

Curtis ...