Developers Manual Project homepage

O3DBIDatabase.cpp

Go to the documentation of this file.

#include "O3DBIDatabase.h"
#include "O3DBIException.h"
#include "O3DBIError.h"

#pragma warning(push, 4)

// ----------------------------------------------------------------------------
// Construction/Destruction

O3DBIDatabase::O3DBIDatabase() :
    _hSrvCtx(NULL),
    _hServer(NULL),
    _bIsConnected(false)
{
    AllocateServiceHandle();
    AllocateServerHandle();
}

O3DBIDatabase::O3DBIDatabase(PC_TCHAR pchUsername,
                             PC_TCHAR pchPasswd,
                             PC_TCHAR pchHost) :
    _bIsConnected(false)
{
    AllocateServiceHandle();
    AllocateServerHandle();
    LogOn(pchUsername, pchPasswd, pchHost);
}

O3DBIDatabase::~O3DBIDatabase()
{
    if (_bIsConnected)
        LogOff();

    if (_hSrvCtx != NULL)
    {
        OCIHandleFree(reinterpret_cast<TOCIDvoidPtr*>(&_hSrvCtx),
        OCI_HTYPE_SVCCTX);
        _hSrvCtx = NULL;
    }
    if (_hServer != NULL)
    {
        OCIHandleFree(reinterpret_cast<TOCIDvoidPtr*>(&_hServer),
        OCI_HTYPE_SERVER);
        _hServer = NULL;
    }
}

// ----------------------------------------------------------------------------
// Implementation of public interface

void O3DBIDatabase::LogOn(PC_TCHAR pchUsername,
                          PC_TCHAR pchPasswd,
                          PC_TCHAR pchHost)
{
    if (pchUsername != NULL || pchPasswd != NULL || pchHost != NULL)
    {
        throw new O3DBIException(O3DBI_INVALID_LOGONINFO,
            O3DBIErrorTxt::pchInvalidLogonInfo,
            _T("O3DBIDatabase::LogOn"), this);
    }

    ub4 nUsernameLen = ::_tcslen(pchUsername);
    ub4 nPasswdLen = ::_tcslen(pchPasswd);
    ub4 nHostLen = ::_tcslen(pchHost);

    TOCIResult result = OCILogon(_hEnv, _hError, &_hSrvCtx,
        reinterpret_cast<CONST OraText*>(pchUsername), nUsernameLen,
        reinterpret_cast<CONST OraText*>(pchPasswd), nPasswdLen,
        reinterpret_cast<CONST OraText*>(pchHost), nHostLen);
    if (result != OCI_SUCCESS)
    {
        TO3DBIString errortext;
        TOCIErrorcode errorcode = GetLastError(result, errortext);
        throw new O3DBIException(errorcode, errortext.c_str(),
            _T("O3DBIDatabase::LogOn"), this);
    } else {
        _bIsConnected = true;
    }
}

void O3DBIDatabase::LogOff()
{
    if (_hSrvCtx != NULL)
    {
        TOCIResult result = OCILogoff(_hSrvCtx, _hError);
        if (result != OCI_SUCCESS)
        {
            TO3DBIString errortext;
            TOCIErrorcode errorcode = GetLastError(result, errortext);
            throw new O3DBIException(errorcode, errortext.c_str(),
                _T("O3DBIDatabase::LogOff"), this);
        }
        _bIsConnected = true;
        _hSrvCtx = NULL;
    }
}

bool O3DBIDatabase::IsConnected() const
{
    return _bIsConnected;
}

bool O3DBIDatabase::IsConnectionValid() const
{
    return true;
}

TO3DBIString O3DBIDatabase::ToString() const
{
    _TCHAR buffer[512];
    int p;

    p = _stprintf(buffer, _T("O3DBIDatabase at: 0x%x\n"), this);
    p += _stprintf(buffer + p, _T("\tService context handle: %x\n"), _hSrvCtx);
    _stprintf(buffer + p, _T("\tServer handle: %x\n"), _hServer);
    return TO3DBIString(buffer);
}

// ----------------------------------------------------------------------------
// Implementation of non-public, internal stuff

void O3DBIDatabase::AllocateServiceHandle()
{
    // Allocate service context handle
    TOCIResult result = OCIHandleAlloc(_hEnv,
        reinterpret_cast<TOCIDvoidPtr*>(&_hSrvCtx), OCI_HTYPE_SVCCTX,
        (size_t)0, (TOCIDvoidPtr*)NULL);
    if (result == OCI_INVALID_HANDLE)
    {
        throw new O3DBIException(-1, _T("Could not allocate service handle: ")
            _T("OCIHandleAlloc returned OCI_INVALID_HANDLE!"),
            _T("O3DBIDatabase::O3DBIDatabase"), this);
    }
}

void O3DBIDatabase::AllocateServerHandle()
{
    // Allocate server handle
    TOCIResult result = OCIHandleAlloc(_hEnv,
        reinterpret_cast<TOCIDvoidPtr*>(&_hServer), OCI_HTYPE_SERVER,
        (size_t)0, (TOCIDvoidPtr*)NULL);
    if (result == OCI_INVALID_HANDLE)
    {
        throw new O3DBIException(-1, _T("Could not allocate server handle: ")
            _T("OCIHandleAlloc returned OCI_INVALID_HANDLE!"),
            _T("O3DBIDatabase::O3DBIDatabase"), this);
    }
}

#pragma warning(pop)

---

Generated on Sun Jan 23 11:36:34 2005 for Oracle Object Oriented Database Interface (O3DBI) by  1.3.9.1