SQLiteConfig (SQLite JDBC 3.7.15-M1 API)

java.lang.Object
- org.sqlite.SQLiteConfig

```
public class SQLiteConfig
extends Object
```
SQLite Configuration See also http://www.sqlite.org/pragma.html

作成者:

leo

ネストされたクラスの概要

ネストされたクラス
修飾子とタイプ	クラスと説明
`static class`	`SQLiteConfig.DateClass`
`static class`	`SQLiteConfig.DatePrecision`
`static class`	`SQLiteConfig.Encoding`
`static class`	`SQLiteConfig.JournalMode`
`static class`	`SQLiteConfig.LockingMode`
`static class`	`SQLiteConfig.SynchronousMode`
`static class`	`SQLiteConfig.TempStore`
`static class`	`SQLiteConfig.TransactionMode`

フィールドの概要

フィールド
修飾子とタイプ	フィールドと説明
`protected int`	`busyTimeout`
`protected SQLiteConfig.DateClass`	`dateClass`
`protected long`	`dateMultiplier`
`protected SQLiteConfig.DatePrecision`	`datePrecision`
`protected String`	`dateStringFormat`
`static String`	`DEFAULT_DATE_STRING_FORMAT`

コンストラクタの概要

コンストラクタ
コンストラクタと説明
`SQLiteConfig()` Default constructor.
`SQLiteConfig(Properties prop)` Creates an SQLite configuration object using values from the given property object.

メソッドの概要

メソッド
修飾子とタイプ	メソッドと説明
`void`	`apply(Connection conn)` Configures a connection.
`Connection`	`createConnection(String url)` Create a new JDBC connection using the current configuration
`void`	`enableCaseSensitiveLike(boolean enable)` Enables or disables case sensitive for the LIKE operator.
`void`	`enableCountChanges(boolean enable)` Enables or disables the count-changes flag.
`void`	`enableEmptyResultCallBacks(boolean enable)` Enables or disables the empty_result_callbacks flag.
`void`	`enableFullColumnNames(boolean enable)` Enables or disables the full_column_name flag.
`void`	`enableFullSync(boolean enable)` Enables or disables the fullfsync flag.
`void`	`enableLoadExtension(boolean enable)` Enables or disables extension loading.
`void`	`enableRecursiveTriggers(boolean enable)` Enables or disables the recursive trigger capability.
`void`	`enableReverseUnorderedSelects(boolean enable)` Enables or disables the reverse_unordered_selects flag.
`void`	`enableShortColumnNames(boolean enable)` Enables or disables the short_column_names flag.
`void`	`enforceForeignKeys(boolean enforce)` Whether to enforce foreign key constraints.
`int`	`getOpenModeFlags()`
`SQLiteConfig.TransactionMode`	`getTransactionMode()`
`void`	`incrementalVacuum(int numberOfPagesToBeRemoved)` Sets the incremental_vacuum value; the number of pages to be removed from the freelist.
`boolean`	`isEnabledLoadExtension()` Checks if the load extension option is turned on.
`boolean`	`isEnabledSharedCache()` Checks if the shared cache option is turned on.
`void`	`resetOpenMode(SQLiteOpenMode mode)` Re-sets the open mode flags.
`void`	`setBusyTimeout(String milliseconds)`
`void`	`setCacheSize(int numberOfPages)` Changes the maximum number of database disk pages that SQLite will hold in memory at once per open database file.
`void`	`setDateClass(String dateClass)`
`void`	`setDatePrecision(String datePrecision)`
`void`	`setDateStringFormat(String dateStringFormat)`
`void`	`setDefaultCacheSize(int numberOfPages)` Sets the suggested maximum number of database disk pages that SQLite will hold in memory at once per open database file.
`void`	`setEncoding(SQLiteConfig.Encoding encoding)` Sets the text encoding used by the main database.
`void`	`setJounalSizeLimit(int limit)` Sets the journal_size_limit.
`void`	`setJournalMode(SQLiteConfig.JournalMode mode)` Sets the journal mode for databases associated with the current database connection.
`void`	`setLockingMode(SQLiteConfig.LockingMode mode)` Sets the database connection locking-mode.
`void`	`setMaxPageCount(int numPages)` Sets the maximum number of pages in the database file.
`void`	`setOpenMode(SQLiteOpenMode mode)` Sets the open mode flags.
`void`	`setPageSize(int numBytes)` Sets the page size of the database.
`void`	`setPragma(org.sqlite.SQLiteConfig.Pragma pragma, String value)` Sets a pragma's value.
`void`	`setReadOnly(boolean readOnly)` Sets the read-write mode for the database.
`void`	`setReadUncommited(boolean useReadUncommitedIsolationMode)` Enables or disables useReadUncommitedIsolationMode.
`void`	`setSharedCache(boolean enable)` Enables or disables the sharing of the database cache and schema data structures between connections to the same database.
`void`	`setSynchronous(SQLiteConfig.SynchronousMode mode)` Changes the setting of the "synchronous" flag.
`void`	`setTempStore(SQLiteConfig.TempStore storeType)` Changes the setting of the "temp_store" parameter.
`void`	`setTempStoreDirectory(String directoryName)` Changes the value of the sqlite3_temp_directory global variable, which many operating-system interface backends use to determine where to store temporary tables and indices.
`void`	`setTransactionMode(SQLiteConfig.TransactionMode transactionMode)` Sets the mode that will be used to start transactions.
`void`	`setTransactionMode(String transactionMode)` Sets the mode that will be used to start transactions.
`void`	`setUserVersion(int version)` Set the value of the user-version.
`Properties`	`toProperties()` Convert this configuration into a Properties object, which can be passed to the `DriverManager.getConnection(String, Properties)`.
`void`	`useLegacyFileFormat(boolean use)` Sets the value of the legacy_file_format flag.

