Hello,

I have following situation:
Users table is on one mysql server in Users database, and user profiles table is
on another mysql server in UserProfiles database so i have two tables in two
different databases on two different servers (machines).
Mapping file for users table is users.xml and for user profiles table is
userProfiles.xml. In userProfiles.xml i have many to one association to user table like:
<many-to-one name="user" class="User" lazy="proxy" fetch="select" property-ref="userId">
<column name="UserID" not-null="true" />
</many-to-one>

Is this supported by hibernate?

I know that i can use two separate session factories and create two separate sessions to work
with this two databases but i don't want to have both tables on both databases.