Stay organized with collections
Save and categorize content based on your preferences.
SQLiteMisuseException
open class SQLiteMisuseException : SQLiteException
This error can occur if the application creates a SQLiteStatement object and allows multiple threads in the application use it at the same time. Sqlite returns this error if bind and execute methods on this object occur at the same time from multiple threads, like so: thread # 1: in execute() method of the SQLiteStatement object while thread # 2: is in bind..() on the same object.
FIX this by NEVER sharing the same SQLiteStatement object between threads. Create a local instance of the SQLiteStatement whenever it is needed, use it and close it ASAP. NEVER make it globally available.
Summary
Public constructors
SQLiteMisuseException
SQLiteMisuseException()
SQLiteMisuseException
SQLiteMisuseException(error: String!)
Content and code samples on this page are subject to the licenses described in the Content License. Java and OpenJDK are trademarks or registered trademarks of Oracle and/or its affiliates.
Last updated 2025-02-10 UTC.
[null,null,["Last updated 2025-02-10 UTC."],[],[],null,["# SQLiteMisuseException\n\nAdded in [API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels)\n\nSQLiteMisuseException\n=====================\n\n*** ** * ** ***\n\nKotlin \\|[Java](/reference/android/database/sqlite/SQLiteMisuseException \"View this page in Java\") \n\n```\nopen class SQLiteMisuseException : SQLiteException\n```\n\n|---|---|---|---|---|---|----------------------------------------------------|\n| [kotlin.Any](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html) |||||||\n| ↳ | [kotlin.Throwable](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-throwable/index.html) ||||||\n| | ↳ | [java.lang.Exception](../../../java/lang/Exception.html#) |||||\n| | | ↳ | [java.lang.RuntimeException](../../../java/lang/RuntimeException.html#) ||||\n| | | | ↳ | [android.database.SQLException](../SQLException.html#) |||\n| | | | | ↳ | [android.database.sqlite.SQLiteException](/reference/kotlin/android/database/sqlite/SQLiteException) ||\n| | | | | | ↳ | [android.database.sqlite.SQLiteMisuseException](#) |\n\nThis error can occur if the application creates a SQLiteStatement object and allows multiple threads in the application use it at the same time. Sqlite returns this error if bind and execute methods on this object occur at the same time from multiple threads, like so: thread # 1: in execute() method of the SQLiteStatement object while thread # 2: is in bind..() on the same object.\n\n\u003cbr /\u003e\n\nFIX this by NEVER sharing the same SQLiteStatement object between threads. Create a local instance of the SQLiteStatement whenever it is needed, use it and close it ASAP. NEVER make it globally available.\n\nSummary\n-------\n\n| Public constructors ||\n|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------|---|\n| [SQLiteMisuseException](#SQLiteMisuseException())`()` \u003cbr /\u003e |\n| [SQLiteMisuseException](#SQLiteMisuseException(kotlin.String))`(`error:` `[String](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-string/index.html)!`)` \u003cbr /\u003e |\n\nPublic constructors\n-------------------\n\n### SQLiteMisuseException\n\nAdded in [API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) \n\n```\nSQLiteMisuseException()\n``` \n\n### SQLiteMisuseException\n\nAdded in [API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) \n\n```\nSQLiteMisuseException(error: String!)\n```"]]
