Check if SQL query has succeed on Android SQLite

Question

I'm dealing with the execSQL function from Android SQLite API. Since I pass query as a parameter, I execute it straight through this function, so I'm not processing it (and I'd prefer not to do it) to know if we are CREATING, INSERTING, DELETING, ...

The point is: is there any generic way to know if the SQL execution has succeed?

Thank you in advance !

Answer 1

execSQL throws SQLException if the SQL string is invalid. You can also wrap your statement into transaction using the model:

   db.beginTransaction();
   try {
     ...
     db.setTransactionSuccessful();
   } finally {
     db.endTransaction();
   }

Answer 2

I usually wrap my try{...}finally{...} blocks with a listener ( beginTransactionWithListener(SQLiteTransactionListener transactionListener)), and use the transactionListner to check whether everything went well within the transaction, in addition to everything within the try/finally.