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 javaHibernate 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 hibernateDetachedcriteria 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 Set Max ResultsHibernate 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 valuesmutiple 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 valuesmutiple 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
ResultsResults
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
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
Mutiple part is ot working - JSP-ServletMutiple 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
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 - HibernateHibernate 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 HibernateJava 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 HTMLShow
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) - Hibernatejava(
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 ExampleHibernate 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 Example of sorting results in MySQLExample 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
display results on same jsp pagedisplay
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 pagedisplay
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 pagedisplay
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 - Hibernatejava how can we configure many to many relationships in
hibernate java - Hibernatejava 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 - StrutsSTRUTS-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 - Hibernatejava 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, 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 - Hibernatejava 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 PropertiesHibernate Criteria Nested Properties
Consider the example based on
Hibernate Criteria Nested Properties
DetachedCriteria detachedCriteria =
DetachedCriteria
.forClass(Student.class);
detachedCriteria.add(Restrictions.eq("name
java - HibernateJava application development Help
Java application developmentHi all, i am new to
Java programming and looking for some help to learn it fast.Thanks
java - HibernateJava assert keyword example What is the assert keyword? Can anyone explain it with the help of an example