hibername各种数据库配置文件

[color=darkred][size=small]
[size=x-large]mysql：persistence-mysql.xml[/size]:<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
version="2.0">

<persistence-unit name="app" transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<mapping-file>META-INF/orm-mysql.xml</mapping-file>
<exclude-unlisted-classes/>
<properties>
<!--
<property name="javax.persistence.jdbc.url" value="jdbc:mysql://192.168.1.199:3306/app?autoReconnection=true&useUnicode=true&characterEncoding=utf-8" />
<property name="javax.persistence.jdbc.user" value="app" />
<property name="javax.persistence.jdbc.password" value="app" />
<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver" />
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect" />
-->
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect" />
<property name="hibernate.max_fetch_depth" value="3" />
<property name="hibernate.hbm2ddl.auto" value="update" />
<property name="hibernate.show_sql" value="false" />
<property name="hibernate.ejb.event.post-insert" value="org.hibernate.envers.event.AuditEventListener" />
<property name="hibernate.ejb.event.post-update" value="org.hibernate.envers.event.AuditEventListener" />
<property name="hibernate.ejb.event.post-delete" value="org.hibernate.envers.event.AuditEventListener" />
<!-- -->
<property name="hibernate.ejb.event.pre-collection-update" value="org.hibernate.envers.event.AuditEventListener" />
<property name="hibernate.ejb.event.pre-collection-remove" value="org.hibernate.envers.event.AuditEventListener" />
<property name="hibernate.ejb.event.post-collection-recreate" value="org.hibernate.envers.event.AuditEventListener" />
<property name="org.hibernate.envers.versionsTableSuffix" value="_V" />
<property name="org.hibernate.envers.revisionFieldName" value="VER_REV" />
<!-- -->
<property name="org.hibernate.envers.audit_table_suffix" value = "_AUDIT" />
<property name="org.hibernate.envers.audit_table_prefix" value = "LOG_" />
<property name="org.hibernate.envers.revision_field_name" value = "REV" />
<property name="org.hibernate.envers.revision_type_field_name" value = "REVTYPE" />
<property name="org.hibernate.envers.revision_on_collection_change" value = "true" />
<property name="org.hibernate.envers.do_not_audit_optimistic_locking_field" value = "true" />
<property name="org.hibernate.envers.store_data_at_delete" value = "true" />
<property name="org.hibernate.envers.default_schema" value = ""/>
<property name="org.hibernate.envers.default_catalog" value = ""/>
</properties>
</persistence-unit>
</persistence>
[size=large]orm-mysql 配置[/size]
<!-- 地域词典 -->
<entity class="com.book511.domain.Region"></entity>

<!-- 地址模块 -->
<entity class="com.book511.domain.Address">
<attributes>
<id name="id">
<column name="ID" />
<generated-value strategy="IDENTITY" />
</id>
</attributes>
</entity>
[size=large]oracle配置 persistence-oracle.xml[/size]
<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
version="2.0">

<persistence-unit name="book511" transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<mapping-file>META-INF/orm-oracle.xml</mapping-file>
<properties>
<property name="javax.persistence.jdbc.url" value="jdbc:oracle:thin:@192.168.1.198:1521:book511" />
<property name="javax.persistence.jdbc.user" value="book511" />
<property name="javax.persistence.jdbc.password" value="book511db" />
<property name="javax.persistence.jdbc.driver" value="oracle.jdbc.OracleDriver" />
<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />
<property name="hibernate.max_fetch_depth" value="3" />
<property name="hibernate.hbm2ddl.auto" value="update" />
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.ejb.event.post-insert"
value="org.hibernate.envers.event.AuditEventListener" />
<property name="hibernate.ejb.event.post-update"
value="org.hibernate.envers.event.AuditEventListener" />
<property name="hibernate.ejb.event.post-delete"
value="org.hibernate.envers.event.AuditEventListener" />
</properties>
</persistence-unit>
</persistence>
[size=large] orm-oracle配置[/size]
<!-- 地域词典 -->
<entity class="com.book511.domain.Region"></entity>

<!-- 地址模块 -->
<entity class="com.book511.domain.Address">
<attributes>
<id name="id">
<column name="ID" />
<generated-value strategy="SEQUENCE" generator="ADDRESS_SEQ" />
<sequence-generator name="ADDRESS_SEQ"
sequence-name="ADDRESS_SEQ" allocation-size="1" />
</id>
</attributes>
</entity>
[/size][/color]