META-INF.persistence.xml.template Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of etl Show documentation

The base ETL to be used in other CATools project as a base contract.

There is a newer version: 0.1.25

<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="CEtlPersistence">
        <description>Etl Persistence Entity Manager</description>
        <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
        <exclude-unlisted-classes>false</exclude-unlisted-classes>

        <properties>
            <property name="javax.persistence.jdbc.driver" value="org.postgresql.Driver"/>
            <property name="javax.persistence.jdbc.url" value="jdbc:postgresql://localhost:3567/etl"/>
            <property name="javax.persistence.jdbc.user" value="postgres"/>
            <property name="javax.persistence.jdbc.password" value="password"/>

            <!-- Connection settings -->
            <property name="hibernate.event.merge.entity_copy_observer" value="allow"/>
            <property name="hibernate.archive.autodetection" value="class"/>
            <property name="hibernate.show_sql" value="false"/>
            <property name="hibernate.format_sql" value="true"/>

            <property name="hibernate.jdbc.batch_size" value="50"/>
            <property name="hibernate.order_inserts" value="true"/>
            <property name="hibernate.order_updates" value="true"/>
            <property name="hibernate.jdbc.batch_versioned_data" value="true"/>

            <!-- Cache -->
            <property name="hibernate.connection.autocommit" value="true"/>
            <property name="hibernate.generate_statistics" value="false"/>

            <property name="hibernate.cache.use_structured_entries" value="true"/>
            <property name="hibernate.cache.use_second_level_cache" value="true"/>
            <property name="hibernate.cache.use_query_cache" value="true"/>

            <property name="hibernate.cache.region.factory_class"
                      value="org.hibernate.cache.jcache.JCacheRegionFactory"/>
            <property name="hibernate.cache.provider_class" value="org.ehcache.jsr107.EhcacheCachingProvider"/>
            <property name="net.sf.ehcache.configurationResourceName" value="etlCache.xml"/>

            <!-- Create/Update/Validate/Create-drop database -->
            <property name="hibernate.hbm2ddl.auto" value="update"/>
        </properties>
    </persistence-unit>
</persistence>