Save the date! Android Dev Summit is coming to Sunnyvale, CA on Oct 23-24, 2019.

SQLiteDatabase.OpenParams.Builder

public static final class SQLiteDatabase.OpenParams.Builder
extends Object

java.lang.Object
   ↳ android.database.sqlite.SQLiteDatabase.OpenParams.Builder


Builder for OpenParams.

Summary

Public constructors

SQLiteDatabase.OpenParams.Builder()
SQLiteDatabase.OpenParams.Builder(SQLiteDatabase.OpenParams params)

Public methods

SQLiteDatabase.OpenParams.Builder addOpenFlags(int openFlags)

Adds flags to control database access mode

SQLiteDatabase.OpenParams build()

Creates an instance of OpenParams with the options that were previously set on this builder

SQLiteDatabase.OpenParams.Builder removeOpenFlags(int openFlags)

Removes database access mode flags

SQLiteDatabase.OpenParams.Builder setCursorFactory(SQLiteDatabase.CursorFactory cursorFactory)

Set an optional factory class that is called to instantiate a cursor when query is called.

SQLiteDatabase.OpenParams.Builder setErrorHandler(DatabaseErrorHandler errorHandler)

Sets DatabaseErrorHandler object to handle db corruption errors

SQLiteDatabase.OpenParams.Builder setIdleConnectionTimeout(long idleConnectionTimeoutMs)

This method was deprecated in API level Q. DO NOT USE this method unless you fully understand the implication of what it does.

SQLiteDatabase.OpenParams.Builder setJournalMode(String journalMode)

Sets journal mode to use when SQLiteDatabase#ENABLE_WRITE_AHEAD_LOGGING flag is not set.

SQLiteDatabase.OpenParams.Builder setLookasideConfig(int slotSize, int slotCount)

Configures lookaside memory allocator

SQLite default settings will be used, if this method isn't called.

SQLiteDatabase.OpenParams.Builder setOpenFlags(int openFlags)

Sets flags to control database access mode

SQLiteDatabase.OpenParams.Builder setSynchronousMode(String syncMode)

w Sets synchronous mode .

Inherited methods

Public constructors

SQLiteDatabase.OpenParams.Builder

Added in API level 27
public SQLiteDatabase.OpenParams.Builder ()

SQLiteDatabase.OpenParams.Builder

Added in API level 27
public SQLiteDatabase.OpenParams.Builder (SQLiteDatabase.OpenParams params)

Parameters
params SQLiteDatabase.OpenParams

Public methods

addOpenFlags

Added in API level 27
public SQLiteDatabase.OpenParams.Builder addOpenFlags (int openFlags)

Adds flags to control database access mode

Parameters
openFlags int: The new flags to add Value is either 0 or a combination of SQLiteDatabase.OPEN_READWRITE, SQLiteDatabase.OPEN_READONLY, SQLiteDatabase.CREATE_IF_NECESSARY, SQLiteDatabase.NO_LOCALIZED_COLLATORS, and SQLiteDatabase.ENABLE_WRITE_AHEAD_LOGGING

Returns
SQLiteDatabase.OpenParams.Builder same builder instance for chaining multiple calls into a single statement This value will never be null.

build

Added in API level 27
public SQLiteDatabase.OpenParams build ()

Creates an instance of OpenParams with the options that were previously set on this builder

Returns
SQLiteDatabase.OpenParams This value will never be null.

removeOpenFlags

Added in API level 27
public SQLiteDatabase.OpenParams.Builder removeOpenFlags (int openFlags)

Removes database access mode flags

Parameters
openFlags int: Flags to remove Value is either 0 or a combination of SQLiteDatabase.OPEN_READWRITE, SQLiteDatabase.OPEN_READONLY, SQLiteDatabase.CREATE_IF_NECESSARY, SQLiteDatabase.NO_LOCALIZED_COLLATORS, and SQLiteDatabase.ENABLE_WRITE_AHEAD_LOGGING

Returns
SQLiteDatabase.OpenParams.Builder same builder instance for chaining multiple calls into a single statement This value will never be null.

