Folks,

I did not knwo where else to post my question..and in case this is not
the forum for these kind of things, please point me to the correct
direction..

Now to my question,

I have a requirement where i wil have to pass in a List of values to a
a db table for lookup.. i mean,

i have a table  MY_TABLE on Oracle 9i, and the primary key is
MY_TABLE_ID and there are a few other fields, MY_NAME, MY_ADDRESS in
that as well.
i need to query this table for a variable list of MY_TABLE_IDs. How do
i do that in Hibernate ??

select * from MY_TABLE
where MY_TABLE_ID = any (my_table_id1, my_table_id2)

my_table_id1 and my_table_id2 are coming from my app, and this lenght
is also variable.. i might have just 1 id to pass to or more than 1.

any help in this regard is greatly appretiated...

thanks
-CD