Hi,

I have two arrays of values X,Y,Z and 1,2
There is a table A with two columns Name and Place. I want to validate that in table A records with all the combination exists irrespective of duplicates.
e.g.

Table A
--------
X 1
Y 1
Z 1
X 2
Y 2
Z 2

I believe it is not appropriate to fire multiple queries to hibernate for each of these combinations as in future these combinations may grow.

Please suggest some alternate solution which may not cause performance issue on hibernates part.

Thanks in advance.