Hibernate在不同数据库中配置

hibernate.cfg.xml

利用SQL数据库：

 

<?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">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>
<session-factory >
<!--数据库JDBC驱动类-->
        <property name="hibernate.connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>
<!--数据库密码-->
        <property name="hibernate.connection.password"></property>
     <!--数据库的URL-->
        <property name="hibernate.connection.url">jdbc:microsoft:sqlserver://localhost:1433;databaseName=demo</property>
     <!--数据库的用户名-->
        <property name="hibernate.connection.username">sa</property>
     <!--每个数据库都有其对应的Dialet以匹配其平台特性-->
        <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
 
 <property name="show_sql">true</property>
 <mapping resource="com/mytest/entity/TestUser2.hbm.xml" />

</session-factory>

</hibernate-configuration>

利用Oracle9i数据库:

<session-factory>
    

  <property name="connection.url">
   jdbc:oracle:thin:@localhost:1521:Oracle1
  </property>
  <property name="connection.username">hello</property>
  <property name="connection.password">hello</property>
  <property name="connection.driver_class">
   oracle.jdbc.driver.OracleDriver
  </property>
  <property name="dialect">
   org.hibernate.dialect.Oracle9Dialect
  </property>
  
  <property name="show_sql">true</property>
  
  <mapping resource="com/mytest/entity/TestUser2.hbm.xml" />

 </session-factory>

利用:mySql数据库:

<session-factory>
        <property name="connection.username">root</property>
        <property name="connection.url">jdbc:mysql://localhost:3306/quickstart</property>
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="connection.password">pwd</property>
        <property name="connection.driver_class">com.mysql.jdbc.Driver(或org.gjt.mm.mysql.Driver)</property>
        <property name="show_sql">true</property>
        <mapping resource="com/bbs/hibernate/User.hbm.xml"></mapping>
    </session-factory>

 

hibernate.dialect net.sf.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class org.gjt.mm.mysql.Driver
hibernate.connection.driver_class com.mysql.jdbc.Driver
hibernate.connection.url jdbc:mysql://localhost:3306/quickstart
hibernate.connection.username root
hibernate.connection.password

数据源的配置:
<property name="connection.datasource">java:comp/env/jdbc/quickstart</property>