setCursorFactory

Added in API level 27
public SQLiteDatabase.OpenParams.Builder setCursorFactory (SQLiteDatabase.CursorFactory cursorFactory)

Set an optional factory class that is called to instantiate a cursor when query is called.

Parameters
cursorFactory SQLiteDatabase.CursorFactory: instance This value may be null.

Returns
SQLiteDatabase.OpenParams.Builder same builder instance for chaining multiple calls into a single statement This value will never be null.

setErrorHandler

Added in API level 27
public SQLiteDatabase.OpenParams.Builder setErrorHandler (DatabaseErrorHandler errorHandler)

Sets DatabaseErrorHandler object to handle db corruption errors

Parameters
errorHandler DatabaseErrorHandler: This value may be null.

Returns
SQLiteDatabase.OpenParams.Builder This value will never be null.

setIdleConnectionTimeout

Added in API level 27
Deprecated in API level Q
public SQLiteDatabase.OpenParams.Builder setIdleConnectionTimeout (long idleConnectionTimeoutMs)

This method was deprecated in API level Q.
DO NOT USE this method unless you fully understand the implication of what it does.

Sets the maximum number of milliseconds that SQLite connection is allowed to be idle before it is closed and removed from the pool.

DO NOT USE this method unless you fully understand the implication of what it does. A connection timeout allows the system to internally close a connection to a SQLite database after a given timeout. This is good for reducing app's memory consumption, but it has side effects that are hard to predict. For example, SQLite internally maintains a lot of "per-connection" states that apps can typically modify with a PRAGMA statement, and such states will be reset once the connection is closed. The system does not provide a callback that would allow apps to reconfigure a newly created connection and thus there's no way to re-configure connections when they're re-made internally. Do not use it unless you're sure your app uses no per-connection states.

Parameters
idleConnectionTimeoutMs long: timeout in milliseconds. Use Long#MAX_VALUE to allow unlimited idle connections. Value is 0 or greater

Returns
SQLiteDatabase.OpenParams.Builder This value will never be null.

setJournalMode

Added in API level 28
public SQLiteDatabase.OpenParams.Builder setJournalMode (String journalMode)

Sets journal mode to use when SQLiteDatabase#ENABLE_WRITE_AHEAD_LOGGING flag is not set.

Parameters
journalMode String: This value must never be null.

Returns
SQLiteDatabase.OpenParams.Builder This value will never be null.

setLookasideConfig

Added in API level 27
public SQLiteDatabase.OpenParams.Builder setLookasideConfig (int slotSize, 
                int slotCount)

Configures lookaside memory allocator

SQLite default settings will be used, if this method isn't called. Use setLookasideConfig(0,0) to disable lookaside

Note: Provided slotSize/slotCount configuration is just a recommendation. The system may choose different values depending on a device, e.g. lookaside allocations can be disabled on low-RAM devices

Parameters
slotSize int: The size in bytes of each lookaside slot. Value is 0 or greater

slotCount int: The total number of lookaside memory slots per database connection. Value is 0 or greater

Returns
SQLiteDatabase.OpenParams.Builder

setOpenFlags

Added in API level 27
public SQLiteDatabase.OpenParams.Builder setOpenFlags (int openFlags)

Sets flags to control database access mode

Parameters
openFlags int: The new flags to set Value is either 0 or a combination of SQLiteDatabase.OPEN_READWRITE, SQLiteDatabase.OPEN_READONLY, SQLiteDatabase.CREATE_IF_NECESSARY, SQLiteDatabase.NO_LOCALIZED_COLLATORS, and SQLiteDatabase.ENABLE_WRITE_AHEAD_LOGGING

Returns
SQLiteDatabase.OpenParams.Builder same builder instance for chaining multiple calls into a single statement This value will never be null.

setSynchronousMode

Added in API level 28
public SQLiteDatabase.OpenParams.Builder setSynchronousMode (String syncMode)

w Sets synchronous mode .

Parameters
syncMode String: This value must never be null.

Returns
SQLiteDatabase.OpenParams.Builder This value will never be null.