summaryrefslogtreecommitdiff
path: root/cpp/demo/Database/Oracle/proc/Util.pc
blob: 62b9ca665ed156e00aa79316c344c8e1ab00ccbe (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
// **********************************************************************
//
// Copyright (c) 2003-2010 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 sqlca& badca, sql_context sc)
{
    //
    // First rollback transaction
    //
    EXEC SQL BEGIN DECLARE SECTION;
    sql_context ctx = sc;
    EXEC SQL END DECLARE SECTION;
    
    sqlca sqlca;
    EXEC SQL CONTEXT USE :ctx;
    EXEC SQL ROLLBACK;

    string msg(badca.sqlerrm.sqlerrmc, badca.sqlerrm.sqlerrml);
    throw HR::SqlException(msg);
}

void 
handleNotFound(const Ice::Current& current, sql_context sc)
{
    //
    // First rollback transaction
    //
    EXEC SQL BEGIN DECLARE SECTION;
    sql_context ctx = sc;
    EXEC SQL END DECLARE SECTION;
    
    sqlca sqlca;
    EXEC SQL CONTEXT USE :ctx;
    EXEC SQL ROLLBACK;

    throw Ice::ObjectNotExistException(__FILE__, __LINE__, current.id, current.facet, current.operation);
}

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