Package org.sqlite.core

Class DB

java.lang.Object

org.sqlite.core.DB

All Implemented Interfaces:

Codes

Direct Known Subclasses:

NativeDB

public abstract class DB
extends Object
implements Codes

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static interface	DB.ProgressObserver

Field Summary

Fields inherited from interface org.sqlite.core.Codes

SQLITE_ABORT, SQLITE_AUTH, SQLITE_BLOB, SQLITE_BUSY, SQLITE_CANTOPEN, SQLITE_CONSTRAINT, SQLITE_CORRUPT, SQLITE_DONE, SQLITE_EMPTY, SQLITE_ERROR, SQLITE_FLOAT, SQLITE_FULL, SQLITE_INTEGER, SQLITE_INTERNAL, SQLITE_INTERRUPT, SQLITE_IOERR, SQLITE_LOCKED, SQLITE_MISMATCH, SQLITE_MISUSE, SQLITE_NOLFS, SQLITE_NOMEM, SQLITE_NOTFOUND, SQLITE_NULL, SQLITE_OK, SQLITE_PERM, SQLITE_PROTOCOL, SQLITE_READONLY, SQLITE_ROW, SQLITE_SCHEMA, SQLITE_TEXT, SQLITE_TOOBIG

Constructor Summary

Constructors

Constructor	Description
DB(String url, String fileName, SQLiteConfig config)

Method Summary

