How can I define multiple sessionfactory instances in Spring?-Collection of common programming errors

I don’t know of an easy solution for your problem using Spring.

However, you could be able to use Hibernate Interceptors, provided that your particular databases/data-sources can be reached through one master/admin database connection. This blog post explains how in detail, but the gist of it is to dynamically replace table names in SQL statements that Hibernate generates, with qualified names identifying different databases. This is relatively easy to understand and maintain, and works well in my company’s multi-tenant set-up.

Apart from that, you can try writing your own TransactionManager, using the HibernateTransactionManager as a starting point, adding support for working with multiple session factories. However, this would mean you having to really dive into Spring ORM support internals, and that is something I tried, but then scrapped in favor of the first approach. I’m sure it can be done with moderate effort, but the previous solution was already doing the job for us.