Hibernate DetachedCriteria mutiple results in java

Ads

 
 

Share on Google+Share on Google+

Cristian Daclangin
Hibernate DetachedCriteria mutiple results in java
0 Answer(s)      4 years and 9 months ago
Posted in : Hibernate

This is the SQL statement that I have.

SELECT FIRSTNAME, LASTNAME, USERTYPE
FROM USERPROFILE
INNER JOIN USERLOGINSTATUS
ON USERPROFILE.USERID=USERLOGINSTATUS.USERID
ORDER BY USERPROFILE.FIRSTNAME

And I'm trying to execute the code below that I thought the equivalent to hibernate DetachedCriteria and expected to only have two data as a result.

DetachedCriteria dc = getDetachedCriteria();
DetachedCriteria userLoginCriteria = DetachedCriteria.forClass(UserLoginStatus.class);
userLoginCriteria.setProjection(Projections.distinct(Projections.property("userId")));
dc.add(Subqueries.propertyIn(UserField.id.name(), userLoginCriteria));

DetachedCriteria profileCriteria = dc.createCriteria("profile");
profileCriteria.addOrder(Order.asc("firstName"));
return getAll(dc, pageSetting);

But unfortunately this is the unexpected result: I am having a multiple data result.

Name | Type |

1. Ben Jones | User | 2. Ben Jones | User | 3. Tom Homer | Guest | 4. Tom Homer | Guest |

Is anyone there knows the exact equivalent DetachedCriteria or a solution for this?

Many Thanks,

xtian

Ads
View Answers
Ads









