Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Java
Expertise: Intermediate
Aug 14, 2003

How to Use SavePoint in JDBC

Say Employee_Table has fields like EMP_NO, EMP_NAME, etc. In java, try this:

  try{
   Connection conn =...//opening connection.
   PreparedStament ps = con.prepareStatement("Select

   conn.setAutoCommit(false);

    Statement stmt = conn.createStatement();
    stmt.addBatch( sql 1st insert stmt1 );
    stmt.addBatch( sql 2nd insert stmt1 );
    ...
    ....
    // Set a named savepoint.
    Savepoint svpt = conn.setSavepoint("NewSavepoint");
    ...
    stmt.addBatch( sql nth insert stmt  );
    ....

    if(some condition)
    {
    }
    else  //condition not satisfies then rollback
    {
      conn.rollback(svpt);
    }
    int rowsAfted = stmt.executeBatch( );

    conn.commit(); //this commits only the statements before set save
point method

    }
    catch(..)
    {
      ..
    }
Elayaraja David
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap