I hate to ask a question that's already been asked but I did spend quite a bit of time searching the forums before asking this question.

We have a use-case that would require us to use multiple databases (and therefore multiple session factories). What are the drawbacks, if any, to doing this? I ask because it seems like the Hibernate team has some reservations about using multiple session factories or am I just reading into the responses?

Thanks in advance,
Chris

Well you cannot define entity associations between SessionFactories. If you access both within the same use-case you'd probably need 2-phase-commit across the various data stores.

Thanks! I guess you also lose the ability to use the second-level cache too?

Not really.