yet another Spring-JPA-Hibernate config question

[Stuart Rogers]

Greetings all,

I have decided to upgrade a functioning standalone desktop Java/Spring3x/Hibernate3x/Maven/MySQL5x/Eclipse app from using Hibernate for my ORM to JPA2.

Here's what I've got so far

src/main/resources/ApplicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns:aop="http://www.springframework.org/schema/aop"
   xmlns:context="http://www.springframework.org/schema/context"
   xmlns:lang="http://www.springframework.org/schema/lang"
   xmlns:p="http://www.springframework.org/schema/p"
   xmlns:tx="http://www.springframework.org/schema/tx"
   xmlns:util="http://www.springframework.org/schema/util"
   xsi:schemaLocation="http://www.springframework.org/schema/beans
                       http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
                       http://www.springframework.org/schema/aop
                       http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
                       http://www.springframework.org/schema/context
                       http://www.springframework.org/schema/context/spring-context-3.0.xsd
                       http://www.springframework.org/schema/lang
                       http://www.springframework.org/schema/lang/spring-lang-3.0.xsd
                       http://www.springframework.org/schema/tx
                       http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
                       http://www.springframework.org/schema/util
                       http://www.springframework.org/schema/util/spring-util-3.0.xsd"
           default-autowire="byName">

  <!--  Activates various annotations to be detected in bean classes -->
  <context:annotation-config />
    
  <!-- Scan packages for components, services, repositories etc -->
  <context:component-scan base-package="vdms"/>
  
  <!-- adds support for @Transactional annotation -->
  <bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor"/>

  <bean id="databasePropertiesServerB"
    class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    <property name="location"          value="classpath:databaseServerB.properties" />
    <property name="placeholderPrefix" value="$dbServerB{" />
    <property name="placeholderSuffix" value="}" />
  </bean>

  <bean id="dataSourceServerB"
    class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
    <property name="driverClass"       value="$dbServerB{hibernate.connection.driver_class}" />
    <property name="jdbcUrl"           value="$dbServerB{hibernate.connection.url}" />
    <property name="user"              value="$dbServerB{hibernate.connection.username}" />
    <property name="password"          value="$dbServerB{hibernate.connection.password}" />
    <property name="minPoolSize"       value="$dbServerB{hibernate.c3p0.min_size}" />
    <property name="maxPoolSize"       value="$dbServerB{hibernate.c3p0.max_size}" />
    <property name="maxIdleTime"       value="$dbServerB{hibernate.c3p0.timeout}" />
    <property name="maxStatements"     value="$dbServerB{hibernate.c3p0.max_statements}" />
  </bean>

  <bean id="jpaHibernateDialect" class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />
 
  <bean id="jpaHibernateVendorAdapter" class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
    <property name="database"         value="MYSQL" />
    <property name="databasePlatform" value="org.hibernate.dialect.MySQLInnoDBDialect" />
    <property name="generateDdl"      value="false" />
    <property name="showSql"          value="false" />
  </bean>
  
  <bean id="pum" class="org.springframework.orm.jpa.persistenceunit.DefaultPersistenceUnitManager">
    <property name="persistenceXmlLocation" value="classpath:*/persistenceB.xml" />
    <property name="dataSources">
      <map>
        <entry key="localDataSource"  value-ref="dataSourceServerB"/>
      </map>
    </property>
    <!-- if no datasource is specified, use this one -->
    <property name="defaultDataSource" ref="dataSourceServerB"/>
    <property name="loadTimeWeaver">
      <bean class="org.springframework.instrument.classloading.InstrumentationLoadTimeWeaver"/>
    </property>
  </bean>
  
  <bean id="emf2" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
    <property name="jpaDialect"             ref="jpaHibernateDialect" />
    <property name="jpaVendorAdapter"       ref="jpaHibernateVendorAdapter" />
    <property name="persistenceUnitManager" ref="pum" />
    <property name="persistenceUnitName"    value="pu2" />
  </bean>
  
  <bean id="txManager" class="org.springframework.transaction.jta.JtaTransactionManager">
    <property name="entityManagerFactory" ref="emf2" />
  </bean>
  
  <tx:annotation-driven transaction-manager="txManager" />
  <tx:jta-transaction-manager />

  <bean id="activityCodeDAO"             class="btyt.dao.hibernate.ActivityCodeDAOHibernate">
    <property name="em" ref="emf2" />
  </bean>

