GridGain Developers Hub

ODBC Standard Conformance

Overview

ODBC defines several Interface conformance levels. In this section you can find which features are supported by the Apache Ignite ODBC driver.

Core Interface Conformance

Feature Supported Comments

Allocate and free all types of handles, by calling SQLAllocHandle and SQLFreeHandle.

YES

Use all forms of the SQLFreeStmt function.

YES

Bind result set columns, by calling SQLBindCol.

YES

Handle dynamic parameters, including arrays of parameters, in the input direction only, by calling SQLBindParameter and SQLNumParams.

YES

Specify a bind offset.

YES

Use the data-at-execution dialog, involving calls to SQLParamData and SQLPutData

YES

Manage cursors and cursor names, by calling SQLCloseCursor, SQLGetCursorName, and SQLSetCursorName.

PARTIALLY

SQLCloseCursor is implemented. Named cursors are not supported by Ignite SQL.

Gain access to the description (metadata) of result sets, by calling SQLColAttribute, SQLDescribeCol, SQLNumResultCols, and SQLRowCount.

YES

Query the data dictionary, by calling the catalog functions SQLColumns, SQLGetTypeInfo, SQLStatistics, and SQLTables.

PARTIALLY

SQLStatistics is not supported.

Manage data sources and connections, by calling SQLConnect, SQLDataSources, SQLDisconnect, and SQLDriverConnect. Obtain information on drivers, no matter which ODBC level they support, by calling SQLDrivers.

PARTIALLY

DSN support is not implemented.

Prepare and execute SQL statements, by calling SQLExecDirect, SQLExecute, and SQLPrepare.

YES

SQLPrepare is not supported on SQL side.

Fetch one row of a result set or multiple rows, in the forward direction only, by calling SQLFetch or by calling SQLFetchScroll with the FetchOrientation argument set to SQL_FETCH_NEXT

YES

Obtain an unbound column in parts, by calling SQLGetData.

YES

Obtain current values of all attributes, by calling SQLGetConnectAttr, SQLGetEnvAttr, and SQLGetStmtAttr, and set all attributes to their default values and set certain attributes to non-default values by calling SQLSetConnectAttr, SQLSetEnvAttr, and SQLSetStmtAttr.

PARTIALLY

Not all attributes are currently supported. See table below for details.

Manipulate certain fields of descriptors, by calling SQLCopyDesc, SQLGetDescField, SQLGetDescRec, SQLSetDescField, and SQLSetDescRec.

NO

Obtain diagnostic information, by calling SQLGetDiagField and SQLGetDiagRec.

YES

Detect driver capabilities, by calling SQLGetFunctions and SQLGetInfo. Also, detect the result of any text substitutions made to an SQL statement before it is sent to the data source, by calling SQLNativeSql.

YES

Use the syntax of SQLEndTran to commit a transaction. A Core-level driver need not support true transactions; therefore, the application cannot specify SQL_ROLLBACK nor SQL_AUTOCOMMIT_OFF for the SQL_ATTR_AUTOCOMMIT connection attribute.

YES

Call SQLCancel to cancel the data-at-execution dialog and, in multi-thread environments, to cancel an ODBC function executing in another thread. Core-level interface conformance does not mandate support for asynchronous execution of functions, nor the use of SQLCancel to cancel an ODBC function executing asynchronously. Neither the platform nor the ODBC driver need be multi-thread for the driver to conduct independent activities at the same time. However, in multi-thread environments, the ODBC driver must be thread-safe. Serialization of requests from the application is a conformant way to implement this specification, even though it might create serious performance problems.

NO

Obtain the SQL_BEST_ROWID row-identifying column of tables, by calling SQLSpecialColumns.

PARTIALLY

Current implementation always returns an empty row set.

Level 1 Interface Conformance

Feature Supported Comments

Specify the schema of database tables and views (using two-part naming).

YES

Invoke true asynchronous execution of ODBC functions, where applicable ODBC functions are all synchronous or all asynchronous on a given connection.

NO

Use scrollable cursors, and thereby achieve access to a result set in methods other than forward-only, by calling SQLFetchScroll with the FetchOrientation argument other than SQL_FETCH_NEXT.

NO

Obtain primary keys of tables, by calling SQLPrimaryKeys.

YES

Use stored procedures, through the ODBC escape sequence for procedure calls, and query the data dictionary regarding stored procedures, by calling SQLProcedureColumns and SQLProcedures.

NO

