Does Your RDBMS Support Savepoints?

Does Your RDBMS Support Savepoints?

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.


Share the Post: