Hibernate DetachedCriteria mutiple results in java

Hibernate DetachedCriteria mutiple results in java

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

View Answers









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
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
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
Results
Results After action executes business logic, <result > tag is used to display the View. Struts2 provides or supports to 11 types of Results:ADS... in web application. There are also other ways to render results: Result type
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
ModuleNotFoundError: No module named 'results'
ModuleNotFoundError: No module named 'results'  Hi, My Python... 'results' How to remove the ModuleNotFoundError: No module named 'results... to install padas library. You can install results python with following command
display database results
display database results  how to display database results using php
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
how to pass the mutiple values from <Ui:datagrid hyperlink - JSP-Servlet
how to pass the mutiple values from    I am getting the error when passing the values from this way emp2=${employee.lastName1} & name=${employee.firstName.How to pass the values from hyperlink in column
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
jtable displays search results
jtable displays search results   hi sir can u send me full source code for displaying search results into jtable from database n jtable n search button must be within same frame but in different Panel and the size of the frame
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
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
Show results in HTML
Show results in HTML  Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field table. Actually
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
: 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 Criteria Detached Subquery Example
Hibernate Criteria Detached Subquery Example In this tutorial you will learn how to express a subquery using DetachedCriteria. As you have been read in the previous example Hibernate Criteria Detached Query Subquery Hibernate
ModuleNotFoundError: No module named 'nith-results'
ModuleNotFoundError: No module named 'nith-results'  Hi, My Python... 'nith-results' How to remove the ModuleNotFoundError: No module named 'nith-results' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'results-schema'
ModuleNotFoundError: No module named 'results-schema'  Hi, My... named 'results-schema' How to remove the ModuleNotFoundError: No module named 'results-schema' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'django-results'
ModuleNotFoundError: No module named 'django-results'  Hi, My... named 'django-results' How to remove the ModuleNotFoundError: No module named 'django-results' error? Thanks   Hi, In your python
Example of sorting results in MySQL
Example of sorting results in MySQL  Hi, How to sort the results in MYSQL query? Thanks   Hi, You can use the order by clause in SQL statement to sort the data in ascending or descending orders. Lets consider
What is review of Hibernate in Java?
What is review of Hibernate in Java?  Hi, Is Hibernate really popular? What is review of Hibernate in Java? Thanks
What is review of Hibernate in Java?
What is review of Hibernate in Java?  Hi, Is Hibernate really popular? What is review of Hibernate in Java? Thanks
What is review of Hibernate in Java?
What is review of Hibernate in Java?  Hi, Is Hibernate really popular? What is review of Hibernate in Java? Thanks
display results on same jsp page
display results on same jsp page  is there any method to display search results from database on the same jsp page where i give the inputs using struts 1.2
display results on same jsp page
display results on same jsp page  is there any method to display search results from database on the same jsp page where i give the inputs using struts 1.2
display results on same jsp page
display results on same jsp page  is there any method to display search results from database on the same jsp page where i give the inputs using struts 1.2
java - Hibernate
java  how can we configure many to many relationships in hibernate
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
STRUTS-display search results - Struts
STRUTS-display search results  Hii, I am a beginner in struts..I want to retrieve few records from database and display in jsp page.First i tried... them in jsp.. Search Results
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
Displaying Error pages in results tree in jmeter
Displaying Error pages in results tree in jmeter   Displaying Error pages in results tree in jmeter
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
Hibernate Criteria Nested Properties
Hibernate Criteria Nested Properties Consider the example based on Hibernate Criteria Nested Properties DetachedCriteria detachedCriteria = DetachedCriteria .forClass(Student.class); detachedCriteria.add(Restrictions.eq("name
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
Java assert keyword example  What is the assert keyword? Can anyone explain it with the help of an example
ModuleNotFoundError: No module named 'django-cache-results'
ModuleNotFoundError: No module named 'django-cache-results'  Hi...: No module named 'django-cache-results' How to remove the ModuleNotFoundError: No module named 'django-cache-results' error? Thanks   Hi
ModuleNotFoundError: No module named 'django-celery-results'
ModuleNotFoundError: No module named 'django-celery-results'  Hi...: No module named 'django-celery-results' How to remove the ModuleNotFoundError: No module named 'django-celery-results' error? Thanks   Hi
ModuleNotFoundError: No module named 'djongo-celery-results'
ModuleNotFoundError: No module named 'djongo-celery-results'  Hi...: No module named 'djongo-celery-results' How to remove the ModuleNotFoundError: No module named 'djongo-celery-results' error? Thanks   Hi
ModuleNotFoundError: No module named 'google-search-results'
ModuleNotFoundError: No module named 'google-search-results'  Hi...: No module named 'google-search-results' How to remove the ModuleNotFoundError: No module named 'google-search-results' error? Thanks   Hi

Ads