Spring Batch Meta-Data Schema for Oracle

Question

Where can I found the sql to create in my database all the metadata sctructures needed by The Spring Batch framework. The application don't have the permission on the database to outgenerate them.

As suggested in the documentation I've try to use the sql provided in the org.springframework.batch.core repository but it's seems to be uncomplete. For example it misses the column BATCH_JOB_EXECUTION .JOB_CONFIGURATION_LOCATION VARCHAR(2500), which on the other hand it's present in the documentation snippet

I've understand that this structure comes with the newest vesion 4.1 but also the (migration script)[https://github.com/spring-projects/spring-batch/blob/main/spring-batch-core/src/main/resources/org/springframework/batch/core/migration/4.1/migration-oracle.sql] doesn't seem to be right since it supposed that the column it's already there:

ALTER TABLE BATCH_JOB_EXECUTION MODIFY JOB_CONFIGURATION_LOCATION VARCHAR2(2500 char);

Where can I found the complete oracle sql script that creates the structure needed by the framework version 4.3.6 ?

httPants · Accepted Answer · 2022-08-11 23:46:48Z

2

If you look at https://github.com/spring-projects/spring-batch/blob/4.3.x/spring-batch-core/src/main/resources/org/springframework/batch/core/schema-oracle10g.sql you can see the BATCH_JOB_EXECUTION.JOB_CONFIGURATION_LOCATION column. So you can use /org/springframework/batch/core/schema-oracle10g.sql from the classpath since it is included in spring-batch-core-4.3.6.jar.

answered Aug 11, 2022 at 23:46

httPants

2,1831 gold badge14 silver badges17 bronze badges

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

1 Comment

Panciz Over a year ago

ok it was only a matter of pointing to the correct branch. Thanks

Collectives™ on Stack Overflow

Spring Batch Meta-Data Schema for Oracle

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related