|
DB4ODBC
|
|||
---|---|---|---|
#18+
Добрый день, понимаю, что вопрос скорее всего останется без ответа, но больше некуда писать. Из Оракла необходимо настроить линк к базе clickhouse (от яндекса). Настроил DB4ODBC, настроил ODBC коннект к базе clickhouse, которые функционирует. Однако при настройке линка через DB4OBC получаю ошибку Exiting hgoulcp, rc=28500 at 2019/04/08-15:54:17 with error ptr FILE:hgoulcp.c LINE:1328 ID:Bindcol: Type Name На githubе висит открытый issue с похожей проблемой https://github.com/yandex/clickhouse-odbc/issues/138 Может, есть идеи, как можно настроить? Oracle Corporation --- MONDAY APR 08 2019 15:54:17.631 Heterogeneous Agent Release 12.2.0.1.0 Oracle Corporation --- MONDAY APR 08 2019 15:54:17.631 Version 12.2.0.1.0 Entered hgogprd HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG" Entered hgosdip setting HS_OPEN_CURSORS to default of 50 setting HS_NLS_NUMERIC_CHARACTERS to default of ".," setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER" setting HS_FDS_RECOVERY_PWD to default value setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG setting HS_IDLE_TIMEOUT to default of 0 setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED" setting HS_NLS_NCHAR to default of "UCS2" setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE" setting HS_FDS_DATE_MAPPING to default of "DATE" setting HS_RPC_FETCH_REBLOCKING to default of "ON" setting HS_FDS_FETCH_ROWS to default of "100" setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE" setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE" setting HS_FDS_PROC_IS_FUNC to default of "FALSE" setting HS_FDS_MAP_NCHAR to default of "TRUE" setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS" setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE" setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536" setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE" setting HS_FDS_QUERY_DRIVER to default of "TRUE" setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE" setting HS_FDS_QUOTE_IDENTIFIER to default of "TRUE" setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF" setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE" setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE" HOSGIP returned value of "64" for HS_FDS_SQLLEN_INTERPRETATION setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo;gtw$:OPTTables;gtw$:OPTColumns;gtw$:OPTPrimaryKeys;gtw$:OPTForeignKeys;gtw$:OPTProcedures;gtw$:OPTStatistics" setting HS_FDS_DELAYED_OPEN to default of "TRUE" setting HS_FDS_WORKAROUNDS to default of "0" setting HS_WORKAROUNDS to default of "0" Exiting hgosdip, rc=0 ORACLE_SID is "GTW2CH3" Product-Info: Port Rls/Upd:1/0 PrdStat:0 Agent:Oracle Database Gateway for ODBC Facility:hsa Class:ODBC, ClassVsn:12.2.0.1.0_0023, Instance:GTW2CH3 Exiting hgogprd, rc=0 HOA 04/08 15:54:17.663000000: (hotker_ExecuteRpcs) ncrorpi: status = 0 HOA 04/08 15:54:17.678000000: (hotker_ExecuteRpcs) ncrorpi: status = 0 Entered hgoinit HOCXU_COMP_CSET=1 HOCXU_DRV_CSET=871 HOCXU_DRV_NCHAR=1000 HOCXU_DB_CSET=171 HS_LANGUAGE is AMERICAN_AMERICA.UTF8 rc=-1 attempting to get LANG environment variable. HOCXU_SEM_VER=112000 HOCXU_VC2_MAX=4000 HOCXU_RAW_MAX=2000 Entered hgolofn at 2019/04/08-15:54:17 Exiting hgolofn, rc=0 at 2019/04/08-15:54:17 HOSGIP for "HS_OPEN_CURSORS" returned "50" HOSGIP for "HS_FDS_FETCH_ROWS" returned "100" HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536" HOSGIP for "HS_NLS_NUMERIC_CHARACTERS" returned ".," HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF" HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE" HOSGIP for "HS_FDS_WORKAROUNDS" returned "0" HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE" HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE" treat_SQLLEN_as_compiled = 1 Exiting hgoinit, rc=0 at 2019/04/08-15:54:17 Entered hgolgon at 2019/04/08-15:54:17 reco:0, name:ab, tflag:0 Entered hgosuec at 2019/04/08-15:54:17 Exiting hgosuec, rc=0 at 2019/04/08-15:54:17 HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER" HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG" HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE" HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE" HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE" HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE" HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE" HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE" HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE" using ab as default schema HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE" Entered hgocont at 2019/04/08-15:54:17 HS_FDS_CONNECT_INFO = "ch3" RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING" Entered hgogenconstr at 2019/04/08-15:54:17 dsn:ch3, name:ab optn: Entered hgocip at 2019/04/08-15:54:17 dsn:ch3 Exiting hgocip, rc=0 at 2019/04/08-15:54:17 Exiting hgogenconstr, rc=0 at 2019/04/08-15:54:17 Entered hgolosf at 2019/04/08-15:54:17 Exiting hgolosf, rc=0 at 2019/04/08-15:54:17 DriverName:CLICKHOUSEODBC.DLL, DriverVer:1.0.0.20190201 DBMS Name:ClickHouse, DBMS Version:01.00.0000 Exiting hgocont, rc=0 at 2019/04/08-15:54:17 SQLGetInfo returns Y for SQL_CATALOG_NAME SQLGetInfo returns 0 for SQL_MAX_CATALOG_NAME_LEN Exiting hgolgon, rc=0 at 2019/04/08-15:54:17 HOA 04/08 15:54:17.725000000: (hotker_ExecuteRpcs) ncrorpi: status = 0 Entered hgoulcp at 2019/04/08-15:54:17 Entered hgowlst at 2019/04/08-15:54:17 Exiting hgowlst, rc=0 at 2019/04/08-15:54:17 SQLGetInfo returns 0x0 for SQL_SCHEMA_USAGE TXN Capable:0, Isolation Option:0x8 SQLGetInfo returns 0 for SQL_MAX_SCHEMA_NAME_LEN SQL_SU_DML_STATEMENTS bit is not set. Schemas are not supported by FDS. SQLGetInfo returns 0 for SQL_MAX_TABLE_NAME_LEN SQLGetInfo returns 0 for SQL_MAX_PROCEDURE_NAME_LEN HOSGIP returned value of "TRUE" for HS_FDS_QUOTE_IDENTIFIER SQLGetInfo returns ` (0x60) for SQL_IDENTIFIER_QUOTE_CHAR Entered hgopoer at 2019/04/08-15:54:17 hgopoer, line 240: got native error 1 and sqlstate 07009; message follows... Column number 1 is out of range: 0 {07009,NativeErr = 1} Exiting hgopoer, rc=0 at 2019/04/08-15:54:17 hgoulcp, line 1328: calling SQLBindCol got sqlstate 07009 Exiting hgoulcp, rc=28500 at 2019/04/08-15:54:17 with error ptr FILE:hgoulcp.c LINE:1328 ID:Bindcol: Type Name ... |
|||
:
Нравится:
Не нравится:
|
|||
08.04.2019, 16:07 |
|
DB4ODBC
|
|||
---|---|---|---|
#18+
Avector, Используй доступ по http. ... |
|||
:
Нравится:
Не нравится:
|
|||
08.04.2019, 16:15 |
|
DB4ODBC
|
|||
---|---|---|---|
#18+
-2-, пробовал 9000 и 8123 порты, одинаковый результат. ... |
|||
:
Нравится:
Не нравится:
|
|||
08.04.2019, 16:17 |
|
DB4ODBC
|
|||
---|---|---|---|
#18+
-2-Avector, Используй доступ по http. или речь о том, чтобы из базы напрямую по http обращаться? ... |
|||
:
Нравится:
Не нравится:
|
|||
08.04.2019, 16:18 |
|
|
start [/forum/topic.php?fid=52&msg=39798247&tid=1882605]: |
0ms |
get settings: |
11ms |
get forum list: |
14ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
48ms |
get topic data: |
13ms |
get forum data: |
3ms |
get page messages: |
54ms |
get tp. blocked users: |
2ms |
others: | 320ms |
total: | 471ms |
0 / 0 |