OpenSessionInViewFilter and multiple sessionfactories?

[melsom]

Hi

My application has to acces two databases (one of them for read operations only). I want to use two sessionfactories for this with different database schemas specified in the hibernate.default_schema property.

I am using struts, spring and hibernate. For lazy loading to work from both databases I want to use the OpenSessionInViewFilter. How do I configure this for multiple sessionfactories?

Thanks!

[Costin Leau]

The easiest solution would be to use one OSIV per session factory (exactly like you would for only one).