Parameters, row mapping, single/optional/list, generated keys, batch via NamedParameterJdbcTemplate (JdbcClient has none), exception translation, transactions, an unclosed stream() exhausting a 2-connection pool, withMaxRows truncating silently, and spring.jdbc.template.* reaching the auto-configured JdbcClient. JdbcClient API diffed across 6.1.0, 6.2.19 and 7.0.0. Co-Authored-By: Claude Sonnet 5.5 <[email protected]> Claude-Session: https://claude.ai/code/session_017ic4b5n3PRbPkUsiJybTeg
8 lines
528 B
Plaintext
8 lines
528 B
Plaintext
start: keyboard(1)=12 webcam(5)=3
|
|
@Transactional move of 5 from webcam to keyboard -> DataIntegrityViolationException
|
|
after: keyboard(1)=12 webcam(5)=3 (both UPDATEs rolled back)
|
|
same body, no @Transactional -> DataIntegrityViolationException
|
|
after: keyboard(1)=17 webcam(5)=3 (the first UPDATE had already committed)
|
|
TransactionTemplate, UPDATE then RuntimeException -> IllegalStateException; mouse(2)=40 (was 40)
|
|
inside a transaction a later SELECT sees the earlier UPDATE: 55; after commit: 55
|