Modifier and Type	Method	Description
protected abstract void	_close()	Closes the SQLite interface to a database.
abstract int	_exec(String sql)	Complies, evaluates, executes and commits an SQL statement.
protected abstract void	_open(String filename, int openFlags)	Creates an SQLite interface to a database with the provided open flags.
void	addCommitListener(SQLiteCommitListener listener)
void	addUpdateListener(SQLiteUpdateListener listener)
abstract int	backup(String dbName, String destFileName, DB.ProgressObserver observer)
abstract int	backup(String dbName, String destFileName, DB.ProgressObserver observer, int sleepTimeMillis, int nTimeouts, int pagesPerStep)
abstract void	busy_handler(BusyHandler busyHandler)	Sets a busy handler that sleeps for a specified amount of time when a table is locked.
abstract void	busy_timeout(int ms)	Sets a busy handler that sleeps for a specified amount of time when a table is locked.
abstract long	changes()
abstract int	clear_bindings(long stmt)	Reset all bindings on a prepared statement (reset all host parameters to NULL).
abstract void	clear_progress_handler()
final void	close()	Closes a database connection and finalizes any remaining statements before the closing operation.
abstract byte[]	column_blob(long stmt, int col)
abstract int	column_count(long stmt)
abstract String	column_decltype(long stmt, int col)
abstract double	column_double(long stmt, int col)
abstract int	column_int(long stmt, int col)
abstract long	column_long(long stmt, int col)
abstract String	column_name(long stmt, int col)
final String[]	column_names(long stmt)	Returns an array of column names in the result set of the SELECT statement.
abstract String	column_table_name(long stmt, int col)
abstract String	column_text(long stmt, int col)
abstract int	column_type(long stmt, int col)
abstract int	create_collation(String name, Collation c)	Create a user defined collation with given collation name and the collation object.
abstract int	create_function(String name, Function f, int nArgs, int flags)	Create a user defined function with given function name and the function object.
abstract void	deserialize(String schema, byte[] buff)
abstract int	destroy_collation(String name)	Create a user defined collation with given collation name and the collation object.
abstract int	destroy_function(String name)	De-registers a user defined function
abstract int	enable_load_extension(boolean enable)	Enables or disables loading of SQLite extensions.
final void	exec(String sql, boolean autoCommit)	Executes an SQL statement using the process of compiling, evaluating, and destroying the prepared statement object.
final boolean	execute(CoreStatement stmt, Object[] vals)
final long	executeUpdate(CoreStatement stmt, Object[] vals)	Execute an SQL INSERT, UPDATE or DELETE statement with the Stmt object and an array of parameter values of the SQL statement..
protected abstract int	finalize(long stmt)	Destroys a prepared statement.
int	finalize(SafeStmtPtr safePtr, long ptr)	Destroys a statement.
SQLiteConfig	getConfig()
String	getUrl()
abstract void	interrupt()	Aborts any pending operation and returns at its earliest opportunity.
boolean	isClosed()
abstract String	libversion()	Returns the value for SQLITE_VERSION, SQLITE_VERSION_NUMBER, and SQLITE_SOURCE_ID C preprocessor macros that are associated with the library.
abstract int	limit(int id, int value)
static SQLiteException	newSQLException(int errorCode, String errorMessage)	Throws formatted SQLException with error code and message.
final void	open(String file, int openFlags)	Creates an SQLite interface to a database for the given connection.
protected abstract SafeStmtPtr	prepare(String sql)	Complies an SQL statement.
final void	prepare(CoreStatement stmt)	Complies the an SQL statement.
abstract void	register_progress_handler(int vmCalls, ProgressHandler progressHandler)	Progress handler
void	removeCommitListener(SQLiteCommitListener listener)
void	removeUpdateListener(SQLiteUpdateListener listener)
abstract int	reset(long stmt)	Sets a prepared statement object back to its initial state, ready to be re-executed.
abstract int	restore(String dbName, String sourceFileName, DB.ProgressObserver observer)
abstract int	restore(String dbName, String sourceFileName, DB.ProgressObserver observer, int sleepTimeMillis, int nTimeouts, int pagesPerStep)
abstract void	result_blob(long context, byte[] val)	Sets the result of an SQL function as blob data type with the pointer to the SQLite database context and the the result value of byte array.
abstract void	result_double(long context, double val)	Sets the result of an SQL function as double data type with the pointer to the SQLite database context and the the result value of double.
abstract void	result_error(long context, String err)	Sets the result of an SQL function as an error with the pointer to the SQLite database context and the the error of String.
abstract void	result_int(long context, int val)	Sets the result of an SQL function as int data type with the pointer to the SQLite database context and the the result value of int.
abstract void	result_long(long context, long val)	Sets the result of an SQL function as long data type with the pointer to the SQLite database context and the the result value of long.
abstract void	result_null(long context)	Sets the result of an SQL function as NULL with the pointer to the SQLite database context.
abstract void	result_text(long context, String val)	Sets the result of an SQL function as text data type with the pointer to the SQLite database context and the the result value of String.
abstract byte[]	serialize(String schema)
abstract int	shared_cache(boolean enable)	Enables or disables the sharing of the database cache and schema data structures between connections to the same database.
abstract int	step(long stmt)	Evaluates a statement.
final void	throwex(int errorCode)	Throws SQLException with error code.
abstract long	total_changes()
abstract byte[]	value_blob(Function f, int arg)
abstract double	value_double(Function f, int arg)
abstract int	value_int(Function f, int arg)	Accesses the parameter values on the function or aggregate in int data type with the function object and the parameter value.
abstract long	value_long(Function f, int arg)
abstract String	value_text(Function f, int arg)
abstract int	value_type(Function f, int arg)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

DB

public DB(String url,
 String fileName,
 SQLiteConfig config)
   throws SQLException

Throws:

SQLException

Method Details

getUrl

public String getUrl()

isClosed

public boolean isClosed()

getConfig

public SQLiteConfig getConfig()

interrupt

public abstract void interrupt()
                        throws SQLException

Aborts any pending operation and returns at its earliest opportunity.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/interrupt.html

busy_timeout

public abstract void busy_timeout(int ms)
                           throws SQLException

Sets a busy handler that sleeps for a specified amount of time when a table is locked.

Parameters:

ms - Time to sleep in milliseconds.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/busy_timeout.html

busy_handler

public abstract void busy_handler(BusyHandler busyHandler)
                           throws SQLException

Sets a busy handler that sleeps for a specified amount of time when a table is locked.

Parameters:

