Java JDBC Savepoint And Rollback

Chapter: JDBC Last Updated: 10-09-2016 07:26:57 UTC

Program:

            /* ............... START ............... */
                
import java.sql.*;

public class JavaJDBCSavePointRollback {
	
	 public static void main(String[] args) throws Exception{
	      Class.forName("org.apache.derby.jdbc.ClientDriver");
	      Connection con = DriverManager.getConnection
	      ("jdbc:derby://localhost:1527/testDb","name","pass");
	      Statement stmt = con.createStatement();
	      String query1 = "insert into emp values(5,'name','job')";
	      String query2 = "select * from emp";
	      con.setAutoCommit(false);
	      Savepoint spt1 = con.setSavepoint("svpt1");
	      stmt.execute(query1);
	      ResultSet rs = stmt.executeQuery(query2);
	      int no_of_rows = 0;
	      while (rs.next()) {
	         no_of_rows++;
	      }
	      System.out.println("rows before rollback statement = "
	      + no_of_rows);
	      con.rollback(spt1);
	      con.commit();
	      no_of_rows = 0;
	      rs = stmt.executeQuery(query2);
	      while (rs.next()) {
	         no_of_rows++;
	      }
	      System.out.println("rows after rollback statement = "
	      + no_of_rows);
	   }
}
                /* ............... END ............... */
        

Tags

JDBC Savepoint And Rollback, Java, JDBC

Similar Programs Chapter Last Updated
Java Execute Multiple SQL Statements JDBC 10-09-2016
Java JDBC Commit Statement Example JDBC 10-09-2016
Java JDBC Sort Table Contents JDBC 10-09-2016
Java JDBC Search Table Contents JDBC 10-09-2016
Java JDBC Update Table JDBC 10-09-2016
Java Retrieve Table Contents JDBC 10-09-2016
Java JDBC Table Edit Example JDBC 10-09-2016
Java Connect To Database Example JDBC 10-09-2016
JDBC SQL Cursors Using CallableStatement JDBC 26-06-2016
JDBC Batch Execution In Java Using CallableStatement JDBC 26-06-2016
JDBC Stored Procedure Returns OUT Parameters In Java JDBC 23-06-2016
JDBC Stored Procedure Execution In Java JDBC 23-06-2016
JDBC Prepared Statement With ResultSet In Java Example JDBC 18-06-2016
JDBC Prepared Statement In Java Example JDBC 18-06-2016
JDBC Update Query In Java Example JDBC 18-06-2016
JDBC Query Execution In Java Example JDBC 18-06-2016
JDBC Query In Java Example JDBC 18-06-2016
Java JDBC Connection Example JDBC 18-06-2016

1