Hibernate 不同数据库的连接及SQL方言

<!--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 驱动程序 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 驱动程序 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)设置不正确。

hibernate4中oracle,mysql,sqlserver数据库的sql方言配置(SQL Dialects)  

数据库类型Hibernate sql方言DB2org.hibernate.dialect.DB2DialectDB2 AS/400org.hibernate.dialect.DB2400DialectDB2 OS390org.hibernate.dialect.DB2390DialectPostgreSQL 8.1org.hibernate.dialect.PostgreSQL81DialectPostgreSQL 8.2 and laterorg.hibernate.dialect.PostgreSQL82DialectMySQL5org.hibernate.dialect.MySQL5DialectMySQL5 with InnoDBorg.hibernate.dialect.MySQL5InnoDBDialectMySQL with MyISAMorg.hibernate.dialect.MySQLMyISAMDialectOracle (any version)org.hibernate.dialect.OracleDialectOracle 9iorg.hibernate.dialect.Oracle9iDialectOracle 10gorg.hibernate.dialect.Oracle10gDialectOracle 11gorg.hibernate.dialect.Oracle10gDialectSybase ASE 15.5org.hibernate.dialect.SybaseASE15DialectSybase ASE 15.7org.hibernate.dialect.SybaseASE157DialectSybase Anywhereorg.hibernate.dialect.SybaseAnywhereDialectMicrosoft SQL Server 2000org.hibernate.dialect.SQLServerDialectMicrosoft SQL Server 2005org.hibernate.dialect.SQLServer2005DialectMicrosoft SQL Server 2008org.hibernate.dialect.SQLServer2008DialectSAP DBorg.hibernate.dialect.SAPDBDialectInformixorg.hibernate.dialect.InformixDialectHypersonicSQLorg.hibernate.dialect.HSQLDialectH2 Databaseorg.hibernate.dialect.H2DialectIngresorg.hibernate.dialect.IngresDialectProgressorg.hibernate.dialect.ProgressDialectMckoi SQLorg.hibernate.dialect.MckoiDialectInterbaseorg.hibernate.dialect.InterbaseDialectPointbaseorg.hibernate.dialect.PointbaseDialectFrontBaseorg.hibernate.dialect.FrontbaseDialectFirebirdorg.hibernate.dialect.FirebirdDialect