Committing a Transaction

Committing a Transaction

When you set the auto-commit mode to false, the operation perfomed by SQL statements are not reflected permanently in a database. You need to explicitly call the commit() method of the Connection interface to reflect the changes made by the transactions in the database. All the SQL statements that appear between two commit() methods are treated as a single transaction and are executed as asingle unit.

public class createTrans
{
public static void main(String args[])
{
try
{
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
Connection con=DriverManager.getConnection(“jdbc:odbc:MyDataSource”, ” ”, “ ”);
PreparedStatement ps=con.preparedStatement(“INSERT into product(p_id,p_desc) VALUES (?,?)”);
Ps.setInt(1,1008);
Ps.setString(2,”Hard Disk”);
Int firstctr=ps.executeUpdate();
System.out.println(“First row inserted but not commited”);
ps=con.preparedStatement(“INSERT into product(p_id,p_desc) VALUES (?,?)”);
Ps.setInt(1,1009);
Ps.setString(2,”Hard Disk2”);
Int firstctr=ps.executeUpdate();
System.out.println(“Second row inserted but not commited”);
Con.commit();
System.out.println(“Transaction Committed”);
Ps.close();
Con.close();
}
catch(Exception e)
{
System.out.println(“Error :” +e);
}
}
}