SqlGwConnection Class Reference

#include <SqlGwConnection.h>

Inheritance diagram for SqlGwConnection:

[legend]Collaboration diagram for SqlGwConnection:

[legend]

Public Member Functions
	SqlGwConnection ()
void	setTxnHandler (GwHandler hdlr)
GwHandler	getTxnHandler ()
DbRetVal	connect (char *user, char *pass)
	opens connection to the sql engine
DbRetVal	disconnect ()
	closes connection to the sql engine and releases all the resources
DbRetVal	commit ()
	Commits active transaction.
DbRetVal	rollback ()
	Aborts the active transaction.
DbRetVal	beginTrans (IsolationLevel isoLevel, TransSyncMode mode=OSYNC)
	Starts a new transaction.
void	setAdapter (AbsSqlConnection *conn)
AbsSqlConnection *	getAdapterConnection ()
DbRetVal	connectCSqlIfNotConnected ()
DbRetVal	connectAdapterIfNotConnected ()
Connection &	getConnObject ()
Data Fields
GwHandler	txnHdlr
TransSyncMode	mode
Friends
class	SqlFactory

---

Detailed Description

Definition at line 34 of file SqlGwConnection.h.

---

Constructor & Destructor Documentation

SqlGwConnection::SqlGwConnection

(

)

[inline]

Definition at line 46 of file SqlGwConnection.h.

References AbsSqlConnection::innerConn, mode, and OSYNC.

{innerConn = NULL; mode = OSYNC; }

---

Member Function Documentation

DbRetVal SqlGwConnection::beginTrans	(	IsolationLevel	isoLevel,
		TransSyncMode	mode = OSYNC
	)			[virtual]

Starts a new transaction.

The previous transaction should be either committed or rollback
before beginTrans is called.
Applications are required to start transaction before they attempt any
database operation.

Parameters:

isoLevel

isolation level. Default is read committed.

Returns:

DbRetVal

Implements AbsSqlConnection.

Definition at line 49 of file SqlGwConnection.cxx.

References AbsSqlConnection::beginTrans(), CSqlHandler, ErrNoConnection, AbsSqlConnection::innerConn, OK, and txnHdlr.

{
    DbRetVal rv = OK;
    if (!isAdapterConnected && !isCSqlConnected) return ErrNoConnection;
    if (innerConn && isCSqlConnected) rv =  innerConn->beginTrans(isoLevel, smode);
    if (rv != OK) return rv;
    if (adapter && isAdapterConnected) rv = adapter->beginTrans(isoLevel);
    //mode = smode;
    txnHdlr = CSqlHandler;
    return rv;
}

Here is the call graph for this function:

DbRetVal SqlGwConnection::commit

(

)

[virtual]

Commits active transaction.

It makes all the changes made in the current transaction permanent and
it also releases the locks held by the current transaction.
After a transaction commits, application is required to start another
transaction for further database operations.

Returns:

DbRetVal

Implements AbsSqlConnection.

Definition at line 60 of file SqlGwConnection.cxx.

References AdapterHandler, AbsSqlConnection::commit(), CSqlAndAdapterHandler, ErrNoConnection, AbsSqlConnection::innerConn, OK, and txnHdlr.

{
    DbRetVal rv = OK;
    if (innerConn && isCSqlConnected)
        //(txnHdlr == CSqlHandler || txnHdlr == CSqlAndAdapterHandler))
        rv = innerConn->commit();
    if (rv != OK) return rv;
    if (adapter && 
        (txnHdlr == AdapterHandler || txnHdlr == CSqlAndAdapterHandler))
        rv = adapter->commit();
    if (!isAdapterConnected && !isCSqlConnected) return ErrNoConnection;
    return rv;
}

Here is the call graph for this function:

DbRetVal SqlGwConnection::connect	(	char *	user,
		char *	pass
	)			[virtual]

opens connection to the sql engine

Parameters:

	user	username for authentication
	pass	password for authentication

Returns:

DbRetVal

Implements AbsSqlConnection.

Definition at line 24 of file SqlGwConnection.cxx.

References AbsSqlConnection::connect(), ErrNoConnection, AbsSqlConnection::innerConn, and OK.

{
    isCSqlConnected = false;
    isAdapterConnected = false;
    strcpy(username, user);
    strcpy(password, pass);
    DbRetVal rv = OK;
    if (innerConn) rv = innerConn->connect(user,pass);
    if (rv == OK) isCSqlConnected = true;
    if (adapter) rv = adapter->connect(user,pass);
    if (rv == OK) isAdapterConnected = true;
    if (!isAdapterConnected && !isCSqlConnected) return ErrNoConnection;
    return OK;
    
}

