File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes getting results from uniqueResult() Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "getting results from uniqueResult() " Watch "getting results from uniqueResult() " New topic

getting results from uniqueResult()

Aaron Parker

Joined: Jan 31, 2004
Posts: 27
How do I get results out of the uniqueResult() method of the Query class. I can get a result into it, but I can't find anything that explain how to get stuff out!

Object results;
results = query.uniqueResult();

PS to moderator, I posted this in Servlets, too as that's what I'm working with, but was unsure where to post.

Ernest Friedman-Hill
author and iconoclast

Joined: Jul 08, 2003
Posts: 24199

I had to Google "uniqueResult Query Java" to find out that you were talking about Hibernate. We've actually got a whole forum dedicated to Hibernate and its cousins here. I'm going to move this post there, and I'm sure then you'll get an answer.

[Jess in Action][AskingGoodQuestions]
David Harkness
Ranch Hand

Joined: Aug 07, 2003
Posts: 1646
I haven't used Hibernate's Query objects yet, but from the JavaDocs I gather it's similar to the "getFirst(List)" method I wrote for our DAOs.
Convenience method to return a single instance that matches the query, or null if the query returns no results.
This is used when the query you are issuing is expected to return a single object/value.

For example, if you have defined and mapped a Person class with a unique "name" attribute, querying for a Person with a given name will always return zero or one result. In this case you don't want to have to get a List back and extract the first element from it. Query.uniqueResult() will do this for you.

Simply cast the result to the class for which you are querying, Person in this example.
I agree. Here's the link:
subject: getting results from uniqueResult()
It's not a secret anymore!