Do you have more complete sample to this?

development

how can we configure these local session factory builder? as all the configuration functions returns configuration interface and there is no function to call build session factory on configuration. so if i write –
SessionFactory sessionFactory = new LocalSessionFactoryBuilder(this.dataSource).addAnnotatedClasses(Item.class, Order.class) .setProperties(prop) .buildSessionFactory();

I get buildsessionfactory deprecated as it refers to different function which takes service registry as input.

And no tests are included for hibernate4 in spring framework –
https://github.com/SpringSource/spring-framework/tree/master/spring-orm/src/test/java/org/springframework/orm

From where can we download updated source for this application ? any CVS or download path please ?

hopefully correctly formatted and with autowired dataSource

@Bean
@Autowired
public PlatformTransactionManager transactionManager(DataSource dataSource) {
JpaTransactionManager transactionManager = new JpaTransactionManager(entityManagerFactory);
transactionManager.setDataSource(dataSource);
transactionManager.setJpaDialect(new HibernateJpaDialect());
return transactionManager;
}

Thanks I got the URL –
https://github.com/michaelisvy/hibernate-4-spring-3.1-samples

This example does not use Java Configuration (or LocalSessionFactoryBuilder)

Can you try using the LocalSessionFactoryBuilder, as I didn't find any way to bind Hibernate properties to builder.

Thanks,
Sawan

Your JpaConfig is not correct – you autowire datasource in the configuration and define at the same time – should do only one of these.

Please see below for correct version where the datasource bean is defined in the configuration and autowired, but to other bean definitions, not configuration.

package jpa.config.java;

import javax.persistence.EntityManagerFactory;
import javax.sql.DataSource;

import org.hibernate.ejb.HibernatePersistence;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.ClassPathResource;
import org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactoryBean;
import org.springframework.jdbc.datasource.init.ResourceDatabasePopulator;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.orm.jpa.vendor.HibernateJpaDialect;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@Configuration
@EnableTransactionManagement
public class JpaConfig {

	@Bean
	@Autowired
	public EntityManagerFactory entityManagerFactory(DataSource dataSource) {

		LocalContainerEntityManagerFactoryBean entityManagerFactory = new LocalContainerEntityManagerFactoryBean();
		entityManagerFactory.setDataSource(dataSource);
		entityManagerFactory.setPackagesToScan(new String[] { "jpa.config.java" });
		entityManagerFactory.setPersistenceProvider(new HibernatePersistence());
		entityManagerFactory.afterPropertiesSet();
		return entityManagerFactory.getObject();
	}

	@Bean
	@Autowired
	public PlatformTransactionManager transactionManager(EntityManagerFactory entityManagerFactory, DataSource dataSource) {
		JpaTransactionManager transactionManager = new JpaTransactionManager(entityManagerFactory);
		transactionManager.setDataSource(dataSource);
		transactionManager.setJpaDialect(new HibernateJpaDialect());
		return transactionManager;
	}

	@Bean
	public DataSource dataSource() {
		EmbeddedDatabaseFactoryBean bean = new EmbeddedDatabaseFactoryBean();
		ResourceDatabasePopulator databasePopulator = new ResourceDatabasePopulator();
		databasePopulator.addScript(new ClassPathResource("hibernate/config/java/schema.sql"));
		bean.setDatabasePopulator(databasePopulator);
		bean.afterPropertiesSet(); // necessary because
									// EmbeddedDatabaseFactoryBean is a
									// FactoryBean
		return bean.getObject();
	}

/* other version of the same beans - no autowiring, CGLIB magic only

	@Bean
	public EntityManagerFactory entityManagerFactory() {

		LocalContainerEntityManagerFactoryBean entityManagerFactory = new LocalContainerEntityManagerFactoryBean();
		entityManagerFactory.setDataSource(dataSource());
		entityManagerFactory.setPackagesToScan(new String[] { "jpa.config.java" });
		entityManagerFactory.setPersistenceProvider(new HibernatePersistence());
		entityManagerFactory.afterPropertiesSet();
		return entityManagerFactory.getObject();
	}

	@Bean
	@Autowired
	public PlatformTransactionManager transactionManager() {
		JpaTransactionManager transactionManager = new JpaTransactionManager(entityManagerFactory());
		transactionManager.setDataSource(dataSource());
		transactionManager.setJpaDialect(new HibernateJpaDialect());
		return transactionManager;
	}

	@Bean
	public DataSource dataSource() {
		EmbeddedDatabaseFactoryBean bean = new EmbeddedDatabaseFactoryBean();
		ResourceDatabasePopulator databasePopulator = new ResourceDatabasePopulator();
		databasePopulator.addScript(new ClassPathResource("hibernate/config/java/schema.sql"));
		bean.setDatabasePopulator(databasePopulator);
		bean.afterPropertiesSet(); // necessary because
									// EmbeddedDatabaseFactoryBean is a
									// FactoryBean
		return bean.getObject();
	}

*/

}

