Main Page Namespace List Class Hierarchy Compound List Header Files Namespace Members Compound Members

odbc::Connection Class Reference

A database connection. More...

#include <odbc++/connection.h>

Class diagram for odbc::Connection:

List of all members.

Public Members

enum TransactionIsolation { TRANSACTION_NONE, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_READ_COMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE }
Transaction isolation constants. More...
virtual ~Connection ()
Destructor. More...
bool getAutoCommit ()
Returns true if autocommit is on.
void setAutoCommit (bool autoCommit)
Sets the autocommit state of this connection. More...
void commit ()
Commits the ongoing transaction.
void rollback ()
Rollbacks the ongoing transaction.
std::string getCatalog ()
Returns the current catalog.
void setCatalog (const std::string& catalog)
Sets the current catalog.
TransactionIsolation getTransactionIsolation ()
Returns the current transaction isolation level.
void setTransactionIsolation (TransactionIsolation isolation)
Sets the current transaction isolation level.
bool isReadOnly ()
Returns true if the connection is read only.
void setReadOnly (bool readOnly)
Sets the read-only state of this connection.
bool getTrace ()
Returns true if ODBC tracing is enabled on this connection.
void setTrace (bool on)
Sets ODBC tracing on or off.
std::string getTraceFile ()
Returns the file ODBC tracing is currently written to.
void setTraceFile (const std::string& s)
Sets the file ODBC tracing is written to.
DatabaseMetaData* getMetaData ()
Returns meta information for this connection. More...
Statement* createStatement ()
Creates a non-prepared statement.
Statement* createStatement (int resultSetType, int resultSetConcurrency)
Creates a non-prepared statement. More...
PreparedStatement* prepareStatement (const std::string& sql)
Create a prepared statement. More...
PreparedStatement* prepareStatement (const std::string& sql, int resultSetType, int resultSetConcurrency)
Create a prepared statement. More...
CallableStatement* prepareCall (const std::string& sql)
Create a callable prepared statement. More...
CallableStatement* prepareCall (const std::string& sql, int resultSetType, int resultSetConcurrency)
Create a callable prepared statement. More...
std::string nativeSQL (const std::string& sql)
Translate a given SQL string into this data sources' own SQL grammar.

Detailed Description

A database connection.

Member Enumeration Documentation

enum odbc::Connection::TransactionIsolation

Transaction isolation constants.

Enumeration values:

TRANSACTION_NONE	The data source does not support transactions.
TRANSACTION_READ_UNCOMMITTED	Dirty reads, non-repeatable reads and phantom reads can occur.
TRANSACTION_READ_COMMITTED	Non-repeatable and phantom reads can occur.
TRANSACTION_REPEATABLE_READ	Phantom reads can occur.
TRANSACTION_SERIALIZABLE	Simply no problems.

Member Function Documentation

virtual odbc::Connection::~Connection () [virtual]

Destructor.

Closes the connection

void odbc::Connection::setAutoCommit (bool autoCommit)

Sets the autocommit state of this connection.

Parameters:

autoCommit true for on, false for off

DatabaseMetaData * odbc::Connection::getMetaData ()

Returns meta information for this connection.

Note that the returned object is 'owned' by this connection and should in no way be deleted by the caller.

Statement * odbc::Connection::createStatement (int resultSetType, int resultSetConcurrency)

Creates a non-prepared statement.

Parameters:

resultSetType	The type for `ResultSet`s created by this statement
resultSetConcurrency	The concurrency for `ResultSet`s created by this statement

PreparedStatement * odbc::Connection::prepareStatement (const std::string & sql)

Create a prepared statement.

Parameters:

sql The string to prepare, optionally containing parameter markers (?).

PreparedStatement * odbc::Connection::prepareStatement (const std::string & sql, int resultSetType, int resultSetConcurrency)

Create a prepared statement.

Parameters:

sql	The string to prepare, optionally containing parameter markers.
resultSetType	The type for `ResultSet`s created by this statement
resultSetConcurrency	The concurrency for `ResultSet`s created by this statement

CallableStatement * odbc::Connection::prepareCall (const std::string & sql)

Create a callable prepared statement.

Parameters:

sql

The string to prepare, optionally containing parameter markers for input and/or output parameters

CallableStatement * odbc::Connection::prepareCall (const std::string & sql, int resultSetType, int resultSetConcurrency)

Create a callable prepared statement.

Parameters:

sql	The string to prepare, optionally containing parameter markers for input and/or output parameters
resultSetType	The type for `ResultSet`s created by this statement
resultSetConcurrency	The concurrency for `ResultSet`s created by this statement

The documentation for this class was generated from the following file:

odbc++/connection.h