Hibernate Community • View topic - IN keyword with list of Strings

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

IN keyword with list of Strings

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

damianharvey

Post subject: IN keyword with list of Strings

Posted: Fri Aug 17, 2007 6:48 am

Beginner

Joined: Thu May 17, 2007 8:37 am
Posts: 22
Location: London

I'm sure this is an easy one.

I've got a list of strings that I want to use as a parameter for a query:

Code:

String[] list = {'A', 'B', 'C'};

entityManager.createQuery("select a from ObjectA as a where a.field IN :list").setParameter("list", list).getResultList();

If I try to use the query as above it throws a org.hibernate.hql.ast.QuerySyntaxException. It doesn't like a parameter being used with the "IN" keyword.

My (nasty) workaround is:

Code:

String list = "('A', 'B', 'C')";

entityManager.createQuery("select a from ObjectA as a where a.field IN "+list).getResultList();

Have I missed something or can you not pass a parameter to an IN?

Thanks,

Damian.

Top

BayK

Post subject:

Posted: Fri Aug 17, 2007 6:51 am

Newbie

Joined: Mon Jul 31, 2006 2:15 am
Posts: 4

try

Code:

String[] list = {'A', 'B', 'C'};

entityManager.createQuery("select a from ObjectA as a where a.field IN (:list)").setParameterList("list", list).getResultList();

yours
klaus

Top

damianharvey

Post subject:

Posted: Fri Aug 17, 2007 7:16 am

Beginner

Joined: Thu May 17, 2007 8:37 am
Posts: 22
Location: London

Thanks.

I'm using Seam which uses the javax.persistence.EntityManager. CreateQuery returns a javax.persistence.Query which doesn't have the setParameterList method.

So if I wanted to use this I could do:

Code:

String[] list = {'A', 'B', 'C'};
Session session = (Session)entityManager.getDelegate();
session.createQuery("select a from ObjectA as a where a.field IN (:list)").setParameterList("list", list).getResultList();

Cheers,

Damian.

Top

thatmikewilliams

Post subject:

Posted: Fri Aug 17, 2007 7:34 am

Expert

Joined: Fri Jul 13, 2007 8:18 am
Posts: 370
Location: london

Try using a List instead of an array.
i.e.

Code:

String[] array = {'A', 'B', 'C'}; 
List list = Arrays.asList(array);
Session session = (Session)entityManager.getDelegate(); 
session.createQuery("select a from ObjectA as a where a.field IN (:list)").setParameterList("list", list).getResultList(); 

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum