Clean spring batch metadata tables

[Tiago Melo]

How can I clean up spring batch metadata tables?

Thanks.

[olivier.bazoud]

How can I clean up spring batch metadata tables?

Thanks.

* See issue BATCH-1747.
* See RemoveSpringBatchHistoryTasklet @ https://github.com/arey/spring-batch-toolkit
* Read blog entry (french): Sprint Batch s'auto-nettoie

[johnmmcparland]

How can I clean up spring batch metadata tables?

Thanks.

I've used this with v2.1.7.RELEASE

DELETE FROM BATCH_STEP_EXECUTION_CONTEXT ;
DELETE FROM BATCH_JOB_EXECUTION_CONTEXT ;
DELETE FROM BATCH_STEP_EXECUTION ;
DELETE FROM BATCH_JOB_EXECUTION ;
DELETE FROM BATCH_JOB_PARAMS ;
DELETE FROM BATCH_JOB_INSTANCE ;

DELETE FROM BATCH_STEP_EXECUTION_SEQ ;
DELETE FROM BATCH_JOB_EXECUTION_SEQ ;
DELETE FROM BATCH_JOB_SEQ ;

[Tiago Melo]

I've used this with v2.1.7.RELEASE

DELETE FROM BATCH_STEP_EXECUTION_CONTEXT ;
DELETE FROM BATCH_JOB_EXECUTION_CONTEXT ;
DELETE FROM BATCH_STEP_EXECUTION ;
DELETE FROM BATCH_JOB_EXECUTION ;
DELETE FROM BATCH_JOB_PARAMS ;
DELETE FROM BATCH_JOB_INSTANCE ;

DELETE FROM BATCH_STEP_EXECUTION_SEQ ;
DELETE FROM BATCH_JOB_EXECUTION_SEQ ;
DELETE FROM BATCH_JOB_SEQ ;

That's it. Thanks!

[johnmmcparland]

That's it. Thanks!

Yikes I made a big mistake here...

DELETE FROM BATCH_STEP_EXECUTION_CONTEXT ;
DELETE FROM BATCH_JOB_EXECUTION_CONTEXT ;
DELETE FROM BATCH_STEP_EXECUTION ;
DELETE FROM BATCH_JOB_EXECUTION ;
DELETE FROM BATCH_JOB_PARAMS ;
DELETE FROM BATCH_JOB_INSTANCE ;

DELETE FROM BATCH_STEP_EXECUTION_SEQ ;
DELETE FROM BATCH_JOB_EXECUTION_SEQ ;
DELETE FROM BATCH_JOB_SEQ ;

-- These are needed
INSERT INTO BATCH_STEP_EXECUTION_SEQ values(0);
INSERT INTO BATCH_JOB_EXECUTION_SEQ values(0);
INSERT INTO BATCH_JOB_SEQ values(0);

Those insertions at the end are very important! As I found out here

Please do use the updated version!

[Tiago Melo]

Yikes I made a big mistake here...

DELETE FROM BATCH_STEP_EXECUTION_CONTEXT ;
DELETE FROM BATCH_JOB_EXECUTION_CONTEXT ;
DELETE FROM BATCH_STEP_EXECUTION ;
DELETE FROM BATCH_JOB_EXECUTION ;
DELETE FROM BATCH_JOB_PARAMS ;
DELETE FROM BATCH_JOB_INSTANCE ;

DELETE FROM BATCH_STEP_EXECUTION_SEQ ;
DELETE FROM BATCH_JOB_EXECUTION_SEQ ;
DELETE FROM BATCH_JOB_SEQ ;

-- These are needed
INSERT INTO BATCH_STEP_EXECUTION_SEQ values(0);
INSERT INTO BATCH_JOB_EXECUTION_SEQ values(0);
INSERT INTO BATCH_JOB_SEQ values(0);

Those insertions at the end are very important! As I found out here

Please do use the updated version!

Oh that's right. Thank you very much for your help!

Cheers!