Hi Guys/Gals,

I am kind of new to hibernate, and I want to ask what I feel to be a simple question.

I have an application that needs to make use of 2 separate sybase database residing on the same server. I would like my persistent class Foo to be mapped to a table in database X. Foo would also have a property Bar that is a one-to-one relationship backed by a persistent class mapped to database Y. What is the best way to achieve this? Is there a such thing as perhaps a schema attribute on a mapped class?

Let me know if the problem is not clear.

Thanks in advance for the help.

-Roy

The only place I know of where you specify "schema" as a property, is in the "default_schema".
This means that you specify the schema configuration level, and that you get different sessionfactories/sessions per different configuration.

You can also specify a different schema per mapping file/class. Tou can map the same class to 2 different schemas, changing both the default schema and the entity name (which usually defaults to the class name).