クラスから継承されたメソッド java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- フィールドの詳細
  - busyTimeout
```
protected final int busyTimeout
```
  - DEFAULT_DATE_STRING_FORMAT
```
public static final String DEFAULT_DATE_STRING_FORMAT
```
    関連項目:
    定数フィールド値
  - dateClass
```
protected final SQLiteConfig.DateClass dateClass
```
  - datePrecision
```
protected final SQLiteConfig.DatePrecision datePrecision
```
  - dateMultiplier
```
protected final long dateMultiplier
```
  - dateStringFormat
```
protected final String dateStringFormat
```
- コンストラクタの詳細
  - SQLiteConfig
```
public SQLiteConfig()
```
    Default constructor.
  - SQLiteConfig
```
public SQLiteConfig(Properties prop)
```
    Creates an SQLite configuration object using values from the given property object.
    
    パラメータ:
    prop - The properties to apply to the configuration.
- メソッドの詳細
  - createConnection
```
public Connection createConnection(String url)
                            throws SQLException
```
    Create a new JDBC connection using the current configuration
    
    戻り値:
    The connection.
    
    例外:
    
    SQLException
  - apply
```
public void apply(Connection conn)
           throws SQLException
```
    Configures a connection.
    
    パラメータ:
    conn - The connection to configure.
    
    例外:
    
    SQLException
  - isEnabledSharedCache
```
public boolean isEnabledSharedCache()
```
    Checks if the shared cache option is turned on.
    
    戻り値:
    True if turned on; false otherwise.
  - isEnabledLoadExtension
```
public boolean isEnabledLoadExtension()
```
    Checks if the load extension option is turned on.
    
    戻り値:
    True if turned on; false otherwise.
  - getOpenModeFlags
```
public int getOpenModeFlags()
```
    戻り値:
    The open mode flags.
  - setPragma
```
public void setPragma(org.sqlite.SQLiteConfig.Pragma pragma,
             String value)
```
    Sets a pragma's value.
    
    パラメータ:
    pragma - The pragma to change.
    value - The value to set it to.
  - toProperties
```
public Properties toProperties()
```
    Convert this configuration into a Properties object, which can be passed to the DriverManager.getConnection(String, Properties).
    
    戻り値:
    The property object.
  - setOpenMode
```
public void setOpenMode(SQLiteOpenMode mode)
```
    Sets the open mode flags.
    
    パラメータ:
    mode - The open mode.
    関連項目:
    http://www.sqlite.org/c3ref/c_open_autoproxy.html
  - resetOpenMode
```
public void resetOpenMode(SQLiteOpenMode mode)
```
    Re-sets the open mode flags.
    
    パラメータ:
    mode - The open mode.
    関連項目:
    http://www.sqlite.org/c3ref/c_open_autoproxy.html
  - setSharedCache