Here is the call graph for this function:

DbRetVal SqlGwConnection::connectAdapterIfNotConnected

(

)

Definition at line 95 of file SqlGwConnection.cxx.

References AbsSqlConnection::connect(), and OK.

{
    if (!isAdapterConnected) { 
        DbRetVal rv = adapter->connect(username, password);
        if (rv != OK) return rv;
        isAdapterConnected = true;
    }
    return OK;
}

Here is the call graph for this function:

DbRetVal SqlGwConnection::connectCSqlIfNotConnected

(

)

Definition at line 86 of file SqlGwConnection.cxx.

References AbsSqlConnection::connect(), AbsSqlConnection::innerConn, and OK.

{
    if (!isCSqlConnected) { 
        DbRetVal rv = innerConn->connect(username, password);
        if (rv != OK) return rv;
        isCSqlConnected = true;
    }
    return OK;
}

Here is the call graph for this function:

DbRetVal SqlGwConnection::disconnect

(

)

[virtual]

closes connection to the sql engine and releases all the resources

Returns:

DbRetVal

Implements AbsSqlConnection.

Definition at line 39 of file SqlGwConnection.cxx.

References AbsSqlConnection::disconnect(), AbsSqlConnection::innerConn, and OK.

{
    DbRetVal rv = OK;
    if (innerConn && isCSqlConnected) rv =innerConn->disconnect();
    if (rv != OK) return rv;
    if (adapter && isAdapterConnected) rv = adapter->disconnect();
    isCSqlConnected = false;
    isAdapterConnected = false;
    return rv;
}

Here is the call graph for this function:

AbsSqlConnection* SqlGwConnection::getAdapterConnection

(

)

[inline]

Definition at line 63 of file SqlGwConnection.h.

Referenced by SqlGwStatement::setConnection().

{ return adapter; }

Here is the caller graph for this function:

Connection& SqlGwConnection::getConnObject

(

)

[inline, virtual]

Implements AbsSqlConnection.

Definition at line 69 of file SqlGwConnection.h.

{  return dummyConn; }

GwHandler SqlGwConnection::getTxnHandler

(

)

[inline]

Definition at line 48 of file SqlGwConnection.h.

References txnHdlr.

{ return txnHdlr; }

DbRetVal SqlGwConnection::rollback

(

)

[virtual]

Aborts the active transaction.

undo all the changes made in the current transaction and it also
releases the locks held by the current transaction.
After a transaction rollback, application is required to start another
transaction for further database operations.

Returns:

DbRetVal

Implements AbsSqlConnection.

Definition at line 73 of file SqlGwConnection.cxx.

References AdapterHandler, CSqlAndAdapterHandler, ErrNoConnection, AbsSqlConnection::innerConn, OK, AbsSqlConnection::rollback(), and txnHdlr.

{
    DbRetVal rv = OK;
    if (innerConn && isCSqlConnected)
        //(txnHdlr == CSqlHandler || txnHdlr == CSqlAndAdapterHandler))
        rv =  innerConn->rollback();
    if (rv != OK) return rv;
    if (adapter && isAdapterConnected &&
        (txnHdlr == AdapterHandler || txnHdlr == CSqlAndAdapterHandler))
        rv = adapter->rollback();
    if (!isAdapterConnected && !isCSqlConnected) return ErrNoConnection;
    return rv;
}

Here is the call graph for this function:

void SqlGwConnection::setAdapter

(

AbsSqlConnection *

conn

)

[inline]

Definition at line 62 of file SqlGwConnection.h.

References conn.

Referenced by SqlFactory::createConnection().

{ adapter =  conn; }

Here is the caller graph for this function:

void SqlGwConnection::setTxnHandler

(

GwHandler

hdlr

)

[inline]

Definition at line 47 of file SqlGwConnection.h.

References txnHdlr.

{ txnHdlr = hdlr; }

---

Friends And Related Function Documentation

friend class SqlFactory [friend]

Definition at line 60 of file SqlGwConnection.h.

---

Field Documentation

TransSyncMode SqlGwConnection::mode

Definition at line 45 of file SqlGwConnection.h.

Referenced by SqlGwConnection().

GwHandler SqlGwConnection::txnHdlr

Definition at line 44 of file SqlGwConnection.h.

Referenced by beginTrans(), commit(), getTxnHandler(), rollback(), and setTxnHandler().

---

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

• include/SqlGwConnection.h
• src/gateway/SqlGwConnection.cxx

---