日期:2014-05-16  浏览次数:20551 次

不同数据库hibernate配置连接

常见的集中hibernate数据库连接配置

1?、 oracle

?<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
?<property name="hibernate.connection.url">jdbc:oracle:thin:@133.11.11.11:1521:sid</property>
?<property name="hibernate.connection.username">username</property>
?<property name="hibernate.connection.password">password</property>
?<property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>

?

2、mysql

<property name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property>或者

<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>

要看导入mysql.jar包的驱动路径
?<property name="hibernate.connection.url">jdbc:mysql://127.0.0.1:3306/test</property>
?<property name="hibernate.connection.username">root</property>
?<property name="hibernate.connection.password">admin</property>
?<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

?

3、postgreSQL

<property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
?<property name="hibernate.connection.url">jdbc:postgresql:template1</property>
?<property name="hibernate.connection.username">root</property>
?<property name="hibernate.connection.password">admin</property>
?<property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>

?

?

完整的如下:

<?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">oracle.jdbc.driver.OracleDriver</property>
?<property name="hibernate.connection.url">jdbc:oracle:thin:@133.11.11.11:1521:sid</property>
?<property name="hibernate.connection.username">username</property>
?<property name="hibernate.connection.password">password</property>
?<property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
?-->
?<property name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property>
?<property name="hibernate.connection.url">jdbc:mysql://127.0.0.1:3306/test</property>
?<property name="hibernate.connection.username">root</property>
?<property name="hibernate.connection.password">admin</property>
?<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
?<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
?<property name="hibernate.show_sql">true</property>
?
??? <mapping resource="cn/com/andy/client/User.hbm.xml" />
</session-factory>

</hibernate-configuration>