```
public void setSharedCache(boolean enable)
```
    Enables or disables the sharing of the database cache and schema data structures between connections to the same database.
    
    パラメータ:
    enable - True to enable; false to disable.
    関連項目:
    www.sqlite.org/c3ref/enable_shared_cache.html
  - enableLoadExtension
```
public void enableLoadExtension(boolean enable)
```
    Enables or disables extension loading.
    
    パラメータ:
    enable - True to enable; false to disable.
    関連項目:
    www.sqlite.org/c3ref/load_extension.html
  - setReadOnly
```
public void setReadOnly(boolean readOnly)
```
    Sets the read-write mode for the database.
    
    パラメータ:
    readOnly - True for read-only; otherwise read-write.
  - setCacheSize
```
public void setCacheSize(int numberOfPages)
```
    Changes the maximum number of database disk pages that SQLite will hold in memory at once per open database file.
    
    パラメータ:
    numberOfPages - Cache size in number of pages.
    関連項目:
    www.sqlite.org/pragma.html#pragma_cache_size
  - enableCaseSensitiveLike
```
public void enableCaseSensitiveLike(boolean enable)
```
    Enables or disables case sensitive for the LIKE operator.
    
    パラメータ:
    enable - True to enable; false to disable.
    関連項目:
    www.sqlite.org/pragma.html#pragma_case_sensitive_like
  - enableCountChanges
```
public void enableCountChanges(boolean enable)
```
    Enables or disables the count-changes flag. When enabled, INSERT, UPDATE and DELETE statements return the number of rows they modified.
    
    パラメータ:
    enable - True to enable; false to disable.
    関連項目:
    www.sqlite.org/pragma.html#pragma_count_changes
  - setDefaultCacheSize
```
public void setDefaultCacheSize(int numberOfPages)
```
    Sets the suggested maximum number of database disk pages that SQLite will hold in memory at once per open database file. The cache size set here persists across database connections.
    
    パラメータ:
    numberOfPages - Cache size in number of pages.
    関連項目:
    www.sqlite.org/pragma.html#pragma_cache_size
  - enableEmptyResultCallBacks
```
public void enableEmptyResultCallBacks(boolean enable)
```
    Enables or disables the empty_result_callbacks flag.
    
    パラメータ:
    enable - True to enable; false to disable. false.
    関連項目:
    http://www.sqlite.org/pragma.html#pragma_empty_result_callbacks
  - setEncoding
```
public void setEncoding(SQLiteConfig.Encoding encoding)
```
    Sets the text encoding used by the main database.
    
    パラメータ:
    encoding - One of SQLiteConfig.Encoding
    関連項目:
    www.sqlite.org/pragma.html#pragma_encoding
  - enforceForeignKeys
```
public void enforceForeignKeys(boolean enforce)
```
    Whether to enforce foreign key constraints. This setting affects the execution of all statements prepared using the database connection, including those prepared before the setting was changed.
    
    パラメータ:
    enforce - True to enable; false to disable.
    関連項目:
    www.sqlite.org/pragma.html#pragma_foreign_keys
  - enableFullColumnNames
```
public void enableFullColumnNames(boolean enable)
```
    Enables or disables the full_column_name flag. This flag together with the short_column_names flag determine the way SQLite assigns names to result columns of SELECT statements.
    
    パラメータ:
    enable - True to enable; false to disable.
    関連項目:
    www.sqlite.org/pragma.html#pragma_full_column_names
  - enableFullSync
```
public void enableFullSync(boolean enable)
```
    Enables or disables the fullfsync flag. This flag determines whether or not the F_FULLFSYNC syncing method is used on systems that support it. The default value of the fullfsync flag is off. Only Mac OS X supports F_FULLFSYNC.
    
    パラメータ:
    enable - True to enable; false to disable.
    関連項目:
    www.sqlite.org/pragma.html#pragma_fullfsync
  - incrementalVacuum
```
public void incrementalVacuum(int numberOfPagesToBeRemoved)
```
    Sets the incremental_vacuum value; the number of pages to be removed from the freelist. The database file is truncated by the same amount.
    
    パラメータ:
    numberOfPagesToBeRemoved - The number of pages to be removed.
    関連項目:
    www.sqlite.org/pragma.html#pragma_incremental_vacuum
  - setJournalMode
