Connect to multiple database schemas using hibernate

kbpkumar · **Joined:** Mon Jul 30, 2007 12:32 pm **Posts:** 1

Hi
I am using Hibernate in my project, currently my application connecting to one database schema, according to my new requirement, for some requests I have to connect to some other database schema. I am using single sessionfactory and pulling it from a JNDI tree and database properties are configured in build.properties.xml.

please anyone help me to accomplish this. Thanks in advance

Javaprogrammer · **Posted:** Mon Jul 30, 2007 10:35 pm

You can use the schema key.

Code:

<hibernate-mapping package="mypackage">
  <class name="Template" table="Templates" schema="mySchema">
    <id name="id" type="long" column="id">
      <generator class="native"/>
    </id>
    <property name="width" type="long" column="Width" not-null="true" />

</hibernate-mapping>

in another hbm.xml file you specify another schema. This works if the schemas are in the same server. If there are different servers please search for it on this forum

msj4u · **Joined:** Wed Apr 25, 2007 11:44 pm **Posts:** 59

can you further elaborate it using hibernate docs

moreover is there any working example for this also for the schemas on the different servers