Hibernate在不同数据库中配置-优快云博客

本文详细介绍了Hibernate配置文件hibernate.cfg.xml的设置方法，包括针对不同数据库（如SQL Server、Oracle和MySQL）的具体配置示例。此外，还展示了如何指定数据库连接参数、方言以及启用SQL显示等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

<hibernate-configuration>
<session-factory >

<property name="hibernate.connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>

<property name="hibernate.connection.password"></property>

<property name="hibernate.connection.url">jdbc:microsoft:sqlserver://localhost:1433;databaseName=demo</property>

<property name="hibernate.connection.username">sa</property>

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