```
public void setJournalMode(SQLiteConfig.JournalMode mode)
```
    Sets the journal mode for databases associated with the current database connection.
    
    パラメータ:
    mode - One of SQLiteConfig.JournalMode
    関連項目:
    www.sqlite.org/pragma.html#pragma_journal_mode
  - setJounalSizeLimit
```
public void setJounalSizeLimit(int limit)
```
    Sets the journal_size_limit. This setting limits the size of the rollback-journal and WAL files left in the file-system after transactions or checkpoints.
    
    パラメータ:
    limit - Limit value in bytes. A negative number implies no limit.
    関連項目:
    www.sqlite.org/pragma.html#pragma_journal_size_limit
  - useLegacyFileFormat
```
public void useLegacyFileFormat(boolean use)
```
    Sets the value of the legacy_file_format flag. When this flag is enabled, new SQLite databases are created in a file format that is readable and writable by all versions of SQLite going back to 3.0.0. When the flag is off, new databases are created using the latest file format which might not be readable or writable by versions of SQLite prior to 3.3.0.
    
    パラメータ:
    use - True to turn on legacy file format; false to turn off.
    関連項目:
    www.sqlite.org/pragma.html#pragma_legacy_file_format
  - setLockingMode
```
public void setLockingMode(SQLiteConfig.LockingMode mode)
```
    Sets the database connection locking-mode.
    
    パラメータ:
    mode - One of SQLiteConfig.LockingMode
    関連項目:
    www.sqlite.org/pragma.html#pragma_locking_mode
  - setPageSize
```
public void setPageSize(int numBytes)
```
    Sets the page size of the database. The page size must be a power of two between 512 and 65536 inclusive.
    
    パラメータ:
    numBytes - A power of two between 512 and 65536 inclusive.
    関連項目:
    www.sqlite.org/pragma.html#pragma_page_size
  - setMaxPageCount
```
public void setMaxPageCount(int numPages)
```
    Sets the maximum number of pages in the database file.
    
    パラメータ:
    numPages - Number of pages.
    関連項目:
    www.sqlite.org/pragma.html#pragma_max_page_count
  - setReadUncommited
```
public void setReadUncommited(boolean useReadUncommitedIsolationMode)
```
    Enables or disables useReadUncommitedIsolationMode.
    
    パラメータ:
    useReadUncommitedIsolationMode - True to turn on; false to disable. disabled otherwise.
    関連項目:
    www.sqlite.org/pragma.html#pragma_read_uncommitted
  - enableRecursiveTriggers
```
public void enableRecursiveTriggers(boolean enable)
```
    Enables or disables the recursive trigger capability.
    
    パラメータ:
    enable - True to enable the recursive trigger capability.
    関連項目:
    www.sqlite.org/pragma.html#pragma_recursive_triggers
  - enableReverseUnorderedSelects
```
public void enableReverseUnorderedSelects(boolean enable)
```
    Enables or disables the reverse_unordered_selects flag. This setting causes SELECT statements without an ORDER BY clause to emit their results in the reverse order of what they normally would. This can help debug applications that are making invalid assumptions about the result order.
    
    パラメータ:
    enable - True to enable reverse_unordered_selects.
    関連項目:
    www.sqlite.org/pragma.html#pragma_reverse_unordered_selects
  - enableShortColumnNames
```
public void enableShortColumnNames(boolean enable)
```
    Enables or disables the short_column_names flag. This flag affects the way SQLite names columns of data returned by SELECT statements.
    
    パラメータ:
    enable - True to enable short_column_names.
    関連項目:
    www.sqlite.org/pragma.html#pragma_short_column_names
  - setSynchronous
```
public void setSynchronous(SQLiteConfig.SynchronousMode mode)
```
    Changes the setting of the "synchronous" flag.
    パラメータ:
    mode - One of SQLiteConfig.SynchronousMode:
    
    OFF - SQLite continues without syncing as soon as it has handed data off to the operating system
    
    NORMAL - the SQLite database engine will still sync at the most critical moments, but less often than in FULL mode
    
    FULL - the SQLite database engine will use the xSync method of the VFS to ensure that all content is safely written to the disk surface prior to continuing. This ensures that an operating system crash or power failure will not corrupt the database.
    関連項目:
    www.sqlite.org/pragma.html#pragma_synchronous
  - setTempStore
