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
|
/* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* The ASF licenses this file to You under the Apache License, Version 2.0
* (the "License"); you may not use this file except in compliance with
* the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
/* ONLY USED FOR ODBC Version 2 -DODBCV2
*
* Re-define everything to work (more-or-less) in an ODBC V2 environment
* Random access to retrieved rows is not supported - i.e. calls to apr_dbd_select() cannot
* have a 'random' argument of 1. apr_dbd_get_row() must always pass rownum as 0 (get next row)
*
*/
#define SQLHANDLE SQLHENV /* Presumes that ENV, DBC, and STMT handles are all the same datatype */
#define SQL_NULL_HANDLE 0
#define SQL_HANDLE_STMT 1
#define SQL_HANDLE_DBC 2
#define SQL_HANDLE_ENV 3
#define SQL_NO_DATA SQL_NO_DATA_FOUND
#ifndef SQL_SUCCEEDED
#define SQL_SUCCEEDED(rc) (((rc)&(~1))==0)
#endif
#undef SQLSetEnvAttr
#define SQLSetEnvAttr(henv, Attribute, Value, StringLength) (0)
#undef SQLAllocHandle
#define SQLAllocHandle(type, parent, hndl) \
( (type == SQL_HANDLE_STMT) ? SQLAllocStmt(parent, hndl) \
: (type == SQL_HANDLE_ENV) ? SQLAllocEnv(hndl) \
: SQLAllocConnect(parent, hndl) \
)
#undef SQLFreeHandle
#define SQLFreeHandle(type, hndl) \
( (type == SQL_HANDLE_STMT) ? SQLFreeStmt(hndl, SQL_DROP) \
: (type == SQL_HANDLE_ENV) ? SQLFreeEnv(hndl) \
: SQLFreeConnect(hndl) \
)
#undef SQLGetDiagRec
#define SQLGetDiagRec(type, h, i, state, native, buffer, bufsize, reslen) \
SQLError( (type == SQL_HANDLE_ENV) ? h : NULL, \
(type == SQL_HANDLE_DBC) ? h : NULL, \
(type == SQL_HANDLE_STMT) ? h : NULL, \
state, native, buffer, bufsize, reslen)
#undef SQLCloseCursor
#define SQLCloseCursor(stmt) SQLFreeStmt(stmt, SQL_CLOSE)
#undef SQLGetConnectAttr
#define SQLGetConnectAttr(hdbc, fOption, ValuePtr, BufferLength, NULL) \
SQLGetConnectOption(hdbc, fOption, ValuePtr)
#undef SQLSetConnectAttr
#define SQLSetConnectAttr(hdbc, fOption, ValuePtr, BufferLength) \
SQLSetConnectOption(hdbc, fOption, (SQLUINTEGER) ValuePtr)
#undef SQLSetStmtAttr
#define SQLSetStmtAttr(hstmt, fOption, ValuePtr, BufferLength) (0); return APR_ENOTIMPL;
#undef SQLEndTran
#define SQLEndTran(hType, hdbc,type) SQLTransact(henv, hdbc, type)
#undef SQLFetchScroll
#define SQLFetchScroll(stmt, orient, rownum) (0); return APR_ENOTIMPL;
#define SQL_DESC_TYPE SQL_COLUMN_TYPE
#define SQL_DESC_CONCISE_TYPE SQL_COLUMN_TYPE
#define SQL_DESC_DISPLAY_SIZE SQL_COLUMN_DISPLAY_SIZE
#define SQL_DESC_OCTET_LENGTH SQL_COLUMN_LENGTH
#define SQL_DESC_UNSIGNED SQL_COLUMN_UNSIGNED
#undef SQLColAttribute
#define SQLColAttribute(s, c, f, a, l, m, n) SQLColAttributes(s, c, f, a, l, m, n)
#define SQL_ATTR_ACCESS_MODE SQL_ACCESS_MODE
#define SQL_ATTR_AUTOCOMMIT SQL_AUTOCOMMIT
#define SQL_ATTR_CONNECTION_TIMEOUT 113
#define SQL_ATTR_CURRENT_CATALOG SQL_CURRENT_QUALIFIER
#define SQL_ATTR_DISCONNECT_BEHAVIOR 114
#define SQL_ATTR_ENLIST_IN_DTC 1207
#define SQL_ATTR_ENLIST_IN_XA 1208
#define SQL_ATTR_CONNECTION_DEAD 1209
#define SQL_CD_TRUE 1L /* Connection is closed/dead */
#define SQL_CD_FALSE 0L /* Connection is open/available */
#define SQL_ATTR_LOGIN_TIMEOUT SQL_LOGIN_TIMEOUT
#define SQL_ATTR_ODBC_CURSORS SQL_ODBC_CURSORS
#define SQL_ATTR_PACKET_SIZE SQL_PACKET_SIZE
#define SQL_ATTR_QUIET_MODE SQL_QUIET_MODE
#define SQL_ATTR_TRACE SQL_OPT_TRACE
#define SQL_ATTR_TRACEFILE SQL_OPT_TRACEFILE
#define SQL_ATTR_TRANSLATE_LIB SQL_TRANSLATE_DLL
#define SQL_ATTR_TRANSLATE_OPTION SQL_TRANSLATE_OPTION
#define SQL_ATTR_TXN_ISOLATION SQL_TXN_ISOLATION
#define SQL_ATTR_CURSOR_SCROLLABLE -1
#define SQL_C_SBIGINT (SQL_BIGINT+SQL_SIGNED_OFFSET) /* SIGNED BIGINT */
#define SQL_C_UBIGINT (SQL_BIGINT+SQL_UNSIGNED_OFFSET) /* UNSIGNED BIGINT */
#define SQL_FALSE 0
#define SQL_TRUE 1
|
