Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 DB4ODBC  [new]
Avector
Member

Откуда: Санкт-Петербург
Сообщений: 362
Добрый день, понимаю, что вопрос скорее всего останется без ответа, но больше некуда писать.

Из Оракла необходимо настроить линк к базе 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
8 апр 19, 16:07    [21856128]     Ответить | Цитировать Сообщить модератору
 Re: DB4ODBC  [new]
-2-
Member

Откуда:
Сообщений: 14504
Avector,

Используй доступ по http.
8 апр 19, 16:15    [21856142]     Ответить | Цитировать Сообщить модератору
 Re: DB4ODBC  [new]
Avector
Member

Откуда: Санкт-Петербург
Сообщений: 362
-2-,

пробовал 9000 и 8123 порты, одинаковый результат.
8 апр 19, 16:17    [21856144]     Ответить | Цитировать Сообщить модератору
 Re: DB4ODBC  [new]
Avector
Member

Откуда: Санкт-Петербург
Сообщений: 362
-2-
Avector,

Используй доступ по http.


или речь о том, чтобы из базы напрямую по http обращаться?
8 апр 19, 16:18    [21856145]     Ответить | Цитировать Сообщить модератору
 Re: DB4ODBC  [new]
-2-
Member

Откуда:
Сообщений: 14504
Avector
или речь о том, чтобы из базы напрямую по http обращаться?
настроить network acl и
httpuritype('http://цлицкхоузе:8123/?query=SELECT%201').getclob()
для удабства парса можно задать формат json или xml.
8 апр 19, 16:30    [21856176]     Ответить | Цитировать Сообщить модератору
Все форумы / Oracle Ответить