DB2
Use JdbcTemplate, method annotations, Mapper files, or the Builder API with DB2. The following pages cover database-specific configuration and usage.
| Scenario | Usage |
|---|---|
| Key generation | IDENTITY and sequences |
| Pagination | Row-number pagination |
| Insert conflicts | MERGE |
| Data backfill | Return written fields with FINAL TABLE |
- Programmatic API: queries, writes, multiple results, and stored routine differences.
- Mapper API: annotations, Mapper reads and writes, and execution differences.
- Builder API: Supported operations, datasource-specific behavior, and usage.
- Pagination: Page queries and total counts.
- Insert Conflicts: Handle existing records during insertion.
- Key Generation: Configure and retrieve IDs.
- Data Backfill: Read values returned by a write.
- Type Support: Choose Java property types.
- Transaction Support: Roll back multiple writes on failure.