busyHandler -

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/busy_timeout.html

libversion

public abstract String libversion()
                           throws SQLException

Returns the value for SQLITE_VERSION, SQLITE_VERSION_NUMBER, and SQLITE_SOURCE_ID C preprocessor macros that are associated with the library.

Returns:

Compile-time SQLite version information.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/libversion.html
• https://www.sqlite.org/c3ref/c_source_id.html

changes

public abstract long changes()
                      throws SQLException

Returns:

Number of rows that were changed, inserted or deleted by the last SQL statement

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/changes.html

total_changes

public abstract long total_changes()
                            throws SQLException

Returns:

Number of row changes caused by INSERT, UPDATE or DELETE statements since the database connection was opened.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/total_changes.html

shared_cache

public abstract int shared_cache(boolean enable)
                          throws SQLException

Enables or disables the sharing of the database cache and schema data structures between connections to the same database.

Parameters:

enable - True to enable; false otherwise.

Returns:

Result Codes

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/enable_shared_cache.html
• SQLiteErrorCode

enable_load_extension

public abstract int enable_load_extension(boolean enable)
                                   throws SQLException

Enables or disables loading of SQLite extensions.

Parameters:

enable - True to enable; false otherwise.

Returns:

Result Codes

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/load_extension.html

exec

public final void exec(String sql,
 boolean autoCommit)
                throws SQLException

Executes an SQL statement using the process of compiling, evaluating, and destroying the prepared statement object.

Parameters:

sql - SQL statement to be executed.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/exec.html

open

public final void open(String file,
 int openFlags)
                throws SQLException

Creates an SQLite interface to a database for the given connection.

Parameters:

file - The database.

