Hi,

This is my first post here. I'm currently working on a project to create a scheduler using Quartz to schedule a number of jobs. We are using Hibernate for the back-end. However, most of the jobs don't share the same schema and they requires access to different schemas. I'm new to Hibernate and just wondering if there is a way I can configure Hibernate to make each job get a connection to the appropriate schema?

Thanks

Essentially, you'll want to create a new SessionFactory for each schema you have, and programatically peg incoming requests to the right SessionFactory. I'm guessing transactions won't go across multiple databases, right? Like when someone gets a schema, they're stuck with that one for the life of the transaction?

For more complicated scenarios, there is a project called Hibernate Shards that mitigates access to multiple databases through what appears as one session manager.