Case-insensitive ordering using Hibernate Criteria.

Case-insensitive ordering using Hibernate Criteria.

What is Case-insensitive ordering in Hibernate Criteria?

View Answers

May 29, 2012 at 6:46 PM

The Case Insensitive ignores the case of the latter. Ordering means you can sort your record either in ascending or descending order By using Hibernate Criteria.

Create hibernate configuration file (hibernate.cfg.xml) and save it in the same folder where you are going to save your source code.

Now create Persistent class Employee.javaâ??Hibernate uses the Plain Old Java Object (POJO) classes to map to the database table. Next create an util class as HibernateUtil.java Here is your MainClass-

Here is a example-

package net.roseindia.main;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import net.roseindia.table.Employee;
import net.roseindia.util.HibernateUtil;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.criterion.Order;

public class MainClass {
    public static void main(String[] args) {
    SessionFactory sessionFactory= HibernateUtil.getSessionFactory();
        Session session = sessionFactory.openSession();

        Criteria criteria =session.createCriteria(Employee.class);
        criteria.addOrder(Order.asc("name"));

        List<Employee> employeeList = new ArrayList<Employee>();
        employeeList = criteria.list();
        Iterator it = employeeList.iterator();

        while (it.hasNext()) {
            Employee employee = (Employee) it.next();
            System.out.println(employee.getName());
        }
        session.close();
    }
}

Output:

Hibernate: select this_.emp_id as emp1_0_0_, this_.date_of_join as date2_0_0_, this_.name as name0_0_, this_.salary as salary0_0_ from employee this_ order by this_.name asc
Mandy
Ron
Roxi
Som

Description : Here we are Sorting records in ascending order by name as â??

criteria.addOrder(Order.asc("name"));

You can also order it in descending order as â??

criteria.addOrder(Order.desc("name"));









