IBM DB2 9.7 Advanced Application Developer Cookbook

Using savepoints in JDBC

JDBC drivers available in DB2 provide the setSavepoint() method to create a savepoint. In this recipe, we will use savepoints in a JDBC application.

Getting ready…

• We will use the same table TEST_SVPT created in the previous example. The following command can be used to create it:

CREATE TABLE TEST_SVPT (
EMPNO INTEGER,
EMPNAME VARCHAR(20),
MGRNO INTEGER);

• The methods used will be:
  • Connection.setSavepoint(String name)
  • Connection.rollback(Savepoint savepointName)
  • Connection.releaseSavepoint(Savepoint savepointName)

How to do it…

In this example, we will create a transaction having multiple savepoints and we will see how to use them.

1. Creating a connection object: A database connection is required before we execute any SQL statement ...