```
public void setTempStore(SQLiteConfig.TempStore storeType)
```
    Changes the setting of the "temp_store" parameter.
    パラメータ:
    storeType - One of SQLiteConfig.TempStore:
    
    DEFAULT - the compile-time C preprocessor macro SQLITE_TEMP_STORE is used to determine where temporary tables and indices are stored
    
    FILE - temporary tables and indices are kept in as if they were pure in-memory databases memory
    
    MEMORY - temporary tables and indices are stored in a file.
    関連項目:
    www.sqlite.org/pragma.html#pragma_temp_store
  - setTempStoreDirectory
```
public void setTempStoreDirectory(String directoryName)
```
    Changes the value of the sqlite3_temp_directory global variable, which many operating-system interface backends use to determine where to store temporary tables and indices.
    
    パラメータ:
    directoryName - Directory name for storing temporary tables and indices.
    関連項目:
    www.sqlite.org/pragma.html#pragma_temp_store_directory
  - setUserVersion
```
public void setUserVersion(int version)
```
    Set the value of the user-version. The user-version is not used internally by SQLite. It may be used by applications for any purpose. The value is stored in the database header at offset 60.
    
    パラメータ:
    version - A big-endian 32-bit signed integer.
    関連項目:
    www.sqlite.org/pragma.html#pragma_user_version
  - setTransactionMode
```
public void setTransactionMode(SQLiteConfig.TransactionMode transactionMode)
```
    Sets the mode that will be used to start transactions.
    
    パラメータ:
    transactionMode - One of SQLiteConfig.TransactionMode.
    関連項目:
    http://www.sqlite.org/lang_transaction.html
  - setTransactionMode
```
public void setTransactionMode(String transactionMode)
```
    Sets the mode that will be used to start transactions.
    
    パラメータ:
    transactionMode - One of DEFFERED, IMMEDIATE or EXCLUSIVE.
    関連項目:
    http://www.sqlite.org/lang_transaction.html
  - getTransactionMode
```
public SQLiteConfig.TransactionMode getTransactionMode()
```
    戻り値:
    The transaction mode.
  - setDatePrecision
```
public void setDatePrecision(String datePrecision)
                      throws SQLException
```
    パラメータ:
    datePrecision - One of SECONDS or MILLISECONDS
    
    例外:
    
    SQLException
  - setDateClass
```
public void setDateClass(String dateClass)
```
    パラメータ:
    dateClass - One of INTEGER, TEXT or REAL
  - setDateStringFormat
```
public void setDateStringFormat(String dateStringFormat)
```
    パラメータ:
    dateStringFormat - Format of date string
  - setBusyTimeout
```
public void setBusyTimeout(String milliseconds)
```
    パラメータ:
    milliseconds - Connect to DB timeout in milliseconds

クラス SQLiteConfig

ネストされたクラスの概要

フィールドの概要

コンストラクタの概要

メソッドの概要

クラスから継承されたメソッド java.lang.Object

フィールドの詳細

busyTimeout

DEFAULT_DATE_STRING_FORMAT

dateClass

datePrecision

dateMultiplier

dateStringFormat

コンストラクタの詳細

SQLiteConfig

SQLiteConfig

メソッドの詳細

createConnection

apply

isEnabledSharedCache

isEnabledLoadExtension

getOpenModeFlags

setPragma

toProperties

setOpenMode

resetOpenMode

setSharedCache

enableLoadExtension

setReadOnly

setCacheSize

enableCaseSensitiveLike

enableCountChanges

setDefaultCacheSize

enableEmptyResultCallBacks

setEncoding

enforceForeignKeys

enableFullColumnNames

enableFullSync

incrementalVacuum

setJournalMode

setJounalSizeLimit

useLegacyFileFormat

setLockingMode

setPageSize

setMaxPageCount

setReadUncommited

enableRecursiveTriggers

enableReverseUnorderedSelects

enableShortColumnNames

setSynchronous

setTempStore

setTempStoreDirectory

setUserVersion

setTransactionMode

setTransactionMode

getTransactionMode

setDatePrecision

setDateClass

setDateStringFormat

setBusyTimeout