VisualBuilder
  Home > Java > Tutorials > Transaction Management Part-2 - JDBC Tutorial
Tell a friend
Link to us
Total Members
      Members: 84648
     
Sitemap Forum Chat
Home
JDBC Tutorial Home
1 . Introduction To JDBC
2 . Connection Interface
3 . The Data Model For the Examples
4 . Basic CRUD functionality using Statements
5 . Handling Data with Result Sets
6 . Using PreparedStatements
7 . Scrollable and Updateable ResultSets
8 . Adding, Updating and Deleting Rows using ResultSets.
9 . Using Joins in JDBC Quries.
10 . Calling procedures with Callable Statement
11 . Transaction Management Part-1
12 . Transaction Management Part-2
13 . Connection pooling And Data Sources
14 . Batch Updates Using Statements
15 . Handling Batch/SQL Errors and Warnings
16 . Handling Blob and CLOB data using JDBC
17 . Basics for Rowsets and JdbcRowSet Example
18 . CachedRowSet
19 . JoinRowSet
20 . FilterRowSet
21 . WebRowSet
22 . Next steps
 
Java Group Home
Java Discussion (273)
Java Members (27593)
Java Resources
Java Source Code (1095)
Java Articles (5)
Java Blogs
Java Jobs
Java Components (84)
Java Books
Java Websites (126)
Java News (103)
Java Q & A (114)
- Java Ask Question
- Java Questions
- Java Unanswered Questions
 
GROUPS
.NET
ASP.NET
.NET
C#
ASP
Visual Basic
Java
Java
JSP
EJB
Other
Delphi
C++
Ajax
UML
JavaScript
PHP
Web Design
Web Hosting
SQL Server
Oracle
Project Management
More Groups

 
LEARNING CENTER
TUTORIALS
.NET
.NET Tutorial
ASP Tutorial
ASP.NET Database Tutorial
ASP.NET Development Tips
ASP.Net Security,Internationalisation And Deployment
ASP.NET Server Controls Tips
ASP.NET Tutorial
C Sharp Tutorial
Web Development
Flex Tutorial
HTML Tutorial
Learn AJAX Tutorial
PHP Tutorial
Software Development
Database Tutorial
SQL Tutorial
UML Tutorial
Java
Ant Tutorial
EJB 3 Tutorial
Grails Tutorial
Hibernate Tutorial
Java 1.6 Tutorial
Java Tutorial
Java Web Component Tutorial
Java XML Tutorial
JDBC Tutorial
JDK1.5 Tutorial
JSF Tutorial
JSP And J2EE Design Tutorial
JSP Tutorial
Service-Oriented Architecture (SOA) Using Java Web Services Tutorial
Spring Tutorial
Struts Tutorial

RESOURCES
Q & A (436 )
Source Code (3275 )
Articles (11 )
Components (1589 )
News (888 )
Websites (1207 )

SUBMISSIONS
Submit Article
Submit Website
Submit News
Submit Source Code
Submit Component

COMMUNITY
Members Directory
Discussion Forum
Chat

SITE
About Us
Sitemap
Search
Contact Us
Link To Us
Feedback
Tell a Friend
Partners
Advertise


Java jdbc Tutorial
 Transaction Management Part-2
  << Prev: Transaction Management Part-1 Next: Connection pooling And Data Sources >>










 





There are some situations when you have to only rollback() to some specific statement and not all statements in a transaction. This can be achieved by introducing some labels to the statements in the transactions. These labels are known as savepoints. The JDBC 3.0 API adds the method Connection.setSavepoint, which sets a savepoint within the current transaction. The Connection.rollback method has been overloaded to take a savepoint argument.


 


The following example will demonstrate how do we use savepoints to handle the transactions more effectively.


 


Note:- The program will not change any data as the commit() is called after rollback().


 


package com.visualbuilder;


 


import java.sql.Connection;


import java.sql.DriverManager;


import java.sql.Savepoint;


import java.sql.Statement;


 


public class SavepointExample {


    public static void main(String[] args) {


        try {


            /** Loading the driver*/


                Class.forName("com.mysql.jdbc.Driver");


            /** Getting Connection*/


                                Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");


            /** Creating Statement*/


                                con.setAutoCommit(false);


                                Statement stmt= con.createStatement();


                                stmt.execute("insert into visualbuilder (id,name)values(10,'test')");


            // set savepoint


                                Savepoint savepoint1 = con.setSavepoint("SAVEPOINT_1");


                                stmt.execute("delete from visualbuilder");


                                System.out.println("rollback to savepoint called ");


                                con.rollback(savepoint1);


                                con.commit();


                                con.close();


                } catch (Exception e){


                    e.printStackTrace();


                }


        }


}


Output:-


rollback to savepoint called.




  << Prev: Transaction Management Part-1 Next: Connection pooling And Data Sources >>
Java Jdbc Tutorial Home
Give feedback and win a prize.

 
   Printer Friendly
   Email to a friend
   Add to my Favourites    
  Download PDF version
   Report Bad Submissions
   Submit Feedback
 
  Delicious   Digg   Technorati   Blink   Furl   Reddit   Newsvine   Google Click each image to add
this page to each site.
 
 
Welcome Guest Signup
MEMBER'S PANEL
EMAIL
PASSWORD
Forgot your password?
New User? Click Here!
 
Resend Activation Email!
 
SEARCH
 
 
LINKS
VoIP Internettelefonie
cell phone batteries
conferencing web
EV SSL Certificates
Video Surveillance
Gift to Pakistan
 
ADVERTISEMENT
 
PARTNER LIST

More
 
 
 

Home | Login | About Us | Contact Us | Privacy Policy | Advertising