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.