This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 2ae9bfa3b2 [typo](docs) add oracle jdbc catalog FAQ of orai18n.jar
(#22016)
2ae9bfa3b2 is described below
commit 2ae9bfa3b2f07dd08d1f1e6349e7d7c19435f87b
Author: zy-kkk <[email protected]>
AuthorDate: Thu Jul 20 14:10:58 2023 +0800
[typo](docs) add oracle jdbc catalog FAQ of orai18n.jar (#22016)
---
docs/en/docs/lakehouse/multi-catalog/jdbc.md | 6 +++++-
docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md | 6 +++++-
2 files changed, 10 insertions(+), 2 deletions(-)
diff --git a/docs/en/docs/lakehouse/multi-catalog/jdbc.md
b/docs/en/docs/lakehouse/multi-catalog/jdbc.md
index 7a1a73f9d7..a8fcc86505 100644
--- a/docs/en/docs/lakehouse/multi-catalog/jdbc.md
+++ b/docs/en/docs/lakehouse/multi-catalog/jdbc.md
@@ -695,4 +695,8 @@ When Doris connects to OceanBase, it will automatically
recognize that OceanBase
This happens because JDBC can't handle the datetime format 0000-00-00
00:00:00.
To address this, append zeroDateTimeBehavior=convertToNull to the jdbc_url
when creating the Catalog, e.g., "jdbc_url" =
"jdbc:mysql://127.0.0.1:3306/test?zeroDateTimeBehavior=convertToNull".
- In this case, JDBC will convert 0000-00-00 00:00:00 to null, and then
Doris will handle the DateTime column as a nullable type, allowing for
successful reading.
\ No newline at end of file
+ In this case, JDBC will convert 0000-00-00 00:00:00 to null, and then
Doris will handle the DateTime column as a nullable type, allowing for
successful reading.
+
+12. `Non supported character set (add orai18n.jar in your classpath):
ZHS16GBK` exception occurs when reading Oracle
+
+ Download
[orai18n.jar](https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html)
and put it in the lib directory of Doris FE and the lib/java_extensions
directory of BE (Doris versions before 2.0 need to be placed in the lib
directory of BE).
\ No newline at end of file
diff --git a/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
b/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
index 7f87668431..e2569bccde 100644
--- a/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
+++ b/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
@@ -690,4 +690,8 @@ CREATE CATALOG jdbc_oceanbase PROPERTIES (
这是因为 JDBC 并不能处理 0000-00-00 00:00:00 这种时间格式，
需要在创建 Catalog 的 `jdbc_url` 把JDBC连接串最后增加
`zeroDateTimeBehavior=convertToNull` ,如 `"jdbc_url" =
"jdbc:mysql://127.0.0.1:3306/test?zeroDateTimeBehavior=convertToNull"`
- 这种情况下，JDBC 会把 0000-00-00 00:00:00 转换成 null，然后 Doris 会把 DateTime
类型的列按照可空类型处理，这样就可以正常读取了。
\ No newline at end of file
+ 这种情况下，JDBC 会把 0000-00-00 00:00:00 转换成 null，然后 Doris 会把 DateTime
类型的列按照可空类型处理，这样就可以正常读取了。
+
+12. 读取 Oracle 出现 `Non supported character set (add orai18n.jar in your
classpath): ZHS16GBK` 异常
+
+ 下载
[orai18n.jar](https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html)
并放到 Doris FE 的 lib 目录以及 BE 的 lib/java_extensions 目录 (Doris 2.0 之前的版本需放到 BE 的
lib 目录下) 下即可。
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
