class LiteConnection

Modules Namespace List Class Hierarchy Alphabetical List Compound List Namespace Members Compound Members Related Pages

acdk::sql::sqlite::LiteConnection Class Reference

#include <LiteConnection.h>

Inheritance diagram for acdk::sql::sqlite::LiteConnection:

List of all members.

Detailed Description

connection to a SQLite database

Public Member Functions

LiteConnection (IN(RString) url, IN(RLiteDb) db, bool readOnly=false)

sqlite3 * conPtr ()

return the native SQLite connection pointer

RLiteDb getDb ()

return the core SQLite wrapper

RString getURL ()

virtual void clearWarnings ()

JDKDOC: Clears all warnings reported for this Connection object.

virtual void close ()

JDKDOC: Releases a Connection's database and JDBC resources immediately instead of waiting for them to be automatically released.

virtual void commit ()

JDKDOC: Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.

virtual RStatement createStatement ()

JDKDOC: Creates a Statement object for sending SQL statements to the database.

virtual RStatement createStatement (int resultSetType, int resultSetConcurrency)

JDKDOC: JDBC 2.0 Creates a Statement object that will generate ResultSet objects with the given type and concurrency.

virtual bool getAutoCommit ()

JDKDOC: Gets the current auto-commit state.

virtual RString getCatalog ()

JDKDOC: Returns the Connection's current catalog name.

virtual RDatabaseMetaData getMetaData ()

JDKDOC: Gets the metadata regarding this connection's database.

virtual int getTransactionIsolation ()

JDKDOC: Gets this Connection's current transaction isolation level.

virtual acdk::util::RMap getTypeMap ()

JDKDOC: JDBC 2.0 Gets the type map object associated with this connection.

virtual RSQLWarning getWarnings ()

JDKDOC: Returns the first warning reported by calls on this Connection.

virtual bool isClosed ()

JDKDOC: Tests to see if a Connection is closed.

virtual bool isReadOnly ()

JDKDOC: Tests to see if the connection is in read-only mode.

virtual RString nativeSQL (INP(RString) sql)

JDKDOC: Converts the given SQL statement into the system's native SQL grammar.

virtual RCallableStatement prepareCall (INP(RString) sql)

JDKDOC: Creates a CallableStatement object for calling database stored procedures.

virtual RPreparedStatement prepareStatement (INP(RString) sql)

JDKDOC: Creates a PreparedStatement object for sending parameterized SQL statements to the database.

virtual void rollback ()

JDKDOC: Drops all changes made since the previous commit/rollback and releases any database locks currently held by this Connection.

virtual void setAutoCommit (bool autoCommit)

JDKDOC: Sets this connection's auto-commit mode.

virtual void setCatalog (INP(RString) catalog)

JDKDOC: Sets a catalog name in order to select a subspace of this Connection's database in which to work.

virtual void setReadOnly (bool readOnly)

JDKDOC: Puts this connection in read-only mode as a hint to enable database optimizations.

virtual void setTransactionIsolation (int level)

JDKDOC: Attempts to change the transaction isolation level to the one given.

virtual void setTypeMap (INP(acdk::util::RMap) map)

JDKDOC: JDBC 2.0 Installs the given type map as the type map for this connection.

void execute (IN(RString) cmd)

int executeUpdate (IN(RString) cmd)

Static Public Member Functions

RLiteConnection createConnection (IN(RString) url, IN(RString) dbFile, bool readOnly=false)

Protected Attributes

RLiteDb _db

RString _url

bool _readOnly

bool _autoCommit

Constructor & Destructor Documentation

acdk::sql::sqlite::LiteConnection::LiteConnection ( IN(RString) url,

IN(RLiteDb) db,

bool readOnly = false

) [inline]

Member Function Documentation

virtual void acdk::sql::sqlite::LiteConnection::clearWarnings ( ) [virtual]

JDKDOC: Clears all warnings reported for this Connection object.
API: JDK
Implements acdk::sql::Connection.

virtual void acdk::sql::sqlite::LiteConnection::close ( ) [virtual]

JDKDOC: Releases a Connection's database and JDBC resources immediately instead of waiting for them to be automatically released.
API: JDK
Implements acdk::sql::Connection.

virtual void acdk::sql::sqlite::LiteConnection::commit ( ) [virtual]

JDKDOC: Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.
API: JDK
Implements acdk::sql::Connection.

sqlite3* acdk::sql::sqlite::LiteConnection::conPtr ( ) [inline]

return the native SQLite connection pointer

RLiteConnection acdk::sql::sqlite::LiteConnection::createConnection ( IN(RString) url,

IN(RString) dbFile,

bool readOnly = false

) [static]

virtual RStatement acdk::sql::sqlite::LiteConnection::createStatement ( int resultSetType,

int resultSetConcurrency

) [virtual]

JDKDOC: JDBC 2.0 Creates a Statement object that will generate ResultSet objects with the given type and concurrency.
API: JDK
Implements acdk::sql::Connection.

