Dynamic JPA 2.0 query using Criteria API

Posted by rrrrrrrrrrrrr on Stack Overflow See other posts from Stack Overflow or by rrrrrrrrrrrrr
Published on 2010-03-24T17:45:18Z Indexed on 2010/03/25 12:13 UTC
Read the original article Hit count: 500

Filed under:

jpa

|

criteria-api

|

dynamic

Hello all,

I am a bit stucked constructing a dynamic query using the CriteriaBuilder of JPA 2.0.

I have quite a common use case I guess: User supplies a arbitrary amount of search parameters X to be and / or concatenated: like :

select e from Foo where (name = X1 or name = X2 .. or name = Xn )

The Method or of CriteriaBuilder is not dynamic:

Predicate or(Predicate... restrictions)

Ideas? Samples?

© Stack Overflow or respective owner

Related posts about jpa

Detach an entity from a JPA persistence context (JPA 2.0 / Hibernate / EJB 3 / J2EE 6)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I wrote a stateless EJB method allowing to get an entity in "read-only" mode. The way to do this is to get the entity with the EntityManager then detach it (using the JPA 2.0 EntityManager). My code is the following: @PersistenceContext private EntityManager entityManager; public T getEntity(int… >>> More
AndroMDA maven code generation and JPA Annotations

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using the AndroMDA plugin for maven to generate code from an uml diagram made in MagicDraw. When the code is generated, AndroMDA desings the JPA annotation for the persitence layer. I think that at the compilation process AndroMDA uses Naming Strategies to determine the Table and Column names… >>> More
How to populate Java (web) application with initial data using Spring/JPA/Hibernate

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to setup my database with initial data programmatically. I want to populate my database for development runs, not for testing runs (it's easy). The product is built on top of Spring and JPA/Hibernate. Developer checks out the project Developer runs command/script to setup database with initial… >>> More
Eclipselink problem in a javase project

as seen on Stack Overflow - Search for 'Stack Overflow'
I am getting this error when I am running my eclipselink project. [EL Warning]: 2008.12.05 11:47:08.056--java.lang.NoClassDefFoundError: org/jboss/resource/adapter/jdbc/ValidConnectionChecker was thrown on attempt of PersistenceLoadProcessor to load class com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker… >>> More
JPA thinks I'm deleting a detached object

as seen on Stack Overflow - Search for 'Stack Overflow'
So, I've got a DAO that I used to load and save my domain objects using JPA. I finally managed to get the transaction stuff working (with a bunch of help from the folks here...), now I've got another issue. In my test case, I call my DAO to load a domain object with a given id, check that it got… >>> More

Related posts about criteria-api

Using NHibernate Criteria API to select sepcific set of data together with a count

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following domain set up for persistence with NHibernate: I am using the PaperConfiguration as the root aggregate. I want to select all PaperConfiguration objects for a given Tier and AcademicYearConfiguration. This works really well as per the following example: ICriteria criteria = session… >>> More
Dynamic JPA 2.0 query using Criteria API

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all, I am a bit stucked constructing a dynamic query using the CriteriaBuilder of JPA 2.0. I have quite a common use case I guess: User supplies a arbitrary amount of search parameters X to be and / or concatenated: like : select e from Foo where (name = X1 or name = X2 .. or name = Xn ) The… >>> More
Hibernate. Convert HQL to Criteria API

as seen on Stack Overflow - Search for 'Stack Overflow'
How to convert the following hql to Criteria API var criteria = this.Session.CreateQuery("select m, m.Attachments.size from AdvanceMessage m"); ? Thanks >>> More
JPA 2 in Jboss and criteria api

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a working JPA 2 implementation for JBoss server? Or maybe there is some additional extension that provides JPA 2's criteria api equivalent? >>> More
NHibernate.Linq to Criteria API translation help needed

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm not sure how to add paging to this: Session.Linq<Article>() .Where(art => art.Tags.Any(t => t.Name == tag)).ToList(). So i decided to use Criteria API. var rowCount = Session.CreateCriteria(typeof(Article)) .SetProjection(Projections.RowCount()).FutureValue<Int32>(); var… >>> More