之前使用的是MySQL数据库,现在准备迁移到Oracle。
记录一下项目所使用的数据库配置
hibernate.cfg.xml
<?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="dialect">
org.hibernate.dialect.Oracle9Dialect
</property>
<!-- 数据库驱动 -->
<property name="connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>
<!-- 数据库连接路径 -->
<property name="connection.url">
jdbc:oracle:thin:@localhost:1521:bookticket
</property>
<!-- 连接数据库用户名密码 -->
<property name="connection.username">orcl</property>
<property name="connection.password">orcl</property>
<!-- 其他配置 -->
<property name="show_sql">true</property>
<property name="hbm2ddl.auto">update</property>
<!-- 持久化类映射文件 -->
<mapping resource="com/bkt/bean/Admin.hbm.xml" />
<mapping resource="com/bkt/bean/Flight.hbm.xml" />
<mapping resource="com/bkt/bean/Orderlist.hbm.xml" />
<mapping resource="com/bkt/bean/User.hbm.xml" />
<mapping resource="com/bkt/bean/Shoppingcar.hbm.xml" />
</session-factory>
</hibernate-configuration>