summaryrefslogtreecommitdiff
path: root/cpp/demo/Database/Oracle/occi/Util.cpp
blob: 06a34455284fcb99e74bf5611bfb3c00dd4d671c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
// **********************************************************************
//
// Copyright (c) 2003-2007 ZeroC, Inc. All rights reserved.
//
// This copy of Ice is licensed to you under the terms described in the
// ICE_LICENSE file included in this distribution.
//
// **********************************************************************

#include <Ice/Ice.h>
#include <HR.h>
#include <Util.h>
#include <sstream>

using namespace std;
using namespace oracle::occi;

ConnectionHolder::ConnectionHolder(StatelessConnectionPool* pool) 
    : _con(pool->getAnyTaggedConnection()),
      _pool(pool)
{
}

ConnectionHolder::~ConnectionHolder()
{
    if(_con != 0)
    {
	try
	{
	    rollback();
	}
	catch(...)
	{
	    // ignored, to avoid a crash during 
	    // stack unwinding
	}
    }
}

void
ConnectionHolder::commit()
{
    assert(_con != 0);
    try
    {
	_con->commit();
    }
    catch(const SQLException& e)
    {
	release();
	throw HR::SqlException(e.what());
    }
    catch(...)
    {
	release();
	throw;
    }
    release();
}

void
ConnectionHolder::rollback()
{
    assert(_con != 0);
    try
    {
	_con->rollback();
    }
    catch(const SQLException& e)
    {
	release();
	throw HR::SqlException(e.what());
    }
    catch(...)
    {
	release();
	throw;
    }
    release();
}

void
ConnectionHolder::release()
{
    Connection* con = _con;
    _con = 0;
    _pool->releaseConnection(con);
}

StatementHolder::StatementHolder(Connection* con) :
    _stmt(con->createStatement()),
    _con(con)
{
}

StatementHolder::StatementHolder(ConnectionHolder& conh) :
    _stmt(conh.connection()->createStatement()),
    _con(conh.connection())
{
}

StatementHolder::~StatementHolder()
{
    _con->terminateStatement(_stmt);
}

int decodeName(const string& name)
{
    int result = 0;
    istringstream is(name);
    is >> result;
    if(!is || !is.eof())
    {
	cerr << "Unable to decode " << name << endl;
	throw Ice::ObjectNotExistException(__FILE__, __LINE__);
    }
    return result;
}

string encodeName(int n)
{
    ostringstream os;
    os << n;
    return os.str();
}