openFlags - File opening configurations (https://www.sqlite.org/c3ref/c_open_autoproxy.html)

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/open.html

close

public final void close()
                 throws SQLException

Closes a database connection and finalizes any remaining statements before the closing operation.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/close.html

prepare

public final void prepare(CoreStatement stmt)
                   throws SQLException

Complies the an SQL statement.

Parameters:

stmt - The SQL statement to compile.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/prepare.html

finalize

public int finalize(SafeStmtPtr safePtr,
 long ptr)
             throws SQLException

Destroys a statement.

Parameters:

safePtr - the pointer wrapper to remove from internal structures

ptr - the raw pointer to free

Returns:

Result Codes

Throws:

SQLException - if finalization fails

See Also:

• https://www.sqlite.org/c3ref/finalize.html

_open

protected abstract void _open(String filename,
 int openFlags)
                       throws SQLException

Creates an SQLite interface to a database with the provided open flags.

Parameters:

filename - The database to open.

openFlags - File opening configurations (https://www.sqlite.org/c3ref/c_open_autoproxy.html)

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/open.html

_close

protected abstract void _close()
                        throws SQLException

Closes the SQLite interface to a database.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/close.html

_exec

public abstract int _exec(String sql)
                   throws SQLException

Complies, evaluates, executes and commits an SQL statement.

Parameters:

sql - An SQL statement.

Returns:

Result Codes

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/exec.html

prepare

protected abstract SafeStmtPtr prepare(String sql)
                                throws SQLException

Complies an SQL statement.

Parameters:

sql - An SQL statement.

Returns:

Result Codes

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/prepare.html

finalize

protected abstract int finalize(long stmt)
                         throws SQLException

Destroys a prepared statement.

Parameters:

stmt - Pointer to the statement pointer.

Returns:

Result Codes

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/finalize.html

step

public abstract int step(long stmt)
                  throws SQLException

Evaluates a statement.

Parameters:

stmt - Pointer to the statement.

Returns:

Result Codes

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/step.html

reset

public abstract int reset(long stmt)
                   throws SQLException

Sets a prepared statement object back to its initial state, ready to be re-executed.

Parameters:

stmt - Pointer to the statement.

Returns:

Result Codes

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/reset.html

clear_bindings

public abstract int clear_bindings(long stmt)
                            throws SQLException

Reset all bindings on a prepared statement (reset all host parameters to NULL).

Parameters:

stmt - Pointer to the statement.

Returns:

Result Codes

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/clear_bindings.html

column_count

public abstract int column_count(long stmt)
                          throws SQLException

Parameters:

stmt - Pointer to the statement.

Returns:

Number of columns in the result set returned by the prepared statement.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/column_count.html

column_type

public abstract int column_type(long stmt,
 int col)
                         throws SQLException

Parameters:

stmt - Pointer to the statement.

col - Number of column.

Returns:

Datatype code for the initial data type of the result column.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/column_blob.html

column_decltype

public abstract String column_decltype(long stmt,
 int col)
                                throws SQLException

Parameters:

stmt - Pointer to the statement.

col - Number of column.

Returns:

Declared type of the table column for prepared statement.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/column_decltype.html

column_table_name

public abstract String column_table_name(long stmt,
 int col)
                                  throws SQLException

Parameters:

stmt - Pointer to the statement.

col - Number of column.

Returns:

Original text of column name which is the declared in the CREATE TABLE statement.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/column_database_name.html

column_name

public abstract String column_name(long stmt,
 int col)
                            throws SQLException

Parameters:

stmt - Pointer to the statement.

col - The number of column.

Returns:

Name assigned to a particular column in the result set of a SELECT statement.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/column_name.html

column_text

public abstract String column_text(long stmt,
 int col)
                            throws SQLException

Parameters:

stmt - Pointer to the statement.

col - Number of column.

Returns:

Value of the column as text data type in the result set of a SELECT statement.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/column_blob.html

column_blob

public abstract byte[] column_blob(long stmt,
 int col)
                            throws SQLException

Parameters:

stmt - Pointer to the statement.

col - Number of column.

Returns:

BLOB value of the column in the result set of a SELECT statement

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/column_blob.html

column_double

public abstract double column_double(long stmt,
 int col)
                              throws SQLException

Parameters:

stmt - Pointer to the statement.

col - Number of column.

Returns:

DOUBLE value of the column in the result set of a SELECT statement

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/column_blob.html

column_long

public abstract long column_long(long stmt,
 int col)
                          throws SQLException

Parameters:

stmt - Pointer to the statement.

col - Number of column.

Returns:

LONG value of the column in the result set of a SELECT statement.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/column_blob.html

column_int

public abstract int column_int(long stmt,
 int col)
                        throws SQLException

Parameters:

stmt - Pointer to the statement.

col - Number of column.

Returns:

INT value of column in the result set of a SELECT statement.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/column_blob.html

result_null

public abstract void result_null(long context)
                          throws SQLException

Sets the result of an SQL function as NULL with the pointer to the SQLite database context.

Parameters:

context - Pointer to the SQLite database context.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/result_blob.html

result_text

public abstract void result_text(long context,
 String val)
                          throws SQLException

Sets the result of an SQL function as text data type with the pointer to the SQLite database context and the the result value of String.

Parameters:

context - Pointer to the SQLite database context.

val - Result value of an SQL function.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/result_blob.html

result_blob

public abstract void result_blob(long context,
 byte[] val)
                          throws SQLException

Sets the result of an SQL function as blob data type with the pointer to the SQLite database context and the the result value of byte array.

Parameters:

context - Pointer to the SQLite database context.

val - Result value of an SQL function.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/result_blob.html

result_double

public abstract void result_double(long context,
 double val)
                            throws SQLException

Sets the result of an SQL function as double data type with the pointer to the SQLite database context and the the result value of double.

Parameters:

context - Pointer to the SQLite database context.

val - Result value of an SQL function.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/result_blob.html

result_long

public abstract void result_long(long context,
 long val)
                          throws SQLException

Sets the result of an SQL function as long data type with the pointer to the SQLite database context and the the result value of long.

Parameters:

context - Pointer to the SQLite database context.

val - Result value of an SQL function.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/result_blob.html

result_int

public abstract void result_int(long context,
 int val)
                         throws SQLException

Sets the result of an SQL function as int data type with the pointer to the SQLite database context and the the result value of int.

Parameters:

context - Pointer to the SQLite database context.

val - Result value of an SQL function.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/result_blob.html

result_error

public abstract void result_error(long context,
 String err)
                           throws SQLException

Sets the result of an SQL function as an error with the pointer to the SQLite database context and the the error of String.

Parameters:

context - Pointer to the SQLite database context.

err - Error result of an SQL function.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/result_blob.html

value_text

public abstract String value_text(Function f,
 int arg)
                           throws SQLException

Parameters:

f - SQLite function object.

arg - Pointer to the parameter of the SQLite function or aggregate.

Returns:

Parameter value of the given SQLite function or aggregate in text data type.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/value_blob.html

value_blob

public abstract byte[] value_blob(Function f,
 int arg)
                           throws SQLException

Parameters:

f - SQLite function object.

arg - Pointer to the parameter of the SQLite function or aggregate.

Returns:

Parameter value of the given SQLite function or aggregate in blob data type.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/value_blob.html

value_double

public abstract double value_double(Function f,
 int arg)
                             throws SQLException

Parameters:

f - SQLite function object.

arg - Pointer to the parameter of the SQLite function or aggregate.

Returns:

Parameter value of the given SQLite function or aggregate in double data type

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/value_blob.html

value_long

public abstract long value_long(Function f,
 int arg)
                         throws SQLException

Parameters:

f - SQLite function object.

arg - Pointer to the parameter of the SQLite function or aggregate.

Returns:

Parameter value of the given SQLite function or aggregate in long data type.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/value_blob.html

value_int

public abstract int value_int(Function f,
 int arg)
                       throws SQLException

Accesses the parameter values on the function or aggregate in int data type with the function object and the parameter value.

Parameters:

f - SQLite function object.

arg - Pointer to the parameter of the SQLite function or aggregate.

Returns:

Parameter value of the given SQLite function or aggregate.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/value_blob.html

value_type

public abstract int value_type(Function f,
 int arg)
                        throws SQLException

Parameters:

f - SQLite function object.

arg - Pointer to the parameter of the SQLite function or aggregate.

Returns:

Parameter datatype of the function or aggregate in int data type.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/value_blob.html

create_function

public abstract int create_function(String name,
 Function f,
 int nArgs,
 int flags)
                             throws SQLException

Create a user defined function with given function name and the function object.

Parameters:

name - The function name to be created.

f - SQLite function object.

flags - Extra flags to use when creating the function, such as Function.FLAG_DETERMINISTIC

Returns:

Result Codes

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/create_function.html

destroy_function

public abstract int destroy_function(String name)
                              throws SQLException

De-registers a user defined function

Parameters:

name - Name of the function to de-registered.

Returns:

Result Codes

Throws:

SQLException

create_collation

public abstract int create_collation(String name,
 Collation c)
                              throws SQLException

Create a user defined collation with given collation name and the collation object.

Parameters:

name - The collation name to be created.

c - SQLite collation object.

Returns:

Result Codes

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/create_collation.html

destroy_collation

public abstract int destroy_collation(String name)
                               throws SQLException

Create a user defined collation with given collation name and the collation object.

Parameters:

name - The collation name to be created.

Returns:

Result Codes

Throws:

SQLException

backup

public abstract int backup(String dbName,
 String destFileName,
 DB.ProgressObserver observer)
                    throws SQLException

Parameters:

dbName - Database name to be backed up.

destFileName - Target backup file name.

observer - ProgressObserver object.

Returns:

Result Codes

Throws:

SQLException

backup

public abstract int backup(String dbName,
 String destFileName,
 DB.ProgressObserver observer,
 int sleepTimeMillis,
 int nTimeouts,
 int pagesPerStep)
                    throws SQLException

Parameters:

dbName - Database name to be backed up.

destFileName - Target backup file name.

observer - ProgressObserver object.

sleepTimeMillis - time to wait during a backup/restore operation if sqlite3_backup_step returns SQLITE_BUSY before continuing

nTimeouts - the number of times sqlite3_backup_step can return SQLITE_BUSY before failing

pagesPerStep - the number of pages to copy in each sqlite3_backup_step. If this is negative, the entire DB is copied at once.

Returns:

Result Codes

Throws:

SQLException

restore

public abstract int restore(String dbName,
 String sourceFileName,
 DB.ProgressObserver observer)
                     throws SQLException

Parameters:

dbName - Database name for restoring data.

sourceFileName - Source file name.

observer - ProgressObserver object.

Returns:

Result Codes

Throws:

SQLException

restore

public abstract int restore(String dbName,
 String sourceFileName,
 DB.ProgressObserver observer,
 int sleepTimeMillis,
 int nTimeouts,
 int pagesPerStep)
                     throws SQLException

Parameters:

dbName - the name of the db to restore

sourceFileName - the filename of the source db to restore

observer - ProgressObserver object.

sleepTimeMillis - time to wait during a backup/restore operation if sqlite3_backup_step returns SQLITE_BUSY before continuing

nTimeouts - the number of times sqlite3_backup_step can return SQLITE_BUSY before failing

pagesPerStep - the number of pages to copy in each sqlite3_backup_step. If this is negative, the entire DB is copied at once.

Returns:

Result Codes

Throws:

SQLException

limit

public abstract int limit(int id,
 int value)
                   throws SQLException

Parameters:

id - The id of the limit.

value - The new value of the limit.

Returns:

The prior value of the limit

Throws:

SQLException

See Also:

• https://www.sqlite.org/c3ref/limit.html

register_progress_handler

public abstract void register_progress_handler(int vmCalls,
 ProgressHandler progressHandler)
                                        throws SQLException

Progress handler

Throws:

SQLException

clear_progress_handler

public abstract void clear_progress_handler()
                                     throws SQLException

Throws:

SQLException

column_names

public final String[] column_names(long stmt)
                            throws SQLException

Returns an array of column names in the result set of the SELECT statement.

Parameters:

stmt - Stmt object.

Returns:

String array of column names.

Throws:

SQLException

execute

public final boolean execute(CoreStatement stmt,
 Object[] vals)
                      throws SQLException

Parameters:

stmt - Stmt object.

vals - Array of parameter values.

Returns:

True if a row of ResultSet is ready; false otherwise.

Throws:

SQLException

See Also:

• https://www.sqlite.org/c_interface.html#sqlite_exec

executeUpdate

public final long executeUpdate(CoreStatement stmt,
 Object[] vals)
                         throws SQLException

Execute an SQL INSERT, UPDATE or DELETE statement with the Stmt object and an array of parameter values of the SQL statement..

Parameters:

stmt - Stmt object.

vals - Array of parameter values.

Returns:

Number of database rows that were changed or inserted or deleted by the most recently completed SQL.

Throws:

SQLException

addUpdateListener

public void addUpdateListener(SQLiteUpdateListener listener)

addCommitListener

public void addCommitListener(SQLiteCommitListener listener)

removeUpdateListener

public void removeUpdateListener(SQLiteUpdateListener listener)

removeCommitListener

public void removeCommitListener(SQLiteCommitListener listener)

throwex

public final void throwex(int errorCode)
                   throws SQLException

Throws SQLException with error code.

Parameters:

errorCode - Error code to be passed.

Throws:

SQLException - Formatted SQLException with error code.

newSQLException

public static SQLiteException newSQLException(int errorCode,
 String errorMessage)

Throws formatted SQLException with error code and message.

Parameters:

errorCode - Error code to be passed.

errorMessage - Error message to be passed.

Returns:

Formatted SQLException with error code and message.

serialize

public abstract byte[] serialize(String schema)
                          throws SQLException

Throws:

SQLException

deserialize

public abstract void deserialize(String schema,
 byte[] buff)
                          throws SQLException

Throws:

SQLException