/src/main/resources/persistenceB.xml

<?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="pu2" transaction-type="JTA">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <jta-data-source>java:/MySqlDS</jta-data-source>
    <class>vdms.model.ActivityCode</class>
    <properties>
 <!-- <property name="hibernate.dialect"                      value="org.hibernate.dialect.HSQLDialect"/> -->
      <property name="hibernate.dialect"                      value="org.hibernate.dialect.MySQLInnoDBDialect" />
      <property name="hibernate.connection.characterEncoding" value="UTF-8" />
      <property name="hibernate.connection.driver_class"      value="com.mysql.jdbc.Driver" />
      <property name="hibernate.connection.url"               value="jdbc:mysql://localhost:3306/zzzzzzz" />
      <property name="hibernate.connection.username"          value="root" />
      <property name="hibernate.connection.password"          value="*******" />
      <property name="hibernate.connection.release_mode"      value="after_transaction" />
      <property name="hibernate.cache.provider_class"         value="org.hibernate.cache.NoCacheProvider" />
      <property name="hibernate.c3p0.min_size"                value="5" />
      <property name="hibernate.c3p0.max_size"                value="20" />
      <property name="hibernate.c3p0.timeout"                 value="600" />
      <property name="hibernate.c3p0.max_statements"          value="50" />
      <property name="hibernate.show_sql"                     value="false" />
      <property name="hibernate.format_sql"                   value="true" />
      <property name="hibernate.hbm2ddl.auto"                 value="update" />
    </properties>
  </persistence-unit>
</persistence>

ActivityCodeDAOImpl

import java.util.*;
import javax.persistence.*;

import org.springframework.transaction.annotation.Transactional;
import org.springframework.stereotype.Repository;

import org.hibernate.*;
import org.hibernate.SessionFactory;
import org.hibernate.Query;

import static org.hibernate.criterion.Expression.*;

import btyt.model.ActivityCode;
import btyt.dao.ActivityCodeDAO;

@Transactional
@Repository("activityCodeDAO")
public class ActivityCodeDAOHibernate implements ActivityCodeDAO
{
    @PersistenceContext
    private EntityManager em;  // injected from bean
    .....

and a simple test program

     ......
    public static void main(String[] args)
    {
       .....
        ApplicationContext ctx = new ClassPathXmlApplicationContext("ApplicationContext.xml");
       .....

The test program belches on this line with the message

Caused by: java.lang.IllegalArgumentException: No persistence unit with name 'pu2' found
	at org.springframework.orm.jpa.persistenceunit.DefaultPersistenceUnitManager.obtainPersistenceUnitInfo(DefaultPersistenceUnitManager.java:393)
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.determinePersistenceUnitInfo(LocalContainerEntityManagerFactoryBean.java:244)
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:196)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:308)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
	... 26 more

Now I know my persistence file isn't in the standard place but it =seems= to be getting found at least - changing the value of

    <property name="persistenceXmlLocation" value="classpath:*/persistenceB.xml" />

to some other directory where the file is not will cause a FileNotFound error. So maybe there's some flaw in pu2 that causes IAE error?

I've structured my configuration this way for I plan to add support for multiple databases via multiple EntityFactories and DataSources.

So can anyone spot what I've done wrong/not done right? And are there any improvements to be made? What's the 'best-practices' zen of achieving multiple database transaction management with JPA2/Hibernate ?

TIA,

Still-learning Steve