Mapping partitions fails in Jakarta Batch mass indexing job for some JDBC drivers (DB2, MSSQL, ...)

Description

The error varies, sometimes it’s about DB2 SQL Error: SQLCODE=-243 (can’t use ResultSet.TYPE_SCROLL_SENSITIVE together with a max number of rows), sometimes it’s about an invalid call to .scroll after .next returned false (some drivers allow it and just return false again, but others throw an exception).

In any case, we need to rework the partition mapper to make it work on all supported JDBC drivers.

Activity

Show:
Fixed

Details

Assignee

Reporter

Sprint

Fix versions

Priority

Created October 3, 2023 at 9:57 AM
Updated October 20, 2023 at 11:01 AM
Resolved October 3, 2023 at 11:58 AM