各种数据库的配置 (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>
<!-- Echo all executed SQL to stdout 执行时的查询语句记录-->
<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>