Multiple inserts in same transaction

[Martin Lira]

Guys,
I am looking for some jdbc transaction mechanism. I dont want to user JTA.
Here is my problem:
I need to make two inserts into two different tables.

 
boolean success = false;
Connection con = getConnection();//returns con from pool
PrepareStatement ps1 = con.prepareStatement("Insert 1");
 
if (ps1.executeUpdate() > 0) {
PrepareStatement ps2 = con.prepareStatement("Insert 2");
 if (ps2.executeUpdate() > 0) {
     success = true;
  }
}
return success;

I need to execute both inserts in same transaction. If the first is ok but second fails then the first insert must roll back.
Is there any way in jdbc you can control the transaction and roll back?

Thanks!
Martin

[Shailesh Chandra]

Connection con = null;
try
{
    con = getConnection();
    con.setAutoCommit(false);
    //Insert code 
    con.commit();
}
catch(SQLException se)
{
  con.rollback();
}
finally
{
   if(con !=null)
   {
     con.close();
   }
}