SpringBoot batch with JPARepository without persisting meta data into DB

Question

I want to create a spring-batch job, which will save data into SQL Server tables, but I want to run it without any meta data database persistence. Unfortunately spring-batch requires to write metadata information of job execution.

I don't want those BATCH table to be created. How can I do this.

Does this answer your question? Spring-Batch without persisting metadata to database? — Mahmoud Ben Hassine
– Mahmoud Ben Hassine, Commented Sep 18, 2020 at 15:01

Rahul · Accepted Answer · 2020-09-18 14:32:18Z

1

Those tables are required for proper functioning of the spring-batch framework features, so I don't think its a good idea. However Spring does provide a in-memory solution.

The JobRepository has a few Dao classes. Eg. JobInstanceDao, JobExecutionDao etc. All of these by default use the JDBC implementation. But Spring also provides a in-memory implementation for these eg. MapJobInstanceDao for JobInstanceDao. You can easily inject these through the constructor of SimpleJobRepository.

answered Sep 18, 2020 at 14:32

Rahul

2992 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

DanzerZoneJS Over a year ago

I have tried MapJobRepositoryFactoryBean but in that case I am using ResourcelessTransactionManager which is causing issue. I am not being able to save data after that.

Rahul Over a year ago

Seems like you are using the same transaction manager globally ? Make sure the ResourcelessTransactionManager is not picked up by the business logic classes.

DanzerZoneJS Over a year ago

How to have separate transaction manager for JPA repository. I tried using @Transactional at service layer but it did not help.

Rahul Over a year ago

I am sure you already have some transaction manager setup. Keep it as is. Define a bean of ResourcelessTransactionManager and pass it into the MapJobRepositoryFactoryBean only. Unless I am missing something this should work.

Rahul Over a year ago

ResourcelessTransactionManager is basically a no-op transaction manager. Using this essentially means dropping support of transactions.

|

Collectives™ on Stack Overflow

SpringBoot batch with JPARepository without persisting meta data into DB

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related