Skip to content

Nested transaction support via savepoints is broken in HSQLDB database [followup] #35618

@shddx

Description

@shddx

Related: #32992 (“Do not swallow exceptions on failing to release a savepoint”) and follow-up fix #35564.

Summary

With Spring Framework 6.2.12-SNAPSHOT the earlier regression around savepoint handling is largely fixed, but on HSQLDB 2.7.4 we still got problem:

org.hsqldb.HsqlException: Invalid argument in JDBC call: 3B001 savepoint exception: invalid specification
SQLState: S1000
Vendor code: -423

It seems hsqldb driver sometimes throws exception with the state S1000 but message suggests its a 3B001 state. The code in the error is -423.

Proposed fix:
Handle hsqldb vendor code -423 same as 3B001 state.

Environment:
• Spring Framework: 6.2.12-SNAPSHOT
• Spring Boot: 3.5.4
• HSQLDB: 2.7.4

Metadata

Metadata

Assignees

Labels

in: dataIssues in data modules (jdbc, orm, oxm, tx)type: enhancementA general enhancement

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions