Re: Spring Batch

On 3/28/2025 9:02 AM, Arne Vajhøj wrote:

On 3/28/2025 8:51 AM, Arne Vajhøj wrote:

On 3/18/2025 3:51 PM, Arne Vajhøj wrote:

I am happy to report that Spring Batch 4.3 works fine on
VMS x86-64 (and probably also on VMS Itanium, but not on
VMS Alpha due to too old Java version).
>
For database, XML, JSON and CSV the following jar files:

>

The code and configuration is the same as on any other platform.

>
Spring Batch can read/write from/to relational databases and a few NoSQL databases
as well: MongoDB, Neo4J and Redis.
>
Obviously it does not read/write VMS index-sequential files out of the box.
>
But since I happen to have a library allowing JVM languages to access VMS
index-sequential files, then creating a wrapper allowing Sping Batch to access
them was tempting.
>
So I did.
>
First the simple model with only one index-sequential file.

 The more tricky case is multiple index-sequential files similar to one- to-many
relations in relational databases.
 (index-sequentiel files allow for arrays within records, but that is not always
possible to utilize due to  the 32 KB limit)

To illustrate:
VMS Tech Demo 21 - data export with Spring Batch
   https://www.vajhoej.dk/arne/articles/vmstd21.html
VMS Tech Demo 22 - data import with Spring Batch
   https://www.vajhoej.dk/arne/articles/vmstd22.html
Which are repeats of:
VMS Tech Demo 18 - getting data out of VMS
   https://www.vajhoej.dk/arne/articles/vmstd18.html
VMS Tech Demo 19 - getting data into VMS
   https://www.vajhoej.dk/arne/articles/vmstd19.html
but with the custom Groovy/Jython code replaced with
Spring Batch and XML config - in reality coding in
XML instead of Groovy/Jython.
For index-sequential file it is using two files, so it
is the MultiIsamItemReader/Writer being used.
Arne