Hibernate configure 文件

 各种数据库的配置 （sql2000 / mysql / oracle9i）

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>

    <!-- Database connection settings  数据库连接设置-->
    <!-- sql2000 的配置-->
    <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
    <!-- mysql5.0 的配置-->
    <property name="dialect"> org.hibernate.dialect.MySQLDialect</property>
    <!-- orcale9i 的配置-->
    <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>


    <!-- Using FreeTDS Driver sql2000 数据库连接驱动器配置-->
    <property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
    <property name="connection.url">jdbc:jtds:sqlserver://localhost:1433/WeatherReport;tds=8.0;lastupdatecount=true</property>
    <property name="connection.username">sa</property>
    <property name="connection.password"></property>   
    <!-- Using FreeTDS Driver mysql 数据库连接驱动器配置-->
    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="connection.url">jdbc:mysql://localhost:3306/WeatherReport</property>     
      <property name="connection.username">root</property>
      <property name="connection.password">root</property>
    <!-- Using FreeTDS Driver orcale9i 数据库连接驱动器配置-->
    <property name="connection.driver_class">oracle.jdbc.OracleDriver</property>
    <property name="connection.url">jdbc:oracle:thin:@localhost:1521:tct254</property>
    <property name="connection.username">radio</property>
    <property name="connection.password">xiaoxinzhuru</property>

   
    <!-- myeclipse与mysql 的配置-->
    <property name="myeclipse.connection.profile">MySQL</property>


    <!-- JDBC connection pool (use C3P0) 利用这个配置连接池-->
    <property name="connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
    <property name="connection.pool.size">10</property>
    <property name="c3p0.min_size">8</property>
    <property name="c3p0.max_size">20</property>
    <property name="c3p0.timeout">120000</property>
    <property name="c3p0.max_statement">50</property>
    <property name="c3p0.acquireRetryAttempts">0</property>
    <property name="c3p0.acquireRetryDelay">3000</property>
    <!-- 或者 -->
    <property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
    <property name="hibernate.c3p0.max_size">4</property>
    <property name="hibernate.c3p0.min_size">0</property>
    <property name="hibernate.c3p0.timeout">120</property>
    <property name="hibernate.c3p0.max_statements">8</property>
    <property name="hibernate.c3p0.idle_test_period">120</property>
    <property name="hibernate.c3p0.acquire_increment">1</property>


    <!-- Echo all executed SQL to stdout 执行时打印或不打印查询语句（true&false）-->
    <property name="show_sql">false</property>
    <!-- Drop and re-create the database schema on startup 数据库随映射文件改变而改变-->
    <property name="hbm2ddl.auto">update</property>


    <!-- base send gateway need -->
    <!-- easysend need --数据库表的映射文件>
    <mapping resource="com/db/Actually.hbm.xml"/>
</session-factory>
</hibernate-configuration>