`
isiqi
  • 浏览: 15949120 次
  • 性别: Icon_minigender_1
  • 来自: 济南
社区版块
存档分类
最新评论

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>

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics