Bug: OceanBase can't get database and tables

CodePhiliaX / Chat2DB

🔥🔥🔥AI-driven database tool and SQL client, The hottest GUI client, supporting MySQL, Oracle, PostgreSQL, DB2, SQL Server, DB2, SQLite, H2, ClickHouse, and more.

http://chat2db.ai

Apache License 2.0

17k stars 1.91k forks source link

Bug: OceanBase can't get database and tables #1560

Open Daose1997 opened 2 weeks ago

Daose1997 commented 2 weeks ago

Chat2DB Version

3.4.1

Describe the bug

When I use chat2DB to connect to my OceanBase database, I am unable to retrieve the database and tables within the connection. The driver used is the version set by chat2DB. Could this be related to my OceanBase database? 微信截图_20241108101410

dengfuping commented 2 weeks ago

It works for me when connecting to OceanBase Cloud (V4.3.3) with Chat2DB:

Daose1997 commented 2 weeks ago

It works for me when connecting to OceanBase Cloud (V4.3.3) with Chat2DB:

it's my OceanBase version 微信截图_20241108133931

dengfuping commented 2 weeks ago

@Daose1997 OceanBase v3.2.3.3 works fine with Chat2DB Local Version v1.2.0. Try to upgrade your Chat2DB version in https://chat2db-ai.com/download.

Daose1997 commented 2 weeks ago

@Daose1997 OceanBase v3.2.3.3 works fine with Chat2DB Local Version v1.2.0. Try to upgrade your Chat2DB version in https://chat2db-ai.com/download.

Thank you very much, using OceanBase Oracle in Chat2DB Local allows me to retrieve the library table information in my database normally, I think it should be due to the OceanBase mode.

dengfuping commented 2 weeks ago

@Daose1997 My OceanBase mode is MySQL and everything is ok. I think Chat2DB version is the root cause, because your Chat2DB is a fairly old version obviously.

Daose1997 commented 2 weeks ago

@dengfuping I don't think so. My Chat2DB is the latest version 3.4.1 from https://github.com/CodePhiliaX/Chat2DB/releases. In the separate application Chat2DB Local， OceanBase is distinguished as OceanBase and OceanBase Oracle, but in the Chat2DB application, there is no such distinction.

tmlx1990 commented 1 week ago

@dengfuping I don't think so. My Chat2DB is the latest version 3.4.1 from https://github.com/CodePhiliaX/Chat2DB/releases. In the separate application Chat2DB Local， OceanBase is distinguished as OceanBase and OceanBase Oracle, but in the Chat2DB application, there is no such distinction.

Hello, the open source version does not support OceanBase Oracle at present. The Pro version or local version can support it.