summaryrefslogtreecommitdiff
path: root/cpp/demo/Database/Oracle/proc/Util.pc
blob: 2c30064995ca0cd000281572e1d865ba6491aae5 (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
// **********************************************************************
//
// Copyright (c) 2003-2006 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;

void handleSqlError(const struct sqlca& badca, sql_context sc)
{
    //
    // First rollback transaction
    //
    EXEC SQL BEGIN DECLARE SECTION;
    sql_context ctx = sc;
    EXEC SQL END DECLARE SECTION;
    
    struct sqlca sqlca;
    EXEC SQL CONTEXT USE :ctx;
    EXEC SQL ROLLBACK;

    if(badca.sqlcode > 0)
    {
	throw Ice::ObjectNotExistException(__FILE__, __LINE__);
    }
    else
    {
	string msg(badca.sqlerrm.sqlerrmc, badca.sqlerrm.sqlerrml);
	throw HR::SqlException(msg);
    }
}

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();
}