langgenius / langgenius/dify

Cant connect Oracle database

Open
#41,909 3 comments 1 reaction 0 assignees View on GitHub
🐞 bug
Dominant language
TypeScript
Stars
156k
Forks
24.6k
Avg merge
22h 9m
Merged PRs (30d)
610

Description

### Self Checks

- [x] I have read the [Contributing Guide](https://github.com/langgenius/dify/blob/main/CONTRIBUTING.md) and [Language Policy](https://github.com/langgenius/dify/issues/1542).
- [x] This is only for bug report, if you would like to ask a question, please head to [Discussions](https://github.com/langgenius/dify/discussions/categories/general).
- [x] I have searched for existing issues [search for existing issues](https://github.com/langgenius/dify/issues), including closed ones.
- [x] I confirm that I am using English to submit this report, otherwise it will be closed.
- [x] 【中文用户 & Non English User】请使用英语提交,否则会被关闭 :)
- [x] Please do not modify this template :) and fill in all the required fields.

### Dify version

v1.17.0

### Cloud or Self Hosted

Self Hosted (Docker)

### Steps to reproduce

Image
The junjiem/db_query plugin fails to connect to Oracle 11g databases. The underlying python-oracledb driver defaults to "Thin mode," which does not support older Oracle server versions (like 11g), resulting in a DPY-3010 error.

### ✔️ Expected Behavior

I expect the plugin to successfully connect to Oracle 11g databases without throwing a DPY-3010 error.
Specifically, the plugin should support the "Thick mode" of python-oracledb (by calling oracledb.init_oracle_client()), or provide a configuration option to enable it. This is necessary because Oracle 11g is not supported in the default "Thin mode"

### ❌ Actual Behavior

_No response_

Contributor guide

Open the contributing guide

Research direction

Start by locating the junjiem/db_query plugin and its python-oracledb connection setup, then reproduce the DPY-3010 failure against an Oracle 11g database. Check how oracledb.init_oracle_client() or a configuration option could be supported; done means the plugin connects successfully to Oracle 11g without the error.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
55/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.