What is SavePoint? Give an example.

1.	What is SavePoint? Give an example.
Answer» A savepoint marks a point that the current transaction can roll back to. Instead of rolling all of its changes back, it can choose to roll back only some of them. For example, suppose you start a transaction. insert 10 rows into a table. set a savepoint. insert another 5 rows. rollback to the savepoint. commit the transaction. After doing this, the table will contain the first 10 rows you inserted. The other 5 rows will have been deleted by the rollback. A savepoint is just a marker that the current transaction can roll back to.

Answer»

A savepoint marks a point that the current transaction can roll back to. Instead of rolling all of its changes back, it can choose to roll back only some of them. For example, suppose you

start a transaction.
insert 10 rows into a table.
set a savepoint.
insert another 5 rows.
rollback to the savepoint.
commit the transaction.

After doing this, the table will contain the first 10 rows you inserted. The other 5 rows will have been deleted by the rollback. A savepoint is just a marker that the current transaction can roll back to.

Discussion

No Comment Found

Related InterviewSolutions

What is difference between JDBC, JNDI and Hibernate?
How to Connect to an Excel Spreadsheet using JDBC in Java?
What is Metadata and why should you use it?
Which isolation level prevents dirty read in JDBC, connection class?
What is a "dirty read"?
What are different types of RowSet objects?
What is a RowSet?
What we set the attribute Concurrency in ResultSet?
When you say Class.forName() loads the driver class, does it mean it imports the driver class using import statement?
What does the Class.forName("MyClass") do?

What is SavePoint? Give an example.

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment