JPA-hibernate-spring config

[joe sinnott]

Hi,
I have an issue setting up datasource for my entity manager factory under spring.

spring config xml
=========================
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="com.mysql.jdbc.Driver" />
<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/nbl" />
<property name="user" value="********" />
<property name="password" value="*******" />
<property name="maxPoolSize" value="10" />
<property name="maxStatements" value="0" />
<property name="minPoolSize" value="5" />
</bean>
<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalEntityManagerFactoryBean">

<property name="persistenceUnitName" value="NBL" />
<property name="dataSource" ref="dataSource" />
<property name="jpaVendorAdapter">
<bean
class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
<property name="showSql" value="false" />
<property name="generateDdl" value="true" />
<property name="database" value="MYSQL" />
</bean>
</property>
</bean>

Exception
===========================================
i am seeing this error:

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource
[com/pjs2k/nbl/test/resource/spring-config-test.xml]: Initialization of bean failed; nested exception is org.springframework.beans.TypeMismatchException:
Failed to convert property value of type [com.mchange.v2.c3p0.ComboPooledDataSource] to required type [javax.sql.DataSource] for property 'dataSource';
nested exception is java.lang.IllegalArgumentException: Original must not be null
...
Caused by: org.springframework.beans.TypeMismatchException: Failed to convert property value of type [com.mchange.v2.c3p0.ComboPooledDataSource]
to required type [javax.sql.DataSource] for property 'dataSource'; nested exception is java.lang.IllegalArgumentException: Original must not be null
at org.springframework.beans.BeanWrapperImpl.convertF
orProperty(BeanWrapperImpl.java:391)

Is this some bean set operation problem.

Not sure what i ma doing wrong. Have configured my setup based on samples from the internet.

Am running eclipse with jdk1.5

Any pointers much appeciated.

Thanks in advance

[joe sinnott]

LocalEntityManagerFactoryBean does not seem to have a datasource property
how does this get set up in spring?

[mort sahl]

Try something like this ...

Persistence.xml

 <?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence" version="1.0"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
   <a href="http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">" target="_blank" rel="nofollow">http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"></a>
 
    <persistence-unit name=<WHATEVER> transaction-type="RESOURCE_LOCAL">
       <provider>org.hibernate.ejb.HibernatePersistence</provider>
       
       <properties>
          <property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider"/>
      </properties>
       
    </persistence-unit>
 
</persistence>   

applicationContext.xml (not full, just relevant parts)

    <!-- Persistence -->
   <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
   <property name="location" value="classpath:jdbc.properties"/>
</bean>
   
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" >
        <property name="driverClassName"  value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>
   
    <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        
        <property name="jpaVendorAdapter">
           <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
              <property name="generateDdl" value="true"/>
              <property name="databasePlatform" value="org.hibernate.dialect.MySQL5Dialect"/>
           </bean>
        </property> 
        
    </bean>   

jdbc.properties for the PropertyPlaceholderConfigurer

 jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/<DBNAME>
jdbc.username=<USERNAME>
jdbc.password=<PASSWORD>
hibernate.hbm2ddl.auto=update   

[mort sahl]

Forgot to add this to the applicationContext ...

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