---

odbc::Connection Class Reference

A database connection. More...

#include <connection.h>

Inheritance diagram for odbc::Connection::

List of all members.

Public Types

• enum TransactionIsolation {
    TRANSACTION_NONE, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_READ_COMMITTED, TRANSACTION_REPEATABLE_READ,
    TRANSACTION_SERIALIZABLE
  }

  Transaction isolation constants. More...
  
  

Public Methods

• 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.

---

Constructor & Destructor Documentation

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

Destructor. Closes the connection

---

Member Function Documentation

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

Creates a non-prepared statement. Parameters: resultSetType  The type for ResultSets created by this statement resultSetConcurrency  The concurrency for ResultSets created by this statement

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.

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 ResultSets created by this statement resultSetConcurrency  The concurrency for ResultSets 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

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 ResultSets created by this statement resultSetConcurrency  The concurrency for ResultSets 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 (?).

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

Sets the autocommit state of this connection. Parameters: autoCommit  true for on, false for off

---

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

• odbc++/connection.h

---

Go back to the freeodbc++ homepage