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:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: