This week's book giveaways are in the iOS and Features new in Java 8 forums.
We're giving away four copies each of Barcodes with iOS: Bringing together the digital and physical worlds and Core Java for the Impatient and have the authors on-line!
See this thread and this one for details.
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

Win a copy of Barcodes with iOS this week in the iOS forum
or Core Java for the Impatient in the Java 8 forum!

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: 24189

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.
wood burning stoves
subject: getting results from uniqueResult()