activerecord 配置(-) 不同数据库配置

<?xml version="1.0" encoding="utf-8"?>
<activerecord isWeb="true">

  <!--  MS SQLServer-->
  <add key="hibernate.connection.driver_class" value="NHibernate.Driver.SqlClientDriver" />

  <add key="hibernate.dialect" value="NHibernate.Dialect.MsSql2000Dialect" />

  <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />

  <add key="hibernate.connection.connection_string" value="Data Source=.;Initial Catalog=test;UID=sa;Password=sa" />

  <!--   MS Oracle-->
  <config type="Unionstars.PDC.BLL.PDCAcitiverBase,Unionstars.PDC.BLL">
    <add key="hibernate.connection.driver class" value="NHibernate.Driver.OracleClientDriver"/>
    <add key="hibernate.dialect" value="NHibernate.Dialect.OracleDialect"/>
    <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
    <add key="hibernate.connection.connection_string" value="Data Source=oraclefx;User ID=fxf;Password=fxf5584478;"/>
  </config>
  <!--   MS SQLServer-->

  <config>

    <add key="hibernate.connection.driver_class" value="NHibernate.Driver.SqlClientDriver" />

    <add key="hibernate.dialect" value="NHibernate.Dialect.MsSql2000Dialect" />

    <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />

    <add key="hibernate.connection.connection_string" value="Data Source=.;Initial Catalog=test;UID=sa;Password=sa" />

  </config>

  <config>

    <add key="hibernate.connection.driver_class" value="NHibernate.Driver.FirebirdDriver" />

    <add key="hibernate.dialect" value="NHibernate.Dialect.FirebirdDialect" />

    <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />

    <add key="hibernate.connection.connection_string" value="Server=localhost;Database=d:/db.fdb;User=SYSDBA;password=masterkey;ServerType=1;Pooling=false" />

    <add key="hibernate.query.substitutions" value="true 1, false 0" />

  </config>
  <!--Firebird -->
  <config>

    <add key="hibernate.connection.driver_class" value="NHibernate.Driver.FirebirdDriver" />

    <add key="hibernate.dialect" value="NHibernate.Dialect.FirebirdDialect" />

    <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />

    <add key="hibernate.connection.connection_string" value="Server=localhost;Database=d:/db.fdb;User=SYSDBA;password=masterkey;ServerType=1;Pooling=false" />

    <add key="hibernate.query.substitutions" value="true 1, false 0" />

  </config>
<!--PostgreSQL
-->
  <config>

    <add key="hibernate.connection.driver_class" value="NHibernate.Driver.NpgsqlDriver" />

    <add key="hibernate.dialect" value="NHibernate.Dialect.PostgreSQLDialect" />

    <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />

    <add key="hibernate.connection.connection_string" value="Server=localhost;initial catalog=nhibernate;User ID=nhibernate;Password=nhibernate;" />

  </config>

</activerecord>

 

传自：http://terrylee.cnblogs.com/archive/2006/04/05/367381.html