Connect to a data source by interactively browsing the available servers, by calling SQLBrowseConnect.

NO

Use ODBC functions instead of SQL statements to perform certain database operations: SQLSetPos with SQL_POSITION and SQL_REFRESH.

NO

Gain access to the contents of multiple result sets generated by batches and stored procedures, by calling SQLMoreResults.

YES

Delimit transactions spanning several ODBC functions, with true atomicity and the ability to specify SQL_ROLLBACK in SQLEndTran.

YES

Level 2 Interface Conformance

Feature Supported Comments

Use three-part names of database tables and views.

NO

GridGain SQL does not support catalogs.

Describe dynamic parameters, by calling SQLDescribeParam.

NO

Use not only input parameters but also output and input/output parameters, and result values of stored procedures.

NO

GridGain SQL does not support output parameters

Use bookmarks, including retrieving bookmarks, by calling SQLDescribeCol and SQLColAttribute on column number 0; fetching based on a bookmark, by calling SQLFetchScroll with the FetchOrientation argument set to SQL_FETCH_BOOKMARK; and update, delete, and fetch by bookmark operations, by calling SQLBulkOperations with the Operation argument set to SQL_UPDATE_BY_BOOKMARK, SQL_DELETE_BY_BOOKMARK, or SQL_FETCH_BY_BOOKMARK.

NO

GridGain SQL does not support bookmarks.

Retrieve advanced information about the data dictionary, by calling SQLColumnPrivileges, SQLForeignKeys, and SQLTablePrivileges.

PARTIALLY

SQLForeignKeys implemented, but returns empty result set.

Use ODBC functions instead of SQL statements to perform additional database operations, by calling SQLBulkOperations with SQL_ADD, or SQLSetPos with SQL_DELETE or SQL_UPDATE.

NO

Enable asynchronous execution of ODBC functions for specified individual statements.

NO

Obtain the SQL_ROWVER row-identifying column of tables, by calling SQLSpecialColumns.

NO

Set the SQL_ATTR_CONCURRENCY statement attribute to at least one value other than SQL_CONCUR_READ_ONLY.

NO

The ability to time out login request and SQL queries (SQL_ATTR_LOGIN_TIMEOUT and SQL_ATTR_QUERY_TIMEOUT).

YES

The ability to change the default isolation level; the ability to execute transactions with the "serializable" level of isolation.

NO

Function Conformance

Function Supported Conformance level

SQLAllocHandle

YES

Core

SQLBindCol

YES

Core

SQLBindParameter

YES

Core

SQLBrowseConnect

NO

Level 1

SQLBulkOperations

NO

Level 1

SQLCancel

NO

Core

SQLCloseCursor

YES

Core

SQLColAttribute

YES

Core

SQLColumnPrivileges

NO

Level 2

SQLColumns

YES

Core

SQLConnect

YES

Core

SQLCopyDesc

NO

Core

SQLDataSources

N/A

Core

SQLDescribeCol

YES

Core

SQLDescribeParam

NO

Level 2

SQLDisconnect

YES

Core

SQLDriverConnect

YES

Core

SQLDrivers

N/A

Core

SQLEndTran

PARTIALLY

Core

SQLExecDirect

YES

Core

SQLExecute

YES

Core

SQLFetch

YES

Core

SQLFetchScroll

YES

Core

SQLForeignKeys

PARTIALLY

Level 2

SQLFreeHandle

YES

Core

SQLFreeStmt

YES

Core

SQLGetConnectAttr

PARTIALLY

Core

SQLGetCursorName

NO

Core

SQLGetData

YES

Core

SQLGetDescField

NO

Core

SQLGetDescRec

NO

Core

SQLGetDiagField

YES

Core

SQLGetDiagRec

YES

Core

SQLGetEnvAttr

PARTIALLY

Core

SQLGetFunctions

NO

Core

SQLGetInfo

YES

Core

SQLGetStmtAttr

PARTIALLY

Core

SQLGetTypeInfo

YES

Core

SQLMoreResults

YES

Level 1

SQLNativeSql

YES

Core

SQLNumParams

YES

Core

SQLNumResultCols

YES

Core

SQLParamData

YES

Core

SQLPrepare

YES

Core

SQLPrimaryKeys

YES

Level 1

SQLProcedureColumns

NO

Level 1

SQLProcedures

NO

Level 1

SQLPutData

YES

Core

SQLRowCount

YES

Core

SQLSetConnectAttr

PARTIALLY

Core

SQLSetCursorName

