• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate session

 
jack nick
Ranch Hand
Posts: 96
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic