I'm using Hibernate 3.1 to develop some utilities to work with our Oracle 9 db. We run two databases, a parallel and production version.

Most all of my queries are links on a webpage to a report or lookup. The user has the choice between the parallel or production version.

I have tried creating two configuration files, instantiating both, and setting the local thread to the one desired (passed by parameter). But if I choose DB 1 immediately followed by DB 2, DB 2 immediately creates errors. If I wait till DB 1 is complete, it does not.

I can't find any information about juggling sessions in the tutorial, docs, or in the Hibernate in Action book.

Do I need to find a way to spawn threads for each request so it doesn't rely on a shared session?

I'm using Struts redirect/action to perform the actual HQL.

Thanks. If I screwed up and didn't ask for help properly I do apologize.

Mondo