This is an automated email from the ASF dual-hosted git repository.
zykkk pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 7355f368058 [doc] add db2 catalog faq (#593)
7355f368058 is described below
commit 7355f3680589462b8ce73acb69f81d8d7453a4a2
Author: Petrichor <[email protected]>
AuthorDate: Fri Apr 26 16:37:07 2024 +0800
[doc] add db2 catalog faq (#593)
---
docs/lakehouse/multi-catalog/jdbc.md | 5 +++++
.../current/lakehouse/multi-catalog/jdbc.md | 5 +++++
.../version-2.1/lakehouse/multi-catalog/jdbc.md | 6 ++++++
versioned_docs/version-2.1/lakehouse/multi-catalog/jdbc.md | 5 +++++
4 files changed, 21 insertions(+)
diff --git a/docs/lakehouse/multi-catalog/jdbc.md
b/docs/lakehouse/multi-catalog/jdbc.md
index b7a94a16695..ff0eb0e0190 100644
--- a/docs/lakehouse/multi-catalog/jdbc.md
+++ b/docs/lakehouse/multi-catalog/jdbc.md
@@ -1069,3 +1069,8 @@ It is recommended to use the following versions of Driver
to connect to the corr
Starting from version 2.0.2, this file can be placed in the `custom_lib/`
directory of FE and BE (if it does not exist, just create it manually) to
prevent the file from being lost due to the replacement of the lib directory
when upgrading the cluster.
11. If there is a prolonged delay or no response when querying MySQL through
JDBC catalog, or if it hangs for an extended period and a significant number of
"write lock" logs appear in the fe.warn.log, consider adding a socketTimeout
parameter to the URL. For example:
`jdbc:mysql://host:port/database?socketTimeout=30000`. This prevents the JDBC
client from waiting indefinitely after MySQL closes the connection.
+
+12. When reading DB2 data via JDBC Catalog, an exception `Invalid operation:
result set is closed. ERRORCODE=-4470` occurs
+
+ Firstly, delete the existing Catalog. Then, restart the BE (Backend). When
creating a new DB2 Catalog, make sure to add the following parameters to the
JDBC URL connection string:
+ `allowNextOnExhaustedResultSet=1;resultSetHoldability=1`. For example:
`jdbc:db2://ip:host/db:allowNextOnExhaustedResultSet=1;resultSetHoldability=1`.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/multi-catalog/jdbc.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/multi-catalog/jdbc.md
index 4153ad9cdf4..358da4006e3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/multi-catalog/jdbc.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/multi-catalog/jdbc.md
@@ -1072,3 +1072,8 @@ CREATE CATALOG `jdbc_db2` PROPERTIES (
11. 如果通过 Jdbc catalog 查询 MySQL 的时候，出现长时间卡住没有返回结果，或着卡住很长时间并且 fe.warn.log
中出现出现大量 write lock 日志，可以尝试在 url 添加 socketTimeout
，例如：`jdbc:mysql://host:port/database?socketTimeout=30000` ， 防止 MySQL 在关闭连接后
Jdbc 客户端无限等待。
+12. 通过 JDBC Catalog 读取 DB2 数据时出现 `Invalid operation: result set is closed.
ERRORCODE=-4470` 异常
+
+ 首先，删除现有的 Catalog。接着，重新启动 BE（Backend）。在创建新的 DB2 Catalog 时，需要在 JDBC URL
连接字符串中添加以下参数：`allowNextOnExhaustedResultSet=1;resultSetHoldability=1`。如：
+
`jdbc:db2://ip:host/db:allowNextOnExhaustedResultSet=1;resultSetHoldability=1`。
+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/multi-catalog/jdbc.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/multi-catalog/jdbc.md
index 027629ec4b6..98988fa788e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/multi-catalog/jdbc.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/multi-catalog/jdbc.md
@@ -1072,3 +1072,9 @@ CREATE CATALOG `jdbc_db2` PROPERTIES (
11. 如果通过 Jdbc catalog 查询 MySQL 的时候，出现长时间卡住没有返回结果，或着卡住很长时间并且 fe.warn.log
中出现出现大量 write lock 日志，可以尝试在 url 添加 socketTimeout
，例如：`jdbc:mysql://host:port/database?socketTimeout=30000` ， 防止 MySQL 在关闭连接后
Jdbc 客户端无限等待。
+12. 通过 JDBC Catalog 读取 DB2 数据时出现 `Invalid operation: result set is closed.
ERRORCODE=-4470` 异常
+
+ 首先，删除现有的 Catalog。接着，重新启动 BE（Backend）。在创建新的 DB2 Catalog 时，需要在 JDBC URL
连接字符串中添加以下参数：`allowNextOnExhaustedResultSet=1;resultSetHoldability=1`。如：
+
`jdbc:db2://ip:host/db:allowNextOnExhaustedResultSet=1;resultSetHoldability=1`。
+
+
diff --git a/versioned_docs/version-2.1/lakehouse/multi-catalog/jdbc.md
b/versioned_docs/version-2.1/lakehouse/multi-catalog/jdbc.md
index a50c7149cdb..093de7c71c7 100644
--- a/versioned_docs/version-2.1/lakehouse/multi-catalog/jdbc.md
+++ b/versioned_docs/version-2.1/lakehouse/multi-catalog/jdbc.md
@@ -1067,3 +1067,8 @@ It is recommended to use the following versions of Driver
to connect to the corr
Starting from version 2.0.2, this file can be placed in the `custom_lib/`
directory of FE and BE (if it does not exist, just create it manually) to
prevent the file from being lost due to the replacement of the lib directory
when upgrading the cluster.
11. If there is a prolonged delay or no response when querying MySQL through
JDBC catalog, or if it hangs for an extended period and a significant number of
"write lock" logs appear in the fe.warn.log, consider adding a socketTimeout
parameter to the URL. For example:
`jdbc:mysql://host:port/database?socketTimeout=30000`. This prevents the JDBC
client from waiting indefinitely after MySQL closes the connection.
+
+12. When reading DB2 data via JDBC Catalog, an exception Invalid operation:
`result set is closed. ERRORCODE=-4470` occurs
+
+ Firstly, delete the existing Catalog. Then, restart the BE (Backend). When
creating a new DB2 Catalog, make sure to add the following parameters to the
JDBC URL connection string:
+ `allowNextOnExhaustedResultSet=1;resultSetHoldability=1`. For example:
`jdbc:db2://ip:host/db:allowNextOnExhaustedResultSet=1;resultSetHoldability=1`.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
