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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
|
// file : odb/mssql/error.cxx
// author : Boris Kolpackov <boris@codesynthesis.com>
// copyright : Copyright (c) 2005-2011 Code Synthesis Tools CC
// license : GNU GPL v2; see accompanying LICENSE file
#include <string>
#include <odb/mssql/mssql.hxx>
#include <odb/mssql/error.hxx>
#include <odb/mssql/connection.hxx>
#include <odb/mssql/exceptions.hxx>
using namespace std;
namespace odb
{
namespace mssql
{
static void
translate_error (SQLHANDLE h, SQLSMALLINT htype, connection* conn)
{
SQLRETURN r;
char sqlstate[SQL_SQLSTATE_SIZE + 1];
SQLINTEGER native_code; // Will be 0 if no natve code.
char msg[512]; // Will be truncated if doesn't fit.
SQLSMALLINT msg_size;
// We need to translate certain sqlstate codes to special exceptions,
// such as deadlock, timeout, etc. The problem is we can have multiple
// records potentially with different sqlstate codes. If we have both,
// say, a deadlock code and some other code, then we should probably
// throw database_exception, which is more severe. To implement this
// we are going to pre-scan the records looking for the codes we are
// interested in. If in the process we see any other code, then we
// stop and go ahead to prepare and throw database_exception.
//
enum code
{
code_none,
code_deadlock,
code_timeout,
code_connection_lost,
};
code c (code_none);
for (SQLSMALLINT i (1);; ++i)
{
r = SQLGetDiagRec (htype,
h,
i,
(SQLCHAR*) sqlstate,
&native_code,
0,
0,
&msg_size);
string s (sqlstate);
if (r == SQL_NO_DATA)
break;
else if (SQL_SUCCEEDED (r))
{
code nc;
if (s == "40001") // Serialization failure (native code 1205).
nc = code_deadlock;
else if (s == "HYT00") // Timeout expired.
nc = code_timeout;
else if (s == "HYT01") // Connection timeout expired.
{
nc = code_timeout;
if (conn != 0)
conn->mark_failed ();
}
else if (s == "08S01") // Link failure.
{
nc = code_connection_lost;
if (conn != 0)
conn->mark_failed ();
}
else if (s == "01000") // General warning.
continue;
else
{
c = code_none;
break;
}
if (c != code_none && c != nc)
{
// Several different codes.
//
c = code_none;
break;
}
c = nc;
}
else
{
c = code_none;
break;
}
}
switch (c)
{
case code_deadlock:
throw deadlock ();
case code_timeout:
throw timeout ();
case code_connection_lost:
throw connection_lost ();
case code_none:
break;
}
// Some other error code. Prepare database_exception.
//
database_exception e;
for (SQLSMALLINT i (1);; ++i)
{
r = SQLGetDiagRec (htype,
h,
i,
(SQLCHAR*) sqlstate,
&native_code,
(SQLCHAR*) msg,
sizeof (msg),
&msg_size);
if (r == SQL_NO_DATA)
break;
else if (SQL_SUCCEEDED (r))
{
if (conn != 0)
{
string s (sqlstate);
if (s == "08S01" || // Link failure.
s == "HYT01") // Connection timeout.
conn->mark_failed ();
}
e.append (native_code, sqlstate, msg);
}
else
e.append (0, "?????", "unable to extract information for this "
"diagnostic record");
}
if (e.size () == 0)
e.append (0, "?????", "no diagnostic record (using wrong handle?)");
throw e;
}
void
translate_error (connection& c)
{
translate_error (c.handle (), SQL_HANDLE_DBC, &c);
}
void
translate_error (connection& c, const auto_handle<SQL_HANDLE_STMT>& h)
{
translate_error (h, SQL_HANDLE_STMT, &c);
}
void
translate_error (SQLHANDLE h, SQLSMALLINT htype)
{
translate_error (h, htype, 0);
}
}
}
|
