Sanne Grinovero the concern, I'm sure, is joining data. Yes having 3 different SessionFactory instances will ultimately work but you'd lose the ability to join. I agree it's a workable solution though.

Personally I'd look at database features to support this - synonyms, etc