[Bug]: Updating an Oracle Date column with a Date read from Postgres fails (unless "Skip lookup" is checked)

[gmitter-ef]

Apache Hop version?

2.15.0

Java version?

OpenJDK 17

Operating system

Windows

What happened?

The "Table input" transform reads a "date" from a Postgres database,
the "Update" transform tries to update a corresponding "Date" in an Oracle database with the value read from Postgres.

Unless "Skip lookup" is checked, the update fails with:

2025/10/08 07:50:20 - Update.0 - ERROR: Error in transform, asking everyone to stop because of:
2025/10/08 07:50:20 - Update.0 - ERROR: org.apache.hop.core.exception.HopDatabaseException: 
2025/10/08 07:50:20 - Update.0 - Couldn't get row from result set
2025/10/08 07:50:20 - Update.0 - 
2025/10/08 07:50:20 - Update.0 - Unable to get value 'None' from database resultset, index 0
2025/10/08 07:50:20 - Update.0 - No data read

In the case of unchecking "Skip lookup", checking/unchecking "Ignore lookup failures" and providing a field for the Y/N values if the key was found makes no difference.

Using a "Select values" transform to convert the Date stream field into a String or Timestamp changes nothing in the behavior.
Fields of other types (String, Integer...) have no problems with updates with unchecked "Skip lookup".

See the attached pipeline:
date-update-test-public.zip

Issue Priority

Priority: 3

Issue Component

Component: Transforms