All geek questions in one place

Python driver for Oracle 12c

I read the Oracle 12c Application Development Documentation and noted with concern that Python support is only mentioned in the future tense:

Scripting languages ​​will also [...] benefit from these community features that support this code and do integration work.

Has anyone managed to get Python (especially in Ubuntu) that works great with Oracle 12c database? If so, which drivers did you use?

+4
source share
1 answer

It looks like you can still use the older odbc libraries with Oracle 12. The Oracle Services Reference mentions the SQLNET.ALLOWED_LOGON_VERSION_SERVER and SQLNET.ALLOWED_LOGON_VERSION_CLIENT parameters, which determine the minimum allowable versions allowed to connect to and from the database. Both defaults to 11, which is equivalent to Oracle Database 11g authentication protocols. Therefore, any driver for Oracle 11g clients must still work with the Oracle 12c database.

I tested this with the Java client using the ojdbc6.jar library to connect 11g to my Oracle 12c database and version 5.1.2 cx_Oracle for Python.

+2
source

Source: https://habr.com/ru/post/1493565/

More articles:


All Articles