Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa Hibernate Hibernate DetachedCriteria mutiple results in java
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Cristian Daclangin
Hibernate DetachedCriteria mutiple results in java
0 Answer(s)      a year and 10 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


Advertisement
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
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
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 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
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
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
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
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
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
display database results
display database results  how to display database results using php
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
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
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
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
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
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
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  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 application development Help  Java application developmentHi all, i am new to Java programming and looking for some help to learn it fast.Thanks
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
 

 

 

DMCA.com