Description: ------------ As I try to catch the exception throw by tableBrowser while insert a row which call "MDB2 Error: null value violates not-null constraint " try { $browser->insertRow($arr); }catch (MDB2_TableBrowser_DBException $e) { do sth. } but it seems like haven't throw a exception but ouput error message from $this->mdb2->extended->executeMultiple Can anyone tell me how to catch exception here? Expected result: ---------------- Can anyone tell me how to catch exception here?

Insert operations are always done in batch, so the problem in your case may be that some of the insert operations are executing fine but others are failing. A possible workaround is to find the number of affected rows being returned...this is what it returns if any of the insert operations succeeded. If they are less than the number of rows being inserted then you can detect the problem. At that point you can abort the transaction, or deal with it appropriately.

It makes sense to add this test to the table browser itself and then raise the exception there.

-Status: Open +Status: Verified can this be more specific? thanks :)

Instead of this: ######### try { $browser->insertRow($arr); }catch (MDB2_TableBrowser_DBException $e) { do sth. } Do this: ##### try { $numRows = count($arr); $numInserted = $browser->insertRow($arr); if($numInserted < $numRows){ //Some inserted have failed deal with the error here... } }catch (MDB2_TableBrowser_DBException $e) { do sth. }