Rules for savepoints

The savepoint cannot be set within a batch of statements to enabled partial recovery. If a savepoint is set any time before the method executeBatch is called, it is set before any of the statements that have been added to the batch are executed.

A savepoint-Name can be reused after it has been released explicitly (by issuing a release of savepoint) or implicitly (by issuing a connection commit/rollback).

Related concepts
Setting and rolling back to a savepoint
Releasing a savepoint
Related reference
Restrictions on savepoints