This is an automated email from the ASF dual-hosted git repository.
morningman 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 d1db15e8f46 [opt](db2) add charset options (#2854)
d1db15e8f46 is described below
commit d1db15e8f4631b4c5057e6fc03f4385b80eb3a40
Author: Mingyu Chen (Rayner) <[email protected]>
AuthorDate: Mon Sep 8 18:27:03 2025 -0700
[opt](db2) add charset options (#2854)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
docs/lakehouse/catalogs/jdbc-ibmdb2-catalog.md | 6 +++++-
.../current/lakehouse/catalogs/jdbc-ibmdb2-catalog.md | 4 ++++
.../version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md | 4 ++++
.../version-3.0/lakehouse/catalogs/jdbc-ibmdb2-catalog.md | 4 ++++
.../version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md | 6 +++++-
.../version-3.0/lakehouse/catalogs/jdbc-ibmdb2-catalog.md | 6 +++++-
6 files changed, 27 insertions(+), 3 deletions(-)
diff --git a/docs/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
b/docs/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
index b1a5f86381c..4603b2a4a6d 100644
--- a/docs/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
+++ b/docs/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
@@ -73,4 +73,8 @@ When mapping IBM Db2, Doris's Database corresponds to a
Schema under the specifi
1. When reading IBM Db2 data through JDBC Catalog, an `Invalid operation:
result set is closed. ERRORCODE=-4470` exception occurs.
- Add connection parameters to the jdbc\_url connection string when creating
the IBM Db2 Catalog: `allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`.
For example:
`jdbc:db2://host:port/database:allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`.
\ No newline at end of file
+ Add connection parameters to the jdbc\_url connection string when creating
the IBM Db2 Catalog: `allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`.
For example:
`jdbc:db2://host:port/database:allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`.
+
+2. Caught java.io.CharConversionException
+
+ This issue may be caused by a character set problem. You can try adding
the configuration `-Ddb2.jcc.charsetDecoderEncoder=3` to the `JAVA_OPTS` in
`be.conf`, then restart the BE to see if it resolves the issue. You may also
experiment with values such as `1` or `2`. For more details, please refer to:
https://www.ibm.com/docs/en/content-collector/4.0.1?topic=manager-jdbc-throws-javaiocharconversionexception
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
index da235aed6ed..a15469f1bb7 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
@@ -74,3 +74,7 @@ CREATE CATALOG db2_catalog PROPERTIES (
1. 通过 JDBC Catalog 读取 IBM Db2 数据时出现 `Invalid operation: result set is closed.
ERRORCODE=-4470` 异常
在创建 IBM Db2 Catalog 的 jdbc\_url
连接串中添加连接参数：`allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`。如：
`jdbc:db2://host:port/database:allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`。
+
+2. Caught java.io.CharConversionException
+
+ 这可能是因为字符集问题，可以在 `be.conf` 的 `JAVA_OPTS` 添加配置
`-Ddb2.jcc.charsetDecoderEncoder=3`，并重启 BE 尝试解决，可以尝试 `1`、`2`
等不同取值。具体可参阅：https://www.ibm.com/docs/en/content-collector/4.0.1?topic=manager-jdbc-throws-javaiocharconversionexception
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
index da235aed6ed..a15469f1bb7 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
@@ -74,3 +74,7 @@ CREATE CATALOG db2_catalog PROPERTIES (
1. 通过 JDBC Catalog 读取 IBM Db2 数据时出现 `Invalid operation: result set is closed.
ERRORCODE=-4470` 异常
在创建 IBM Db2 Catalog 的 jdbc\_url
连接串中添加连接参数：`allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`。如：
`jdbc:db2://host:port/database:allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`。
+
+2. Caught java.io.CharConversionException
+
+ 这可能是因为字符集问题，可以在 `be.conf` 的 `JAVA_OPTS` 添加配置
`-Ddb2.jcc.charsetDecoderEncoder=3`，并重启 BE 尝试解决，可以尝试 `1`、`2`
等不同取值。具体可参阅：https://www.ibm.com/docs/en/content-collector/4.0.1?topic=manager-jdbc-throws-javaiocharconversionexception
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
index da235aed6ed..a15469f1bb7 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
@@ -74,3 +74,7 @@ CREATE CATALOG db2_catalog PROPERTIES (
1. 通过 JDBC Catalog 读取 IBM Db2 数据时出现 `Invalid operation: result set is closed.
ERRORCODE=-4470` 异常
在创建 IBM Db2 Catalog 的 jdbc\_url
连接串中添加连接参数：`allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`。如：
`jdbc:db2://host:port/database:allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`。
+
+2. Caught java.io.CharConversionException
+
+ 这可能是因为字符集问题，可以在 `be.conf` 的 `JAVA_OPTS` 添加配置
`-Ddb2.jcc.charsetDecoderEncoder=3`，并重启 BE 尝试解决，可以尝试 `1`、`2`
等不同取值。具体可参阅：https://www.ibm.com/docs/en/content-collector/4.0.1?topic=manager-jdbc-throws-javaiocharconversionexception
diff --git
a/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
b/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
index b1a5f86381c..4603b2a4a6d 100644
--- a/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
+++ b/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
@@ -73,4 +73,8 @@ When mapping IBM Db2, Doris's Database corresponds to a
Schema under the specifi
1. When reading IBM Db2 data through JDBC Catalog, an `Invalid operation:
result set is closed. ERRORCODE=-4470` exception occurs.
- Add connection parameters to the jdbc\_url connection string when creating
the IBM Db2 Catalog: `allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`.
For example:
`jdbc:db2://host:port/database:allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`.
\ No newline at end of file
+ Add connection parameters to the jdbc\_url connection string when creating
the IBM Db2 Catalog: `allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`.
For example:
`jdbc:db2://host:port/database:allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`.
+
+2. Caught java.io.CharConversionException
+
+ This issue may be caused by a character set problem. You can try adding
the configuration `-Ddb2.jcc.charsetDecoderEncoder=3` to the `JAVA_OPTS` in
`be.conf`, then restart the BE to see if it resolves the issue. You may also
experiment with values such as `1` or `2`. For more details, please refer to:
https://www.ibm.com/docs/en/content-collector/4.0.1?topic=manager-jdbc-throws-javaiocharconversionexception
diff --git
a/versioned_docs/version-3.0/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
b/versioned_docs/version-3.0/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
index b1a5f86381c..4603b2a4a6d 100644
--- a/versioned_docs/version-3.0/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
+++ b/versioned_docs/version-3.0/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
@@ -73,4 +73,8 @@ When mapping IBM Db2, Doris's Database corresponds to a
Schema under the specifi
1. When reading IBM Db2 data through JDBC Catalog, an `Invalid operation:
result set is closed. ERRORCODE=-4470` exception occurs.
- Add connection parameters to the jdbc\_url connection string when creating
the IBM Db2 Catalog: `allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`.
For example:
`jdbc:db2://host:port/database:allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`.
\ No newline at end of file
+ Add connection parameters to the jdbc\_url connection string when creating
the IBM Db2 Catalog: `allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`.
For example:
`jdbc:db2://host:port/database:allowNextOnExhaustedResultSet=1;resultSetHoldability=1;`.
+
+2. Caught java.io.CharConversionException
+
+ This issue may be caused by a character set problem. You can try adding
the configuration `-Ddb2.jcc.charsetDecoderEncoder=3` to the `JAVA_OPTS` in
`be.conf`, then restart the BE to see if it resolves the issue. You may also
experiment with values such as `1` or `2`. For more details, please refer to:
https://www.ibm.com/docs/en/content-collector/4.0.1?topic=manager-jdbc-throws-javaiocharconversionexception
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
