Hibernate IN query with two parameters

Question

I need to construct a hibernate query that would do something like this:

select p from Person p where (p.name, p.surname) in (('Peter', 'Black'), ('Thomas', 'Peterson'), ('Julia', 'Cook'))

The length of the name/surname list is not defined upfront and the name and surname can contain any characters (the name and surname naming is used just for the illustration purposes)

Also I would like to insert the values as a query parameter to prevent sql injection.

solutions that is not acceptable:

(p.name || '--' || p.surname) in (:mergedNameSurname)

solution that I would like to avoid:

((p.name = :name1 and p.surname = :surname1) or (p.name = :name2 and p.surname = :surname2) ...)

Do you have some idea how this could be done?

Jon · Accepted Answer · 2011-05-20 10:05:28Z

1

I do not think there is a clean Hibernate solution for this. You either take one of the two approaches you suggested or add a denormalized column which represents the concatenation of the two columns. Even with that approach you will end up building something similar to your final query though.

answered May 20, 2011 at 10:05

Jon

5,3776 gold badges33 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hibernate IN query with two parameters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related