Hibernate - Hibernate连接不同数据库的驱动程序及SQL方言

本文是我在项目实践中对Hiberante连接不同数据库的驱动程序及SQL方言用法的一些随笔总结，日后会不断地更新完善

---

 

 

  Mysql:

 

  <!--MySql 驱动程序 eg. mysql-connector-java-5.0.4-bin.jar-->
  <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
  <property name="connection.driver_class">com.mysql.jdbc.Driver</property>

  <!-- JDBC URL -->
  <property name="connection.url">
       jdbc:mysql://localhost/dbname?characterEncoding=gb2312
  </property>

  <!-- 数据库用户名-->
  <property name="connection.username">root</property>

  <!-- 数据库密码-->
  <property name="connection.password">root</property> 

 

Sql Server :

  <!--Sql Server 驱动程序 eg. jtds-1.2.jar-->
  <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
  <property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>

  <!-- JDBC URL -->
  <property name="connection.url">
       jdbc:jtds:sqlserver://localhost:1433;DatabaseName=dbname
  </property>

  <!-- 数据库用户名-->
  <property name="connection.username">sa</property>

  <!-- 数据库密码-->
  <property name="connection.password"></property> 

 
 Oracle :

  <!--Oracle 驱动程序 ojdbc14.jar-->
  <property name="dialect">org.hibernate.dialect.OracleDialect</property>
  <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>

  <!-- JDBC URL -->
  <property name="connection.url">jdbc:oracle:thin:@localhost:1521:dbname</property>

  <!-- 数据库用户名-->
  <property name="connection.username">test</property>

  <!-- 数据库密码-->
  <property name="connection.password">test</property> 

如果出现如下错误，则可能是Hibernate SQL方言 (hibernate.dialect)设置不正确。
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]'last_insert_id' 不是可以识别的 函数名。

RDBMS  方言 

DB2  org.hibernate.dialect.DB2Dialect 
DB2 AS/400  org.hibernate.dialect.DB2400Dialect 
DB2 OS390  org.hibernate.dialect.DB2390Dialect 
PostgreSQL  org.hibernate.dialect.PostgreSQLDialect 
MySQL  org.hibernate.dialect.MySQLDialect 
MySQL with InnoDB  org.hibernate.dialect.MySQLInnoDBDialect 
MySQL with MyISAM  org.hibernate.dialect.MySQLMyISAMDialect 
Oracle (any version)  org.hibernate.dialect.OracleDialect 
Oracle 9i/10g  org.hibernate.dialect.Oracle9Dialect 
Sybase  org.hibernate.dialect.SybaseDialect 
Sybase Anywhere  org.hibernate.dialect.SybaseAnywhereDialect 
Microsoft SQL Server  org.hibernate.dialect.SQLServerDialect 
SAP DB  org.hibernate.dialect.SAPDBDialect 
Informix  org.hibernate.dialect.InformixDialect 
HypersonicSQL  org.hibernate.dialect.HSQLDialect 
Ingres  org.hibernate.dialect.IngresDialect 
Progress  org.hibernate.dialect.ProgressDialect 
Mckoi SQL  org.hibernate.dialect.MckoiDialect 
Interbase  org.hibernate.dialect.InterbaseDialect 
Pointbase  org.hibernate.dialect.PointbaseDialect 
FrontBase  org.hibernate.dialect.FrontbaseDialect 
Firebird  org.hibernate.dialect.FirebirdDialect

 

---

本文章为个人原创，转载请标明本文地址

本文地址: http://www.developsearch.com/index.php/archives/19565.html

DevelopSearch | 原创作者： Kevin chen

 

---