<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" id="readFileProp">
    <property name="ignoreUnresolvablePlaceholders" value="true" />
    <property name="ignoreResourceNotFound" value="false" />
    <property name="order" value="1" />
    <property name="locations">
        <list>
            <value>classpath:data-access.properties</value>
        </list>
    </property>
</bean>

<bean id="DataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" depends-on="readFileProp"
    p:driverClassName="${jdbc.driverClassName}" p:url="${jdbc.url}"
    p:username="${jdbc.username}" p:password="${jdbc.password}" />

<bean class="com.sharing.workflowEngine.config.DbPropertySourcesPlaceholderConfigurer" depends-on="entityManagerFactory">
    <property name="ignoreUnresolvablePlaceholders" value="true" />
    <property name="ignoreResourceNotFound" value="true" />
    <property name="order" value="2" />
    <property name="placeholderPrefix" value="${" />
    <property name="placeholderSuffix" value="}" />
    <property name="dataSourceName" value="DataSource" />

    <property name="locations">
        <list>
            <value>classpath:data-access.properties</value>
        </list>
    </property>
</bean>

<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
    <property name="dataSource" ref="DataSource" />
    <property name="packagesToScan"
        value="com.sharing.workflowEngine.model,com.sharing.metier.model" />
    <property name="jpaVendorAdapter">
        <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter" />
    </property>
    <property name="jpaProperties">
        <props>
            <prop key="hibernate.hbm2ddl.auto">update</prop>
            <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
            <prop key="hibernate.show_sql">true</prop>
            <prop key="hibernate.event.merge.entity_copy_observer">allow</prop>
        </props>
    </property>
</bean>

<!-- Enable the configuration of transactional behavior based on annotations -->
<tx:annotation-driven />


<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
    <property name="entityManagerFactory" ref="entityManagerFactory" />
</bean>

<jdbc:initialize-database data-source="DataSource">
    <jdbc:script location="${jdbc.initLocation}" encoding="UTF-8" />
    <jdbc:script separator="$$" location="${jdbc.initFunction}" />
</jdbc:initialize-database>