hibernate with two schemas

[chiranjeevi gunturu]

hi all,
I have a problem with hiberante query.i have two schemas in my database A,B and i have two hibernate queries with me. i have to fire the first query on a table of schema A. Based on the result that i got ,i have to fire the second query on a table of schema B.

Is it necessary to have two sessions for this .if so please tell me how to use two sessions?

Thank you,
chiranjeevi

[Chandima Janakantha]

You should be able to do this in the same session. after executing the first query use
session.flush(); to load the results for the query.