JPQL IN clause: Java-Arrays (or Lists, Sets...)?

Posted by Bernd Haug on Stack Overflow See other posts from Stack Overflow or by Bernd Haug
Published on 2010-05-05T10:21:55Z Indexed on 2010/05/08 10:28 UTC
Read the original article Hit count: 997

Filed under:

jpql

|

jpa

|

named-query

|

sql

|

orm

I would like to load all objects that have a textual tag set to any of a small but arbitrary number of values from our database. The logical way to go about this in SQL would be to build an "IN" clause. JPQL allows for IN, but it seems to require me to specify every single parameter to IN directly (as in, "in (:in1, :in2, :in3)").

Is there some way to specify an array, or a list (or some other container) that should be unrolled to the values of an IN clause?

© Stack Overflow or respective owner

Related posts about jpql

Are there date functions available in jpql?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I want to write query something like :- Select u from bookmaster u order by Year(b.createDate),Month(b.createDate),day(b.createDate) How do i do this in JPQL? Are there any date parsing functions available? >>> More
Help with JPQL query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have to query a Message that is in a provided list of Groups and has not been Deactivated by the current user. Here is some pseudo code to illustrate the properties and entities: class Message { private int messageId; private String messageText; } class Group { private String groupId; … >>> More
JPQL (JPA) search substring

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, Im facing simple problem with searching entities by some (sub)string, which they might contain. E.g. I have users user1, usr2, useeeer3, user4 and I will enter to search window "use" and I expect to return user1, useeer3, user4. Im sure you know what I mean now. Is there any construction in… >>> More
Java: JPQL date function to add a time period to another date

as seen on Stack Overflow - Search for 'Stack Overflow'
SELECT x FROM SomeClass WHERE x.dateAtt BETWEEN CURRENT_DATE AND (CURRENT_DATE + 1 MONTH) In the above JPQL statement, SomeClass has a memebr dateAttr, which is a java.util.Date and has a @Temporal(javax.persistence.TemporalType.DATE) annotation. I need a way to do the (CURRENT_DATE + 1 MONTH)… >>> More
How do i write this jpql query?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, Say i have 5 tables, tblBlogs tblBlogPosts tblBlogPostComment tblUser tblBlogMember BlogId BlogPostsId BlogPostCommentId UserId BlogMemberId BlogTitle BlogId CommentText FirstName UserId PostTitle BlogPostsId… >>> More

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