How do you specify OrderBy clause on two columns

hibernate jpa seam
Sam picture Sam · Oct 18, 2010 · Viewed 17.5k times · Source

We would like to orderBy 2 columns in the Seam EntityQuery interface as well as the JPA model. How do we do this?

@Entity
public class A{

@OrderBy(???) // should this be hardcoded here, is it database agnostic
List<B> bobjects;
}

@Entity
public class B {

   public short startTimeHrs;
   public short startTimeMins;
}

@Name("bList")
public class B extends EntityQuery {
        setOrderColumn("startTimeHrs, startTimeMins"); // Is this correct?
        setOrderDirection("asc");
}

Answer

Shervin Asgari picture Shervin Asgari · Oct 18, 2010

Yes you can use @OrderBy to order your queries.

@OrderBy("startTimeHrs, startTimeMins")
@OneToMany(...)
getBobjects() {
   return bobjects;
}

Now whenever you are saying A.getBobjects() they will be ordered. However, if you are using the EntityQuery way of retrieving the result you can override the getEjbql() and put the order by there.

@Name("bList")
public class B extends EntityQuery {
    @Override
    public String getEjbql() {
          return "select b from B b order by startTimeHrs, startTimeMins";
    }
}

Or you can @Override the getResultList() to manipulate the collection there in your entityLists

Related questions

Force refresh of collection JPA entityManager

I am using SEAM with JPA (implemented as a Seam Managed Persistance Context), in my backing bean I load a collection of entities (ArrayList) into the backing bean. If a different user modifies one of the entities in a different …

Read More
How to externalize properties from JPAs persistence.xml?

I would like to put some of the hibernate configuration in a property file to make it editable without build and deploy. I tried to solve my problem by following the instructions from Create JPA EntityManager without persistence.xml configuration …

Read More
Hibernate/JPA - Entity listener not being called properly

I'm trying to leverage EntityListener objects and callback methods within my Seam/Hibernate/JPA application. I'm using a Seam 2.2-managed persistence context on JBoss 5.1 with PostgreSQL 9.1 on the backend. I have the following entity declared: @Entity(name = "TestEntity") @EntityListeners(TestCallback.…

Read More