Before using savepoints in your application, you need to be sure that your RDBMS supports this facility. To do this, call the
DatabaseMetaData.supportsSavepoints method, like this:
Connection conn=null;
DatabaseMetaData dmd=null;
...
try{
dmd=conn.getMetaData();
if(dmd.supportsSavepoints())
System.out.println(TRUE);
else
System.out.println(FALSE);
}catch(SQLException e)
{System.out.println(e.getMessage());}
...
Note: This tip applies to JDBC 3.0 and higher drivers.