Hi

Chapter 9.8. Expressions says that there is a IN clause but how can we use it.
I have something like this and I'd like to use the in clause for a NUMBER field.

String queryString = "select acc from cgix.trust.domain.PtbnAccount as acc where acc.accountId IN =: accountdId";
Query query = session.createQuery (queryString);
query.setParameter("accountId", accountFilter); ???????

Thanks in advance

Use it like this:

where a.ID in (1, 2, 3)

to match all IDs with either a value of "1", "2" or "3".

Just remove the "IN" in your query.

Hello,

You may also use the setParameterList() to specify objects for the in-clause



Kind regards,

Dimitry D'hondt

SQL in clause has a size limit which depends on the database.

What about the HQL in clause ?

We do it like this (building upon your example):

String queryString = "select acc from cgix.trust.domain.PtbnAccount as acc where acc.accountId IN (:accountdIds)";
Query query = session.createQuery (queryString);
query.setParameter("accountIds", accountFilter); //assuming accountFilter is a List object

Keep in mind that you should not pass empty lists since that would result in the following SQL (which is likely not to work):
" ... WHERE xyz IN () ..." (note the empty in-clause).

yeah i was also facing problem to read that now i am cleared in this regard

About the preparedstatements params in the DB. You're right it's DB dependent, normally that limit it's near or beyond of 255 for a single prepared stmts. pdao19 i think that you don't need to worry about this, if you see that this it's giving you somekind of error then you could execute the same query by spliting the parameters that you're using in the "in" clause to avoid it.

Regards,