NO

Core

SQLSetDescField

NO

Core

SQLSetDescRec

NO

Core

SQLSetEnvAttr

PARTIALLY

Core

SQLSetPos

NO

Level 1

SQLSetStmtAttr

PARTIALLY

Core

SQLSpecialColumns

PARTIALLY

Core

SQLStatistics

NO

Core

SQLTablePrivileges

NO

Level 2

SQLTables

YES

Core

Environment Attribute Conformance

Feature Supported Conformance Level

SQL_ATTR_CONNECTION_POOLING

NO

Optional

SQL_ATTR_CP_MATCH

NO

Optional

SQL_ATTR_ODBC_VER

YES

Core

SQL_ATTR_OUTPUT_NTS

YES

Optional

Connection Attribute Conformance

Feature Supported Conformance Level

SQL_ATTR_ACCESS_MODE

NO

Core

SQL_ATTR_ASYNC_ENABLE

NO

Level 1 / Level 2

SQL_ATTR_AUTO_IPD

NO

Level 2

SQL_ATTR_AUTOCOMMIT

YES

Level 1

SQL_ATTR_CONNECTION_DEAD

YES

Level 1

SQL_ATTR_CONNECTION_TIMEOUT

YES

Level 2

SQL_ATTR_CURRENT_CATALOG

NO

Level 2

SQL_ATTR_LOGIN_TIMEOUT

YES

Level 2

SQL_ATTR_ODBC_CURSORS

NO

Core

SQL_ATTR_PACKET_SIZE

NO

Level 2

SQL_ATTR_QUIET_MODE

NO

Core

SQL_ATTR_TRACE

NO

Core

SQL_ATTR_TRACEFILE

NO

Core

SQL_ATTR_TRANSLATE_LIB

NO

Core

SQL_ATTR_TRANSLATE_OPTION

NO

Core

SQL_ATTR_TXN_ISOLATION

NO

Level 1 / Level 2

Statement Attribute Conformance

Feature Supported Conformance Level

SQL_ATTR_APP_PARAM_DESC

PARTIALLY

Core

SQL_ATTR_APP_ROW_DESC

PARTIALLY

Core

SQL_ATTR_ASYNC_ENABLE

NO

Level 1/ Level 2

SQL_ATTR_CONCURRENCY

NO

Level 1 / Level 2

SQL_ATTR_CURSOR_SCROLLABLE

NO

Level 1

SQL_ATTR_CURSOR_SENSITIVITY

NO

Level 2

SQL_ATTR_CURSOR_TYPE

NO

Level 1 / Level 2

SQL_ATTR_ENABLE_AUTO_IPD

NO

Level 2

SQL_ATTR_FETCH_BOOKMARK_PTR

NO

Level 2

SQL_ATTR_IMP_PARAM_DESC

PARTIALLY

Core

SQL_ATTR_IMP_ROW_DESC

PARTIALLY

Core

SQL_ATTR_KEYSET_SIZE

NO

Level 2

SQL_ATTR_MAX_LENGTH

NO

Level 1

SQL_ATTR_MAX_ROWS

NO

Level 1

SQL_ATTR_METADATA_ID

NO

Core

SQL_ATTR_NOSCAN

NO

Core

SQL_ATTR_PARAM_BIND_OFFSET_PTR

YES

Core

SQL_ATTR_PARAM_BIND_TYPE

NO

Core

SQL_ATTR_PARAM_OPERATION_PTR

NO

Core

SQL_ATTR_PARAM_STATUS_PTR

YES

Core

SQL_ATTR_PARAMS_PROCESSED_PTR

YES

Core

SQL_ATTR_PARAMSET_SIZE

YES

Core

SQL_ATTR_QUERY_TIMEOUT

YES

Level 2

SQL_ATTR_RETRIEVE_DATA

NO

Level 1

SQL_ATTR_ROW_ARRAY_SIZE

YES

Core

SQL_ATTR_ROW_BIND_OFFSET_PTR

YES

Core

SQL_ATTR_ROW_BIND_TYPE

YES

Core

SQL_ATTR_ROW_NUMBER

NO

Level 1

SQL_ATTR_ROW_OPERATION_PTR

NO

Level 1

SQL_ATTR_ROW_STATUS_PTR

YES

Core

SQL_ATTR_ROWS_FETCHED_PTR

YES

Core

SQL_ATTR_SIMULATE_CURSOR

NO

Level 2

SQL_ATTR_USE_BOOKMARKS

NO

