artefaktur
software engineer &        architecture

 
 
 
 

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:

acdk::lang::Object acdk::sql::Connection acdk::lang::ObjectBase acdk::lang::dmi::StdDispatch 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]
 

 
Last modified 2005-05-08 18:33 by SYSTEM By Artefaktur, Ing. Bureau Kommer