virtual RStatement acdk::sql::sqlite::LiteConnection::createStatement ( ) [virtual]

JDKDOC: Creates a Statement object for sending SQL statements to the database.
API: JDK
Implements acdk::sql::Connection.

void acdk::sql::sqlite::LiteConnection::execute ( IN(RString) cmd )

int acdk::sql::sqlite::LiteConnection::executeUpdate ( IN(RString) cmd )

virtual bool acdk::sql::sqlite::LiteConnection::getAutoCommit ( ) [virtual]

JDKDOC: Gets the current auto-commit state.
API: JDK
Implements acdk::sql::Connection.

virtual RString acdk::sql::sqlite::LiteConnection::getCatalog ( ) [virtual]

JDKDOC: Returns the Connection's current catalog name.
API: JDK
Implements acdk::sql::Connection.

RLiteDb acdk::sql::sqlite::LiteConnection::getDb ( ) [inline]

return the core SQLite wrapper

virtual RDatabaseMetaData acdk::sql::sqlite::LiteConnection::getMetaData ( ) [virtual]

JDKDOC: Gets the metadata regarding this connection's database.
API: JDK
Implements acdk::sql::Connection.

virtual int acdk::sql::sqlite::LiteConnection::getTransactionIsolation ( ) [virtual]

JDKDOC: Gets this Connection's current transaction isolation level.
API: JDK
Implements acdk::sql::Connection.

virtual acdk::util::RMap acdk::sql::sqlite::LiteConnection::getTypeMap ( ) [virtual]

JDKDOC: JDBC 2.0 Gets the type map object associated with this connection.
API: JDK
Implements acdk::sql::Connection.

RString acdk::sql::sqlite::LiteConnection::getURL ( ) [inline]

virtual RSQLWarning acdk::sql::sqlite::LiteConnection::getWarnings ( ) [virtual]

JDKDOC: Returns the first warning reported by calls on this Connection.
API: JDK
Implements acdk::sql::Connection.

virtual bool acdk::sql::sqlite::LiteConnection::isClosed ( ) [virtual]

JDKDOC: Tests to see if a Connection is closed.
API: JDK
Implements acdk::sql::Connection.

virtual bool acdk::sql::sqlite::LiteConnection::isReadOnly ( ) [virtual]

JDKDOC: Tests to see if the connection is in read-only mode.
API: JDK
Implements acdk::sql::Connection.

virtual RString acdk::sql::sqlite::LiteConnection::nativeSQL ( INP(RString) sql ) [virtual]

JDKDOC: Converts the given SQL statement into the system's native SQL grammar.
API: JDK
Implements acdk::sql::Connection.

virtual RCallableStatement acdk::sql::sqlite::LiteConnection::prepareCall ( INP(RString) sql ) [virtual]

JDKDOC: Creates a CallableStatement object for calling database stored procedures.
API: JDK
Implements acdk::sql::Connection.

virtual RPreparedStatement acdk::sql::sqlite::LiteConnection::prepareStatement ( INP(RString) sql ) [virtual]

JDKDOC: Creates a PreparedStatement object for sending parameterized SQL statements to the database.
API: JDK
Implements acdk::sql::Connection.

virtual void acdk::sql::sqlite::LiteConnection::rollback ( ) [virtual]

JDKDOC: Drops all changes made since the previous commit/rollback and releases any database locks currently held by this Connection.
API: JDK
Implements acdk::sql::Connection.

virtual void acdk::sql::sqlite::LiteConnection::setAutoCommit ( bool autoCommit ) [virtual]

JDKDOC: Sets this connection's auto-commit mode.
API: JDK
Implements acdk::sql::Connection.

virtual void acdk::sql::sqlite::LiteConnection::setCatalog ( INP(RString) catalog ) [virtual]

JDKDOC: Sets a catalog name in order to select a subspace of this Connection's database in which to work.
API: JDK
Implements acdk::sql::Connection.

virtual void acdk::sql::sqlite::LiteConnection::setReadOnly ( bool readOnly ) [virtual]

JDKDOC: Puts this connection in read-only mode as a hint to enable database optimizations.
API: JDK
Implements acdk::sql::Connection.

virtual void acdk::sql::sqlite::LiteConnection::setTransactionIsolation ( int level ) [virtual]

JDKDOC: Attempts to change the transaction isolation level to the one given.
API: JDK
Implements acdk::sql::Connection.

virtual void acdk::sql::sqlite::LiteConnection::setTypeMap ( INP(acdk::util::RMap) map ) [virtual]

JDKDOC: JDBC 2.0 Installs the given type map as the type map for this connection.
API: JDK
Implements acdk::sql::Connection.

Member Data Documentation

bool acdk::sql::sqlite::LiteConnection::_autoCommit [protected]

RLiteDb acdk::sql::sqlite::LiteConnection::_db [protected]

bool acdk::sql::sqlite::LiteConnection::_readOnly [protected]

RString acdk::sql::sqlite::LiteConnection::_url [protected]