I have not been able to get this to run.

Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'transactionManager' defined in class jpa.config.java.JpaConfig: Unsatisfied dependency expressed through constructor argument with index 0 of type [javax.persistence.EntityManagerFactory]: : Error creating bean with name 'entityManagerFactory' defined in class jpa.config.java.JpaConfig: Unsatisfied dependency expressed through constructor argument with index 0 of type [javax.sql.DataSource]: : Error creating bean with name 'dataSource' defined in class jpa.config.java.JpaConfig: Instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: Factory method [public javax.sql.DataSource jpa.config.java.JpaConfig.dataSource()] threw exception; nested exception is org.springframework.dao.DataAccessResourceFailureException: Failed to execute database script; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement at line 2 of resource class path resource [hibernate/config/java/schema.sql]: create table T_ACCOUNT (id bigint generated by default as identity (start with 1), cashBalance double, name varchar(255), primary key (id)); nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class jpa.config.java.JpaConfig: Instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: Factory method [public javax.sql.DataSource jpa.config.java.JpaConfig.dataSource()] threw exception; nested exception is org.springframework.dao.DataAccessResourceFailureException: Failed to execute database script; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement at line 2 of resource class path resource [hibernate/config/java/schema.sql]: create table T_ACCOUNT (id bigint generated by default as identity (start with 1), cashBalance double, name varchar(255), primary key (id)); nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'entityManagerFactory' defined in class jpa.config.java.JpaConfig: Unsatisfied dependency expressed through constructor argument with index 0 of type [javax.sql.DataSource]: : Error creating bean with name 'dataSource' defined in class jpa.config.java.JpaConfig: Instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: Factory method [public javax.sql.DataSource jpa.config.java.JpaConfig.dataSource()] threw exception; nested exception is org.springframework.dao.DataAccessResourceFailureException: Failed to execute database script; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement at line 2 of resource class path resource [hibernate/config/java/schema.sql]: create table T_ACCOUNT (id bigint generated by default as identity (start with 1), cashBalance double, name varchar(255), primary key (id)); nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class jpa.config.java.JpaConfig: Instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: Factory method [public javax.sql.DataSource jpa.config.java.JpaConfig.dataSource()] threw exception; nested exception is org.springframework.dao.DataAccessResourceFailureException: Failed to execute database script; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement at line 2 of resource class path resource [hibernate/config/java/schema.sql]: create table T_ACCOUNT (id bigint generated by default as identity (start with 1), cashBalance double, name varchar(255), primary key (id))

I am assuming it is something wrong with my environment. Also, has anyone checked this out and ran it?

Thank you,

Dave

Thanks for the example

It seems that HibernateJpaDialect uses SessionFactoryUtils of Hibernate3. Is there any to be able to configure JPA to use Hibernate4's SessionFactoryUtils so I get Hibernate4 exceptions?

The following post on the forum has a more detailed question:

http://forum.springsource.org/showthread.php?127001-HibernateJpaDialect-coupled-to-SessionFactoryUtils-of-Hibernate-3

Hi,

If we wanna configure either the Jpa och Hibernate java configuration to include hbm2ddl, how would it be done? Tried for a while now cause I want the tables to be autocreated, I don't want it to run an initDB script everytime i run the application.

tried to:
Properties props = new Properties();
props.setProperty("hibernate.hbm2ddl.auto", "drop-create");
sessionFactoryBuilder.setProperties(props);

But can't get it to work,

Please bring some light in this.

Michael – thanks for the post.

We are using Spring 3.2.1 and Hibernate 4.1.9 with XML config and JPA. I cannot see how you specify which version of Hibernate to use in your example, or on GitHub.

We are getting a Hibernate 'Failed to convert to internal representation' error and I'm wondering if it is a Hibernate 3/4 issue.

Hope you can help.
Thanks
Richard

It troubles me to see XML configuration referred to in relation to Spring 3.2 training.

No wonder we still have XML hell in so many enterprise projects!