Cant connect Oracle database
- 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
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
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