Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

How to Create a Savepoint in JDBC?

  • Difficulty Level : Medium
  • Last Updated : 28 Dec, 2020

A Savepoint object is used to save the current state of the database which can be rolled-back afterwards to that state of the database. Savepoints are similar to the SQL Transactions and are generally to rollback if something goes wrong within the current transaction. The connection.setSavepoint() method of Connection interface in Java is used to create an object which references a current state of the database within the transaction. The following example shows the usage of Savepoint and Rollback in JDBC application.

syntax

Attention reader! Don’t stop learning now. Get hold of all the important Java Foundation and Collections concepts with the Fundamentals of Java and Java Collections Course at a student-friendly price and become industry ready. To complete your preparation from learning a language to DS Algo and many more,  please refer Complete Interview Preparation Course.

connection.setSavepoint()

Returns: It returns a new Savepoint object.

Exceptions: SQLException is thrown if a database access error occurs, this method is called while participating in a distributed transaction, this method is called on a closed connection or this Connection object is currently in auto-commit mode. SQLFeatureNotSupportedException is thrown if the JDBC driver does not support this method.

Example

Java




// Java program to demonstrate how to make a save point
  
import java.io.*;
import java.sql.*;
  
class GFG {
    public static void main(String[] args)
    {
        // db credentials
        String jdbcEndpoint
            = "jdbc:mysql://localhost:3000/GEEKSFORGEEKS";
        String userid = "GFG";
        String password = "GEEKSFORGEEKS";
  
        // create a connection to db
        Connection connection = DriverManager.getConnection(
            jdbcEndpoint, userid, password);
  
        // construct a query
        Statement deleteStmt = connection.createStatement();
        String deleteQuery
            = "DELETE FROM USER WHERE AGE > 15";
  
        // Disable auto commit to connection
        connection.setAutoCommit(false);
  
        /*    Table USER
       +--------+---------+------------+
       | USR_ID | NAME    | AGE        |
       +--------+---------+------------+
       |      1 | GFG_1      | 10           |
       |      2 | GFG_2   | 20         |
       |      3 | GFG_3   | 25           |
       +--------+---------+------------+
       */
  
        // Create a savepoint object before executing the
        // deleteQuery
        Savepoint beforeDeleteSavepoint
            = connection.setSavepoint();
  
        // Executing the deleteQuery
        ResultSet res
            = deleteStmt.executeQuery(deleteQuery);
  
        /*    Table USER after executing deleteQuery
       +--------+---------+------------+
       | USR_ID | NAME    | AGE        |
       +--------+---------+------------+
       |      1 | GFG_1      | 10           |
       +--------+---------+------------+
       */
  
        // Rollback to our beforeDeleteSavepoint
        connection.rollback(beforeDeleteSavepoint);
        connection.commit();
  
        /*    Table USER after rollback
        +--------+---------+------------+
        | USR_ID | NAME    | AGE        |
        +--------+---------+------------+
        |      1 | GFG_1   | 10            |
        |      2 | GFG_2   | 20          |
        |      3 | GFG_3   | 25            |
        +--------+---------+------------+
        */
    }
}


savepoint in a table




My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!