May 28, 2015
Throw to Know (Android SQLite Database)
An important error which I noticed that a simple insert operation in a sqlite table was not throwing exception when it was failing against the UNIQUE key constraint on one or more columns.
So simple solution to do this is on the SQLiteDatabase instance :
1. either use rawQuery() method to insert. 2. or use insertOrThrow() method
Both throws the required SQLException.