Hibernate session

[jack nick]

Hi there,

This is my first dab at hibernate and have come across a situation wherein

1. i have a collection of POJO objects
2. the object has a property called areaId
3. I need to use this property in query in the where clause with a join with another table.

i can at the moment i can do this in 2 ways

1. use the IN clause in - problem my list can have more than 1000 objects where the query with the IN clause will start complaining
2. create a temporary table and join this temp table in my query - want to avoid this

Is there some way to save this collection of POJO objects into the hibernate session and use this to create a select query with an existing table.

e.g.
select * from table1 t, temp_table tt where t.id = tt.id

I want to avoid using temp_table

cheers
Jack

[Mark Spritzler]

Can you describe a little more about the data and object model. I am a little bit confused. are the ids of the tables already PK/FK relationships that you have mapped? Is the areaid a FK? is areaid mapped to a field in a table?

Thanks

Mark