Spring Data repository and JDBC APIs were used for persistence, transactional job claims, account paging, reconciliation results, and advisory-lock-based idempotency. Compilation and unit verification succeeded.
- What worked
- It allowed both entity-oriented posting access and direct SQL for PostgreSQL-specific queue and locking behavior.