[IGNITE-1786] Need to implement ODBC driver for Ignite

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.6
• Component/s: odbc
• Assignee: Igor Sapego
• Reporter: Dmitriy Setrakyan
• Created: 24/Oct/15 00:08
• Updated: 05/Aug/16 09:46
• Resolved: 05/May/16 14:01

Description

1. We have a C++ API for Ignite which starts JVM internally. Probably we can just add that ODBC API there.
2. Another approach is to implement really separate driver and a network server on java side which will interact with each other.

The first one is simpler and probably more effective, but heavyweight. The second one is probably slower but but more lightweight.

Issue Links

• links to: GitHub Pull Request #273
• mentioned in: Page Loading...

Sub-Tasks

• CPP: Create test project for ODBC driver.: Closed
• CPP: Add local tests for ODBC driver.: Closed
• CPP: Fix bugs revealed by the ODBC tests.: Closed
• Make message handling by OdbcProcessor synchronous.: Closed
• CPP: Implement catalog ODBC API functions: Closed
• CPP: Implement basic support of the params for the ODBC driver.: Closed
• CPP: Implement access to the metadata for result sets of the ODBC driver.: Closed
• CPP: Implement basic support of SQLForeignKeys API call for ODBC driver.: Closed
• Simplify ODBC command handler.: Closed
• Cleanup ODBC configuration.: Closed
• CPP: Move ODBC MSVS projects to separate solution.: Closed
• CPP: ODBC driver supported version should be upgraded to 3.x: Closed
• CPP: Tableau displays textual data in wrong locale.: Closed
• CPP: Implement "Bind offset" feature for the ODBC driver.: Closed
• CPP: Implement SQLConnect function for the ODBC driver.: Closed
• CPP: Implement support of Linux OS family for the ODBC driver.: Closed
• CPP: Implement obtaining of diagnostic information for ODBC driver.: Closed
• CPP: ODBC queries sometimes return wrong types for columns in metadata.: Closed
• ODBC driver does not return any data with SQLColumns and SQLTables calls.: Closed
• CPP: Implement SQLGetTypeInfo function for the ODBC driver.: Closed
• CPP: Implement SQLEndTran function for the ODBC driver.: Closed
• CPP: Implement SQLGetData function for the ODBC driver.: Closed
• CPP: Implement Environment attributes manipulation for the ODBC driver.: Closed
• CPP: Implement obtaining the row-identifying column of tables for the ODBC driver.: Closed
• ODBC: Add examples.: Closed
• Remove NULL and <cstddef> from interop_stream_position_guard.h: Closed
• ODBC: binary.vcxproj has invalid build tools version.: Closed
• ODBC: Is there any reason to have separate VS solution for ODBC?: Closed
• ODBC: Ensure that versions of new CPP projects are updated correctly.: Closed
• ODBC: odbc.sln references VS2014.: Closed
• IgntieConfiguration.odbcConfiguration must have sensible JavaDocs.: Closed
• ODBC: OdbcConfiguration must have "host" property.: Closed
• ODBC: Consistent naming of Java classes.: Closed
• ODBC: Remove OdbcProtocolHandler.: Closed
• ODBC: One-row queries can not be fetched.: Closed
• ODBC: Rows containing Null-columns can't be fetched.: Closed
• ODBC: Tables look up should return tables from other caches as well.: Closed
• ODBC: It should be possible to make requests to default (null) cache.: Closed
• ODBC: Implement example that can be used for data visualization.: Closed
• ODBC: Add integrity tests.: Closed
• ODBC: Add support for Date and Timestamp types.: Closed
• ODBC: OdbcNioParser is implemented incorrectly.: Closed
• ODBC: Potential memory leak during client disconnect.: Closed
• ODBC: Add protocol version to protocol packet header.: Closed
• ODBC: Potential memory leak when Throwable is thrown inside OdbcRequestHandler: Closed
• ODBC: Cursors should be removed in case of exception only in OdbcRequestHandler.executeQuery() method.: Closed
• ODBC: Query ID is insecure.: Closed
• ODBC: Exception is swallowed in OdbcNioListener.trySendErrorMessage(): Closed
• ODBC: Mark Date/Time scalar functions as supported.: Closed
• CPP: Disable ODBC in tests configuration to prevent tests with multiple nodes from failing.: Closed
• ODBC: Time cast returns wrong results for Linux.: Closed
• CPP: Split libcommon in two libraries to get rid of libjvm dependency.: Closed
• ODBC: Metadata type retrieval algorithm is wrong.: Closed
• ODBC: Multiple grids cannot start with default configuration due to port conflict.: Closed
• ODBC: QueriesTestSuite from odbc-test uses outdated version of MakeDate and MakeTimestamp.: Closed