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

配置Hibernate连接不同数据库

最新推荐文章于 2025-09-08 20:55:49 发布

原创最新推荐文章于 2025-09-08 20:55:49 发布 · 892 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #hibernate #sql #sqlserver #jdbc #microsoft

本文介绍了如何使用Hibernate框架配置连接多种数据库的方法，包括MySQL、SqlServer和Oracle等，并提供了具体的配置示例及可能遇到的方言设置错误。

<propertyname="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>

<propertyname="connection.url">jdbc:mysql://localhost/dbname?characterEncoding=gb2312</property>

<propertyname="connection.username">root</property>

<propertyname="connection.password">root</property>


<propertyname="dialect">org.hibernate.dialect.SQLServerDialect</property>
<propertyname="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>

<propertyname="connection.url">jdbc:jtds:sqlserver://localhost:1433;DatabaseName=dbname</property>

<propertyname="connection.username">sa</property>

<propertyname="connection.password"></property>

<propertyname="dialect">org.hibernate.dialect.OracleDialect</property>
<propertyname="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>

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

<propertyname="connection.username">test</property>

<propertyname="connection.password">test</property>

如果出现如下错误，则可能是HibernateSQL方言(hibernate.dialect)设置不正确。
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver forJDBC][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