search

oracle / python-oracledb

Python driver for Oracle Database conforming to the Python DB API 2.0 specification. This is the renamed, new major release of cx_Oracle
https://oracle.github.io/python-oracledb
Other
328 stars 66 forks source link

SOCKS proxy support for Thin Mode #253

Open henzef opened 11 months ago

henzef commented 11 months ago

I am currently using the Oracle JDBC driver via JayDeBeApi to connect to an oracle database, which is far from ideal. Unfortunately I have to make this connection via a SOCKS proxy for reasons outside of my control. As I would like to port my application to python-oracledb, I am wondering if SOCKS proxy support is planned in the near or distant future?

anthony-tuininga commented 10 months ago

There aren't any current plans but it is on our list of enhancements. It would help if you can provide a bit more detail on what you think SOCKS proxy support might look like. Would it be as simple as adding an additional set of parameters: socks_proxy_host and socks_proxy_port? Or is the SOCKS proxy protocol important as well?

Have you tried monkeypatching as suggested by the PySocks documentation? Although not a good long-term solution it gives some indication of how much effort would be involved in adding this support.