JDBC FOR ORACLE FAILED

Question

JDBC FOR ORACLE FAILED

ldboyghg opened this issue 3 years ago · 8 comments

ldboyghg commented 3 years ago

HI
CASE : jdbc connect oracle

i want to get BigData from oracle by jdbc

when i spend Single query ,client dbeaver could return correctly data with a little slowly.

querySql:select * from jdbc("jdbc:oracle:thin:user/passwd@host:port:instance", "query");

BUT JDBC bridge server print some info on background like this :

[2022-03-11 11:35:34] [INFO ] Raw query:
SELECT * FROM bigTable
[2022-03-11 11:35:34] [WARNING] Failed call setClientInfo due to Invalid or unsupported name for clientInfo.
[2022-03-11 11:35:34] [INFO ] Executing query(schema=[]):
SELECT * FROM bigTable
[2022-03-11 11:35:34] [WARNING] Failed call setClientInfo due to Invalid or unsupported name for clientInfo.
[2022-03-11 11:35:39] [SEVERE ] Caught exception
[2022-03-11 11:35:39] [SEVERE ] Caught exception
[2022-03-11 11:35:39] [WARNING] Still have at least 56100 bytes in buffer
[2022-03-11 11:35:39] [SEVERE ] Failed to respond

is client buffer not enough or my query outtime?
where could i set these params.?

thank you.

Answer 1 · 2022-03-11T04:20:59.000Z

when i run the same Sql in clickhouse-client , promt like this :

DB::Exception: Cannot read from istream at offset 375390208: While executing BinaryRowInputFormat: While executing JDBC. (CANNOT_READ_FROM_ISTREAM)

Answer 2 · 2022-03-11T04:22:02.000Z

JDBC bridge timeout, for examples: queryTimeout in config/server.json, and maxWorkerExecuteTime in config/vertx.json
these params wo changed *10, but no effect.

Answer 3 · 2022-03-11T04:23:36.000Z

How long it takes for the query on Oracle?

Answer 4 · 2022-03-11T05:43:29.000Z

The table is a width result tab on oracle in DWD level. ,4000W rows.

Answer 5 · 2022-03-11T05:44:26.000Z

在oracle已经是个结果落地的结果表了, 在不加载所有数据的情况下, 查询是秒出结果,但是通过jdbc客户端就很慢.

Answer 6 · 2022-03-11T10:12:24.000Z

The table is a width result tab on oracle in DWD level. ,4000W rows.

What's the max_execution_time in ClickHouse? And if you're using JDBC to access ClickHouse, what's the socket_timeout?

Answer 7 · 2022-03-15T06:33:59.000Z

The table is a width result tab on oracle in DWD level. ,4000W rows.

What's the max_execution_time in ClickHouse? And if you're using JDBC to access ClickHouse, what's the socket_timeout?

thank you very much .
I seted params max_exection_time 600

Answer 8 · 2022-03-15T06:34:57.000Z

It could run success. i will compare it to datax etl , thanks again.