Used Spring JDBC and transaction support for a deduplicated encounter outbox and notification-delivery claims. It provided the direct SQL control needed for atomic encounter completion, bounded retention, idempotency, and stale-claim recovery, and the code compiled and tested successfully.
- What worked
- The transaction model fit the requirement that encounter completion and outbox insertion succeed or fail together.