class Connection

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

acdk::sql::Connection Class Reference

#include <Connection.h>

Inheritance diagram for acdk::sql::Connection:

List of all members.

Detailed Description

API: JDBC 2.0.

Author:: Roger Rene Kommer

Version:

Revision: 1.13

Date:

Date: 2005/04/08 10:53:20

Public Member Functions

virtual void clearWarnings ()=0

JDKDOC: Clears all warnings reported for this Connection object.

virtual void close ()=0

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

virtual void commit ()=0

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

virtual RStatement createStatement ()=0

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

virtual RStatement createStatement (int resultSetType, int resultSetConcurrency)=0

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

virtual bool getAutoCommit ()=0

JDKDOC: Gets the current auto-commit state.

virtual RString getCatalog ()=0

JDKDOC: Returns the Connection's current catalog name.

virtual RDatabaseMetaData getMetaData ()=0

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

virtual int getTransactionIsolation ()=0

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

virtual acdk::util::RMap getTypeMap ()=0

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

virtual RSQLWarning getWarnings ()=0

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

virtual bool isClosed ()=0

JDKDOC: Tests to see if a Connection is closed.

virtual bool isReadOnly ()=0

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

virtual RString nativeSQL (INP(RString) sql)=0

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

virtual RCallableStatement prepareCall (INP(RString) sql)=0

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

virtual RPreparedStatement prepareStatement (INP(RString) sql)=0

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

virtual void rollback ()=0

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)=0

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

virtual void setCatalog (INP(RString) catalog)=0

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)=0

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

virtual void setTransactionIsolation (int level)=0

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

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

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

Static Public Attributes

int TRANSACTION_NONE

JDKDOC: Indicates that transactions are not supported.

int TRANSACTION_READ_COMMITTED

JDKDOC: Dirty reads are prevented; non-repeatable reads and phantom reads can occur.

int TRANSACTION_READ_UNCOMMITTED

JDKDOC: Dirty reads, non-repeatable reads and phantom reads can occur.

int TRANSACTION_REPEATABLE_READ

JDKDOC: Dirty reads and non-repeatable reads are prevented; phantom reads can occur.

int TRANSACTION_SERIALIZABLE

JDKDOC: Dirty reads, non-repeatable reads and phantom reads are prevented.

Member Function Documentation

virtual void acdk::sql::Connection::clearWarnings ( ) [pure virtual]

JDKDOC: Clears all warnings reported for this Connection object.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual void acdk::sql::Connection::close ( ) [pure virtual]

JDKDOC: Releases a Connection's database and JDBC resources immediately instead of waiting for them to be automatically released.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual void acdk::sql::Connection::commit ( ) [pure virtual]

JDKDOC: Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual RStatement acdk::sql::Connection::createStatement ( int resultSetType,

int resultSetConcurrency

) [pure virtual]

JDKDOC: JDBC 2.0 Creates a Statement object that will generate ResultSet objects with the given type and concurrency.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual RStatement acdk::sql::Connection::createStatement ( ) [pure virtual]

JDKDOC: Creates a Statement object for sending SQL statements to the database.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual bool acdk::sql::Connection::getAutoCommit ( ) [pure virtual]

JDKDOC: Gets the current auto-commit state.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual RString acdk::sql::Connection::getCatalog ( ) [pure virtual]

JDKDOC: Returns the Connection's current catalog name.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual RDatabaseMetaData acdk::sql::Connection::getMetaData ( ) [pure virtual]

JDKDOC: Gets the metadata regarding this connection's database.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual int acdk::sql::Connection::getTransactionIsolation ( ) [pure virtual]

JDKDOC: Gets this Connection's current transaction isolation level.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual acdk::util::RMap acdk::sql::Connection::getTypeMap ( ) [pure virtual]

JDKDOC: JDBC 2.0 Gets the type map object associated with this connection.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual RSQLWarning acdk::sql::Connection::getWarnings ( ) [pure virtual]

JDKDOC: Returns the first warning reported by calls on this Connection.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual bool acdk::sql::Connection::isClosed ( ) [pure virtual]

JDKDOC: Tests to see if a Connection is closed.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual bool acdk::sql::Connection::isReadOnly ( ) [pure virtual]

JDKDOC: Tests to see if the connection is in read-only mode.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual RString acdk::sql::Connection::nativeSQL ( INP(RString) sql ) [pure virtual]

JDKDOC: Converts the given SQL statement into the system's native SQL grammar.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual RCallableStatement acdk::sql::Connection::prepareCall ( INP(RString) sql ) [pure virtual]

JDKDOC: Creates a CallableStatement object for calling database stored procedures.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual RPreparedStatement acdk::sql::Connection::prepareStatement ( INP(RString) sql ) [pure virtual]

JDKDOC: Creates a PreparedStatement object for sending parameterized SQL statements to the database.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual void acdk::sql::Connection::rollback ( ) [pure virtual]

JDKDOC: Drops all changes made since the previous commit/rollback and releases any database locks currently held by this Connection.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual void acdk::sql::Connection::setAutoCommit ( bool autoCommit ) [pure virtual]

JDKDOC: Sets this connection's auto-commit mode.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual void acdk::sql::Connection::setCatalog ( INP(RString) catalog ) [pure virtual]

JDKDOC: Sets a catalog name in order to select a subspace of this Connection's database in which to work.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual void acdk::sql::Connection::setReadOnly ( bool readOnly ) [pure virtual]

JDKDOC: Puts this connection in read-only mode as a hint to enable database optimizations.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual void acdk::sql::Connection::setTransactionIsolation ( int level ) [pure virtual]

JDKDOC: Attempts to change the transaction isolation level to the one given.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

virtual void acdk::sql::Connection::setTypeMap ( INP(acdk::util::RMap) map ) [pure virtual]

JDKDOC: JDBC 2.0 Installs the given type map as the type map for this connection.
API: JDK
Implemented in acdk::sql::odbc::ODBCConnection, and acdk::sql::sqlite::LiteConnection.

Member Data Documentation

int acdk::sql::Connection::TRANSACTION_NONE [static]

JDKDOC: Indicates that transactions are not supported.
API: JDK

int acdk::sql::Connection::TRANSACTION_READ_COMMITTED [static]

JDKDOC: Dirty reads are prevented; non-repeatable reads and phantom reads can occur.
API: JDK

int acdk::sql::Connection::TRANSACTION_READ_UNCOMMITTED [static]

JDKDOC: Dirty reads, non-repeatable reads and phantom reads can occur.
API: JDK

int acdk::sql::Connection::TRANSACTION_REPEATABLE_READ [static]

JDKDOC: Dirty reads and non-repeatable reads are prevented; phantom reads can occur.
API: JDK

int acdk::sql::Connection::TRANSACTION_SERIALIZABLE [static]

JDKDOC: Dirty reads, non-repeatable reads and phantom reads are prevented.
API: JDK