Related Tutorials/Questions & Answers:
Case-insensitive ordering using Hibernate Criteria.
Case-insensitive ordering using Hibernate Criteria.  What is Case-insensitive ordering in Hibernate Criteria
Case-insensitive equals using Hibernate Criteria.
Case-insensitive equals using Hibernate Criteria.  How to use Case-insensitive equals with Hibernate Criteria?   The Case Insensitive ignores the case of the latter. It Selects all the records of the table related
Advertisements
Hibernate Criteria Case Insensitive Search.
Hibernate Criteria Case Insensitive Search.  How to use Case Insensitive Search in Hibernate?   The Case Insensitive ignores the case...()); } session.close(); } } Description: - Hibernate criteria is used here
Hibernate Criteria Case Insensitive
Hibernate Criteria Case Insensitive The Case Insensitive ignores the case... = criteria.list(); An example of Case insensitive is given below please consider... parameters Criteria criteria = session.createCriteria(Student.class
Case-insensitive search using Hibernate Query Language(HQL).
Case-insensitive search using Hibernate Query Language(HQL).  What is Case-insensitive search using Hibernate Query Language
Hibernate Criteria :Ordering the results
In this section, you will learn about ordering the results using Hibernate Criteria query
Hibernate Criteria Ordering Example
Hibernate Criteria Ordering Example In this tutorial you will learn about the Hibernate Criteria Projection Ordering. In Hibernate Criteria query to arrange... ordering system I have list the field first using Projections.projectionList
indexof case insensitive java
indexof case insensitive java  Hi, I have to use the indexOf function on String class in Java. I am looking for indexof case insensitive java example. Share the code with me. Thanks (adsbygoogle = window.adsbygoogle
Using sum() in hibernate criteria.
Using sum() in hibernate criteria.  How to calculate sum() in hibernate criteria by using projection?   You can calculate sum of any numeric value in hibernate criteria by using projection. Projection is an interface
Hibernate Criteria Examples
of using Hibernate Criteria query. With the help of criteria query you can... Criteria restrictions Query Example. Hibernate Criteria Ordering Query Example... Hibernate Criteria Count Hibernate Criteria Count Distinct Hibernate Criteria Case
Hibernate: ORDER BY using Criteria API.
Hibernate: ORDER BY using Criteria API.  How to display record in order using Criteria API?   Hibernate Criteria API provides an easy way of building dynamic query on the persistence database. The hibernate criteria
Hibernate criteria query using Max()
Hibernate criteria query using Max()  What is Hibernate criteria query using Max()?   You can find out maximum value in hibernate criteria... in ?org.hibernate.criterion?. For using Projection object in our Criteria, we have to call
Hibernate criteria query using Min().
Hibernate criteria query using Min().  How to find minimum value in Hibernate criteria query using Projection?   You can find out minimum value in hibernate criteria by using projection. Projection is an interface
Hibernate criteria query using avg()
Hibernate criteria query using avg()  How to calculate average in Hibernate criteria query using Projection?   You can calculate average of any numeric values in hibernate criteria by using projection. Projection
ModuleNotFoundError: No module named 'case_insensitive_dict'
ModuleNotFoundError: No module named 'case_insensitive_dict'  Hi...: No module named 'case_insensitive_dict' How to remove the ModuleNotFoundError: No module named 'case_insensitive_dict' error? Thanks   Hi
ModuleNotFoundError: No module named 'case_insensitive_dict'
ModuleNotFoundError: No module named 'case_insensitive_dict'  Hi...: No module named 'case_insensitive_dict' How to remove the ModuleNotFoundError: No module named 'case_insensitive_dict' error? Thanks   Hi
Hibernate criteria example using struts2
Hibernate criteria example using struts2 This hibernate criteria example using struts2 is used for defining the basics of criteria. The hibernate criteria... create query without HQL. In this hibernate criteria example using struts2, we
Hibernate Query Language
be used while using Hibernate. These are Query By Criteria (QBC) and Query BY Example (QBE) using Criteria API and the Native SQL queries. In this lesson we... query language. HQL is much like SQL  and are case-insensitive, except
Case-sensitive equals using Hibernate Criteria.
Case-sensitive equals using Hibernate Criteria.  How to check for case sensitive equals in Hibernate criteria?   package net.roseindia.main... : 220000 Date of Join : 2001-02-03 00:00:00.0 Description : Hibernate Criteria API
Hibernate Criteria Ordering Query Example
Hibernate Criteria Ordering Query Example In this Example, We will discuss about hibernate criteria query, The interface org.hibernate.Criteria is used to create the criterion for the search. In this example we create a criteria
ModuleNotFoundError: No module named 'odoo10-addon-auth-user-case-insensitive'
ModuleNotFoundError: No module named 'odoo10-addon-auth-user-case-insensitive...: ModuleNotFoundError: No module named 'odoo10-addon-auth-user-case-insensitive' How...-case-insensitive' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'odoo11-addon-auth-user-case-insensitive'
ModuleNotFoundError: No module named 'odoo11-addon-auth-user-case-insensitive...: ModuleNotFoundError: No module named 'odoo11-addon-auth-user-case-insensitive' How...-case-insensitive' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'odoo12-addon-auth-user-case-insensitive'
ModuleNotFoundError: No module named 'odoo12-addon-auth-user-case-insensitive...: ModuleNotFoundError: No module named 'odoo12-addon-auth-user-case-insensitive' How...-case-insensitive' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'odoo12-addon-auth-user-case-insensitive'
ModuleNotFoundError: No module named 'odoo12-addon-auth-user-case-insensitive...: ModuleNotFoundError: No module named 'odoo12-addon-auth-user-case-insensitive' How...-case-insensitive' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'odoo13-addon-auth-user-case-insensitive'
ModuleNotFoundError: No module named 'odoo13-addon-auth-user-case-insensitive...: ModuleNotFoundError: No module named 'odoo13-addon-auth-user-case-insensitive' How...-case-insensitive' error? Thanks   Hi, In your python
How to get unique list in Hibernate using Criteria Query?
How to get unique list in Hibernate using Criteria Query?  Hi, Share me the example code for getting Unique List in Hibernate through Criteria Query? Thanks
Hibernate How To
to add ordering ability to in Hibernate Application when using... to serach the result using Hibernate Criteria Finding Unique ResultIn this tutorial you will learn how to find unique result using hibernate criteria
Hibernate Detached Criteria Subquery
In this section we will discuss how to write subqueries using Detached Criteria in Hibernate
Examples of Hibernate Criteria Query
Criteria Case Insensitive Hibernate Criteria Join Hibernate Criteria Join...Example code and running projects of Hibernate Criteria Query Here are examples of Criteria Query in Hibernate and all the examples comes with the running
Hibernate criteria by id.
Hibernate criteria by id.  How to display record by using criteria by id in Hibernate
Hibernate Criteria With Collections Example
Hibernate Criteria With Collections Example  Good code of Hibernate Criteria With Collections Example. Thanks   Example program of using Hibernate Criteria With Collections in your Java project. Check the tutorial
Hibernate-Criteria - Hibernate
Hibernate-Criteria  Hi friends, I am new to hibernate. Im learning it. When im using Criteria im getting exception tht "Criteria cannot... for more information. http://www.roseindia.net/hibernate/hibernate-between
Hibernate criteria average Example
Hibernate criteria average Example   How to find the average... using criteria. For this you have to use Projections.avg() in your program. Check the tutorial Hibernate criteria avg.. Check the Latest tutorials, articles
Criteria in Hibernate
Criteria in Hibernate  What is Criteria in Hibernate?   Criteria is a simplified API for retrieving entities by composing Criterion objects. This is a very convenient approach for functionality like "search" screens
Hibernate criteria disjunction.
Hibernate criteria disjunction.  What is criteria disjunction in hibernate
Hibernate Detached Criteria Example
Hibernate Detached Criteria Example  can anyone share me the source code of using detached Criteria in Hibernate? Thanks   Hi, If you are looking for the Example program of using Hibernate Detached Criteria
Criteria Query Examples in Hibernate
Criteria Query Examples in Hibernate  How to use the Criteria Query in Hibernate? How to select the data using Criteria Query of Hibernate? Thanks... Criteria Query in Hibernate with Examples code. Check the tutorial Criteria Query
Hibernate Criteria And Or Example
Hibernate Criteria And Or Example  Hibernate Criteria And Or Example I want example of Hibernate Criteria And Or in Java Thanks   Example of Hibernate Criteria And Or Criteria Check the tutorial Hibernate Criteria
Hibernate Criteria Or
In this section we are going to discuss Hibernate Criteria Or with example
Hibernate Criteria
In this tutorial we are going to discuss Hibernate Criteria with example
Hibernate criteria delete Example
Hibernate criteria delete Example  How to use the delete criteria in Hibernate? thanks
Hibernate Criteria
the different ways of using the Criteria Query. The Hibernate Criteria API...Hibernate Criteria - Learn the Hibernate Criteria API and master the Hibernate framework The Hibernate Criteria query API is used to selectively find
Hibernate Criteria average example
Hibernate Criteria average example - Learn how to perform Hibernate Criteria... of the Hibernate Criteria API which is used to find the average, maximum or minimum values... you have learned how to find the average using the Criteria Query. Read more
Hibernate Criteria Query Example Program
;In the Hibernate Criteria Query Example You will find the source code of using Criteria...Hibernate Criteria Query Example Program  Hi, I am new in Hibernate and learning the Criteria Query. How to use the Hibernate Criteria Query in my
Hibernate Criteria Count Example
Hibernate Criteria Count Example  Example of Hibernate Criteria Count. Check the tutorial Hibernate Criteria Count. Check the Latest tutorials, articles and examples of Hibernate Framework. Thanks
Hibernate criteria date Example
Hibernate criteria date Example  Example of Hibernate criteria date. Check the tutorial hibernate criteria date. Check the Latest tutorials, articles and examples of Hibernate Framework. Thanks
Hibernate criteria count.
Hibernate criteria count.  How do we count rows using criteria in hibernate?   We can get the rows count using the Projections. My code is like this: Criteria criteria = session.createCriteria(getReferenceClass
Hibernate Criteria And Restrictions Example
Hibernate Criteria And Restrictions Example  How to use Criteria And Restrictions in Hibernate? Thanks   I will provide you the example code of Hibernate Criteria And Restrictions. Check the tutorial Hibernate
Hibernate Criteria Wildcard
Hibernate Criteria Wildcard   How to write Criteria Query in Hibernate that uses the Wildcards?   Hello, Check the example Hibernate Criteria Wildcard. Thanks
What are criteria Queries in Hibernate?
What are criteria Queries in Hibernate?  Just explain me what is Criteria Query in Hibernate with examples? Thanks   Criteria queries are very helpful in hibernate for queries based on certain criteria. Check

Ads