hibernate的真实的痛楚
我的程序很让人受不了,在MySql成功,在oracle失败。
1.我先写了hibernate.properties.一是MySQL数据库,一是oracle数据库。
hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost:3306/SAMPLEDB
hibernate.connection.username=root
hibernate.connection.password=1234
hibernate.show_sql=true
hibernate.dialect=net.sf.hibernate.dialect.OracleDialect
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@10.130.1.58:1521:appdb
hibernate.connection.username=mcode
hibernate.connection.password=appboco
hibernate.show_sql=true
2.写了hbm.xml文件
<?xml version="1.0" encoding="GBK"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping package="com.boco.hibernate">
<class name="Province" table="hibernate_Province" dynamic-insert="true" dynamic-update="true">
<meta attribute="class-description">
Represents a single Province.
@author mc
</meta>
<meta attribute="class-scope">public</meta>
<id name="provid" type="long">
<generator class="increment" />
</id>
<property name="provname" type="string" >
<meta attribute="use-in-tostring">true</meta>
<column name="prov_name" />
</property>
<set
name="citys"
cascade="all-delete-orphan"
inverse="true"
>
<key column="key_prov_id" />
<one-to-many class="com.boco.hibernate.City" />
</set>
</class>
</hibernate-mapping>
<?xml version="1.0" encoding="GBK"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping package="com.boco.hibernate">
<class name="City" table="hibernate_City" dynamic-insert="true" dynamic-update="true">
<meta attribute="class-description">
Represents a single City.
@author mc
</meta>
<meta attribute="class-scope">public</meta>
<id name="cityid" type="long">
<generator class="increment" />
</id>
<property name="cityname" type="string" >
<meta attribute="use-in-tostring">true</meta>
<column name="city_name" />
</property>
<many-to-one
name="prov"
column="key_prov_id"
class="com.boco.hibernate.Province"
cascade="save-update"
/>
<set
name="codebases"
cascade="all-delete-orphan"
inverse="true"
>
<key column="key_city_id" />
<one-to-many class="com.boco.hibernate.Codebase" />
</set>
</class>
</hibernate-mapping>