<@U5FHN1J7L> i implemented that but getting `java.lang.IllegalStateException: Cannot perform this op...

# android

[Kevin Janvier Chinabalire]

@Kulwinder Singh i implemented that but getting
java.lang.IllegalStateException: Cannot perform this operation because there is no current transaction.

It run for the first time then crash for second time

fun clearAndResetAllTables(): Boolean {
        if (db== null) return false

        // reset all auto-incrementalValues
        val query = SimpleSQLiteQuery("DELETE FROM sqlite_sequence")

        db!!.beginTransaction()
        return try {
            db!!.clearAllTables()
            db!!.query(query)
            db!!.setTransactionSuccessful()
            true
        } catch (e: Exception){
            false
        } finally {
            db!!.endTransaction()
        }
    }

[gildor]

Terrible code style, do not copy this in your project. all those !!

[gildor]

In general code looks correct, check that you call beginTransaction all the time before endTransaction

[Denis A]

replace first string to val db = db ?: return

[gildor]

yes, exactly.

[gildor]

I will propose change original SO comment to avoid all those !!

[Kevin Janvier Chinabalire]

I do end the transaction ….
but am getting this Cannot perform this operation because there is no current transaction.

[Kevin Janvier Chinabalire]

I get a crash on finally block …

[Kevin Janvier Chinabalire]

it has worked .. i add a check inside finally

[gildor]

I do end the transaction

This error about begin transaction, not about end transaction
Check that you begin transaction in all cases and that you don’t call this method concurrently