From: arne@vajhoej.dk

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

--- SoupGate-DOS v1.05
 * Origin: you cannot sedate... all the things you hate (1:229/2)