Related Tutorials/Questions & Answers:
Hibernate DetachedCriteria mutiple results in java
Hibernate DetachedCriteria mutiple results in java  This is the SQL... the equivalent to hibernate DetachedCriteria and expected to only have two data as a result. DetachedCriteria dc = getDetachedCriteria(); DetachedCriteria
Detachedcriteria in hibernate
Detachedcriteria in hibernate  How to apply detachedcriteria in hibernate for given Query?   Detached Criteria query is a facility provide by Hibernate to write criteria queries in ?detached mode?, where hibernate
Advertisements
Hibernate Criteria :Ordering the results
In this section, you will learn about ordering the results using Hibernate Criteria query
Hibernate Criteria Set Max Results
Hibernate Criteria Set Max Results The set max result of hibernate criteria API is used to fetch the maximum number of at a time Criteria criteria... it will display message as shown below: Hibernate: select this_.roll
Java File Handling Test Results
Java File Handling Test Results   Is somebody able to help me with this Write a program to read each name from the file and prompt the user to enter the percentage for that student at the keyboard. I need to input
count statement that saves results on a variable in a java bean
count statement that saves results on a variable in a java bean  Hello i want to ask you where is the problem and my programme give me only null returns ---> package javalab; import java.sql.*; public class History
count statement that saves results on a variable in a java bean
count statement that saves results on a variable in a java bean  Hello i want to ask you where is the problem and my programme give me only null returns ---> package javalab; import java.sql.*; public class History
mutiple storage of values
mutiple storage of values  i have 3 fields in table i.e street number,house number,colony.Now i want to store these 3 fields into a single field of another table .Name of the field is address. and have to check whether the data
mutiple storage of values
mutiple storage of values  i have 3 fields in table i.e street number,house number,colony.Now i want to store these 3 fields into a single field of another table .Name of the field is address. and have to check whether the data
Java Hibernate
Java Hibernate  Sir, I want to learn hibernate but i don't know JSP. How & from Where i can start to learn hibernate?   Hello Friend, Please go through the following link: Hibernate Tutorials Here you will get
JAVA - Hibernate
: Primary feature of hibernate is to java classes to database tables. Data query... is flexible and powerful ORM solution to map Java classes to database tables. Hibernate...JAVA  hello friends please answer me. 1. what is hibernate...? 2
Hibernate in java - Hibernate
Hibernate in java  Hi, This is Gopi, I am working... and Hibernate). Is there any body who can help me out in my task. All I want is an example in Hibernate. " How to configure a login page (user name and password
java(Hibernate) - Hibernate
java(Hibernate)  Hai Amardeep This is jagadhish.Iam giving full code... will read hibernate.cfg.xml and prepare hibernate for use SessionFactory... for more information. http://www.roseindia.net/hibernate/ Thanks Amardeep
java - Hibernate
java  how can we configure many to many relationships in hibernate
Results
Results After action executes business logic, <result > tag is used to display the View. Struts2 provides or supports to 11 types of Results... other ways to render results: Result type is linked to View. Besides the "type
java - Hibernate
java  HI guys can any one tell me,procedure for executing spring and hibernate in myeclipse ide,plz very urgent for me,thank's in advance.  .../hibernate/runninge-xample.shtml Thanks
java - Hibernate
the code and run using Hibernate and annotation..plse help me...  Hi friend, Read for more information. http://www.roseindia.net/hibernate/hibernateannotations/hibernate-annotations-tutorial.shtml Thanks
java - Hibernate
java  tell me how to configure hibernate in eclipse,where i have to add jar files and how can i get the jar files please tell me the clear...://www.roseindia.net/hibernate/ Thanks
What is hibernate technology in java?
What is hibernate technology in java?  What is hibernate technology in java?   Hibernate: -Hibernate is an Open Source persistence... impedance mismatch problems. For Hibernate detail click here
java - Hibernate
Java application development Help  Java application developmentHi all, i am new to Java programming and looking for some help to learn it fast.Thanks
Java - Hibernate
, this type of output. ---------------------------- Inserting Record Done Hibernate... = null; try{ // This step will read hibernate.cfg.xml and prepare hibernate... for more information . http://www.roseindia.net/hibernate/ Thanks
java - Hibernate
java  hello i am Ramya.... i doing a project on j2ee using hibernate.... i hav created a database name employee... i tat i hav a table something called user.... in tat i hav some three fields lik name , status and... so nw my
java - Hibernate
Java assert keyword example  What is the assert keyword? Can anyone explain it with the help of an example
What is Hibernate in Java?
What is Hibernate in Java? - Hibernate is ORM tool in Java. Are you beginner... Hibernate Framework in Java. The Hibernate in Java is framework used for developing... the complete information about Hibernate framework in Java. There are many different
display database results
display database results  how to display database results using php
How to integrate core java with Hibernate
with Hibernate How to integrate core java with Hibernate   xxxxxxxxx   Please visit the following link: Java with Hibernate The above link will provide you some tutorials of Core Java and Hibernate Integration.  
how to pass the mutiple values from <Ui:datagrid hyperlink - JSP-Servlet
how to pass the mutiple values from      Hi Friend, Please post your full code. Thanks
Hibernate Criteria Detached Subquery Using "Subqueries"
Hibernate Criteria Detached Subquery Using "Subqueries" In this tutorial you will learn how to express a subquery using DetachedCriteria Subqueries. In Hibernate Criteria with the help of DetachedCriteria a query can
Mutiple part is ot working - JSP-Servlet
Mutiple part is ot working  Hi, I have 2 systems and i m using IE7. But in one system when i use enctype="mutlipart" its working but in other system its not working. Is this a problem with the browser or nything else
converting pdf to ps in mutiple languages - Development process
converting pdf to ps in mutiple languages  hi deepak, i want to convert pdf in to ps. These PDF are in hindi format,these pdf are converted in to hindi postscript file with the help of Generic PostScript Printer (default printer
Java Struts - Hibernate
Java Struts  I am trying to do a completed project so that I can keep it in my resume. So can anyone please send me a completed project in struts and hibernate. I will recode it and practice it and attach the same in my resume

Ads

 
Advertisement null

Ads