Level 2

Descriptor Header Fields Conformance

Feature Supported Conformance Level

SQL_DESC_ALLOC_TYPE

NO

Core

SQL_DESC_ARRAY_SIZE

NO

Core

SQL_DESC_ARRAY_STATUS_PTR

NO

Core / Level 1

SQL_DESC_BIND_OFFSET_PTR

NO

Core

SQL_DESC_BIND_TYPE

NO

Core

SQL_DESC_COUNT

NO

Core

SQL_DESC_ROWS_PROCESSED_PTR

NO

Core

Descriptor Record Fields Conformance

Feature Supported Conformance Level

SQL_DESC_AUTO_UNIQUE_VALUE

NO

Level 2

SQL_DESC_BASE_COLUMN_NAME

NO

Core

SQL_DESC_BASE_TABLE_NAME

NO

Level 1

SQL_DESC_CASE_SENSITIVE

NO

Core

SQL_DESC_CATALOG_NAME

NO

Level 2

SQL_DESC_CONCISE_TYPE

NO

Core

SQL_DESC_DATA_PTR

NO

Core

SQL_DESC_DATETIME_INTERVAL_CODE

NO

Core

SQL_DESC_DATETIME_INTERVAL_PRECISION

NO

Core

SQL_DESC_DISPLAY_SIZE

NO

Core

SQL_DESC_FIXED_PREC_SCALE

NO

Core

SQL_DESC_INDICATOR_PTR

NO

Core

SQL_DESC_LABEL

NO

Level 2

SQL_DESC_LENGTH

NO

Core

SQL_DESC_LITERAL_PREFIX

NO

Core

SQL_DESC_LITERAL_SUFFIX

NO

Core

SQL_DESC_LOCAL_TYPE_NAME

NO

Core

SQL_DESC_NAME

NO

Core

SQL_DESC_NULLABLE

NO

Core

SQL_DESC_OCTET_LENGTH

NO

Core

SQL_DESC_OCTET_LENGTH_PTR

NO

Core

SQL_DESC_PARAMETER_TYPE

NO

Core / Level 2

SQL_DESC_PRECISION

NO

Core

SQL_DESC_ROWVER

NO

Level 1

SQL_DESC_SCALE

NO

Core

SQL_DESC_SCHEMA_NAME

NO

Level 1

SQL_DESC_SEARCHABLE

NO

Core

SQL_DESC_TABLE_NAME

NO

Level 1

SQL_DESC_TYPE

NO

Core

SQL_DESC_TYPE_NAME

NO

Core

SQL_DESC_UNNAMED

NO

Core

SQL_DESC_UNSIGNED

NO

Core

SQL_DESC_UPDATABLE

NO

Core

SQL Data Types

The following SQL data types listed in the specification are supported:

Data Type Supported

SQL_CHAR

YES

SQL_VARCHAR

YES

SQL_LONGVARCHAR

YES

SQL_WCHAR

NO

SQL_WVARCHAR

NO

SQL_WLONGVARCHAR

NO

SQL_DECIMAL

YES

SQL_NUMERIC

NO

SQL_SMALLINT

YES

SQL_INTEGER

YES

SQL_REAL

NO

SQL_FLOAT

YES

SQL_DOUBLE

YES

SQL_BIT

YES

SQL_TINYINT

YES

SQL_BIGINT

YES

SQL_BINARY

YES

SQL_VARBINARY

YES

SQL_LONGVARBINARY

YES

SQL_TYPE_DATE

YES

SQL_TYPE_TIME

YES

SQL_TYPE_TIMESTAMP

YES

SQL_TYPE_UTCDATETIME

NO

SQL_TYPE_UTCTIME

NO

SQL_INTERVAL_MONTH

NO

SQL_INTERVAL_YEAR

NO

SQL_INTERVAL_YEAR_TO_MONTH

NO

SQL_INTERVAL_DAY

NO

SQL_INTERVAL_HOUR

NO

SQL_INTERVAL_MINUTE

NO

SQL_INTERVAL_SECOND

NO

SQL_INTERVAL_DAY_TO_HOUR

NO

SQL_INTERVAL_DAY_TO_MINUTE

NO

SQL_INTERVAL_DAY_TO_SECOND

NO

SQL_INTERVAL_HOUR_TO_MINUTE

NO

SQL_INTERVAL_HOUR_TO_SECOND

NO

SQL_INTERVAL_MINUTE_TO_SECOND

NO

SQL_GUID

YES