title: Multiple database with NHibernate
body: <p>I have two databases. One from Oracle 10g. Another from Mysql. I have configured my web application with Nhibernate for Oracle and now I am in need of using the MySQL database. So how can i configure the hibernate.cfg.xml so that i can use both of the database at the same application?</p>
  
  <p>My current hibernate.cfg.xml is: </p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
  &lt;hibernate-configuration xmlns="urn:nhibernate-configuration-2.2"&gt;
    &lt;session-factory&gt;
      &lt;property name="connection.provider"&gt;NHibernate.Connection.DriverConnectionProvider&lt;/property&gt;
      &lt;property name="connection.driver_class"&gt;NHibernate.Driver.OracleClientDriver&lt;/property&gt;
      &lt;property name="connection.connection_string"&gt;Data Source=xe;Persist Security Info=True;User ID=hr;Password=hr;Unicode=True&lt;/property&gt;
      &lt;property name="show_sql"&gt;false&lt;/property&gt;
      &lt;property name="dialect"&gt;NHibernate.Dialect.Oracle9Dialect&lt;/property&gt;
      &lt;!-- mapping files --&gt;
      &lt;mapping assembly="DataTransfer" /&gt;
    &lt;/session-factory&gt;
  &lt;/hibernate-configuration&gt; 
  </code></pre>