Hibernate with spring batch

[bleacherseat]

Hi All !

I need to implement Spring Batch with Hibernate. My question is about transaction management.

1. Spring Batch writes meta data to job repository using jdbc. (Atleast that is my finding. Please let me know if this is not correct)

2. My ItemWriters would use hibernate to persist data that is read in ItemReaders.

3. I will need to ensure that Spring Batch and Hibernate are running in one single transaction.

It seems to me that I will need to define two transaction managers one for JDBC and another one for hibernate. How can I bring these two different transaction managers to participate in the same transaction ?

any pointers are much appreciated ?

Thanks

[arno]

an HibernateTransactionManager should to the job, as long as the SessionFactory uses the same datasource as the JdbcTemplates.

[haqyunus]

an HibernateTransactionManager should to the job, as long as the SessionFactory uses the same datasource as the JdbcTemplates.

in other words, if we make sure to use the same data source for the job-repository and hibernate configuration (session factory) then it should work. this way they both will share the same transaction manager and hence the scope...right?

by the way what would be the solution if our spring batch database is different and database for business domain objects is different?

[bleacherseat]

My guess would be then to use a container managed transaction API such as JTA.

[arno]

My guess would be then to use a container managed transaction API such as JTA.

right, you would need JTA. You don't have to use a full-blown application server though, you can use standalone JTA transaction managers like Atomikos or Bitronix Transaction Manager.