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
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?
0
