Connection Class

The Connection class represents a connection with a specific database. Within the context of a connection, SQL statements are executed and results are returned.

changePassword()

Changes the password of the user currently connected to the database.

void changePassword(
   const string &user,
   const string &oldPassword,
   const string &newPassword);

void changePassword(
   const UString &user,
   const UString &oldPassword,
   const UString &newPassword);

user

oldPassword

newPassword

commit()

Commits all changes made since the previous commit or rollback, and releases any database locks currently held by the session.

void commit();

createStatement()

Creates a Statement object with the SQL statement specified.

Statement* createStatement(
   const string &sql);

Statement* createStatement(
   const string sql,
   const string tag);

Statement* createStatement(
   const UString &sql);

Statement* createStatement(
   const Ustring sql,
   const Ustring tag);

sql

tag

flushCache()

Flushes the object cache associated with the connection.

void flushCache();

getClientCharSet()

Returns the session's character set.

string getClientCharSet() const;

getClientCharSetUString()

Returns the globalization enabled client character set in UString.

UString getClientCharSetUString() const;

getClientNCHARCharSet()

Returns the session's NCHAR character set.

string getClientNCHARCharSet() const;

getClientNCHARCharSetUString()

Returns the globalization enabled client NCHAR character set in UString.

UString getClientNCHARCharSetUString() const;

getMetaData()

Returns metadata for an object in the database.

MetaData getMetaData(
   const string &object,
   MetaData::ParamType prmtyp=MetaData::PTYPE_UNK) const;

MetaData getMetaData(
   const UString &object,
   MetaData::ParamType prmtyp=MetaData::PTYPE_UNK) const;

MetaData getMetaData(
   const RefAny &ref);

getOCIServer()

Returns the OCI server context associated with the connection.

LNOCIServer* getOCIServer() const;

getOCIServiceContext()

Returns the OCI service context associated with the connection.

LNOCISvcCtx* getOCIServiceContext() const;

getOCISession()

Returns the OCI session context associated with the connection.

LNOCISession* getOCISession() const;

getStmtCacheSize()

Retrieves the size of the statement cache.

unsigned int getStmtCacheSize() const;

getTag()

Returns the tag associated with the connection. Valid only for connections from a stateless connection pool.

string getTag() const;

isCached()

Determines if the specified statement is cached.

bool isCached(
   const string &sql,
   const string &tag="");

bool isCached(
   const Ustring &sql,
   const Ustring &tag="");

sql

tag

pinVectorOfRefs()

Pins an entire vector of Ref objects into object cache in a single round-trip. Pinned objects are available through an OUT parameter vector.

template <class T> void pinVectorOfRefs(
   const Connection *conn,
   vector <Ref<T>> & vect,
   vector <T*> &vectObj,
   LockOptions lockOpt=OCCI_LOCK_NONE);

template <class T> void pinVectorOfRefs(
   const Connection *conn,
   vector <Ref<T>> & vect,
   LockOptions lockOpt=OCCI_LOCK_NONE);

template <class T> void pinVectorOfRefs(
   const Connection *conn,
   vector <Ref<T>> & vect,
   vector <T*> &vectObj,
   LockOptions lockOpt);

conn

vect

vectObj

lockOpt

rollback()

Drops all changes made since the previous commit or rollback, and releases any database locks currently held by the session.

void rollback();

postToSubscriptions()

Posts notifications to subscriptions.

The Subscription object needs to have a valid subscription name, and the namespace should be set to NS_ANONYMOUS. The payload needs to be set before invoking this call; otherwise, the payload is assumed to be NULL and is not delivered.

The caller has to preserve the payload until the posting call is complete. This call provides a best-effort guarantee; a notification is sent to registered clients at most once.This call is primarily used for light-weight notification and is useful in the case of several system events. If the application needs more rigid guarantees, it can use the Streams AQ functionality.

void postToSubscriptions(
   const vector<Subscription>& sub);

sub

registerSubscriptions()

Registers Subscriptions for notification.

New client processes and existing processes that restart after a shut down must register for all subscriptions of interest. If the client stays up during a server shut down and restart, this client will continue to receive notifications for DISCONNECTED registrations, but not for CONNECTED registrations because they are lost during the server down time.

void registerSubscriptions(
   const vector<Subscription>& sub_list);

sub_list

setStmtCacheSize()

Enables or disables statement caching.

• A nonzero value will enable statement caching, with a cache of specified size.

• A zero value will disable caching.

void setStmtCacheSize(
   unsigned int size);

size

terminateStatement()

Closes a Statement object.

void terminateStatement(
   Statement *statement);

void terminateStatement(
   Statement *statement,
   const string tag);

statement

tag

unregisterSubscription()

Unregisters a Subscription, turning off its notifications.

void unregisterSubscription(
   const Subscription& sub);

sub