Can I use more than one database at the same time?

For exemple, my hibernate.cfg.xml below:

<hibernate-configuration>

<session-factory name="MySQL">
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost/seb</property>
<property name="hibernate.connection.username">username</property>
<property name="hibernate.connection.password">passw</property>

<property name="hibernate.show_sql">true</property>
<property name="hibernate.format_sql">true</property>

<property name="c3p0.min_size">20</property>
<property name="c3p0.max_size">75</property>
<property name="c3p0.timeout">180</property>
<property name="c3p0.maxIdletime">300</property>
<property name="c3p0.idle_test_period">100</property>
<property name="c3p0.max_statements">0</property>

<mapping class="br.com.schneider.sistemas.modelo.Usuario" />

</session-factory>

<session-factory name="Oracle">
<property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
<property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property name="hibernate.connection.url">jdbc:postgresql://localhost/mydatabase</property>

<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">paswd</property>

<property name="hibernate.show_sql">true</property>
<property name="hibernate.format_sql">true</property>

<property name="c3p0.min_size">20</property>
<property name="c3p0.max_size">75</property>
<property name="c3p0.timeout">180</property>
<property name="c3p0.maxIdletime">300</property>
<property name="c3p0.idle_test_period">100</property>
<property name="c3p0.max_statements">0</property>
</session-factory>
</hibernate-configuration>

Hi

sure you can.


please see this

http://forum.hibernate.org/viewtopic.ph ... 28#2360128

Amila

(Don't forget to rate if helps)

Hi Amila,

Ok, but in my exemple I'll use two differents database, Postgree and MySQL. How the Hibernate will know persist the correct class at the correct database?

Thanks!!