python-cx_Oracle

python-cx_Oracle copied to clipboard

using different ORA_TZFILE per connection

1

1. What versions are you using? - platform.platform: Linux-4.18.0-348.7.1.el8_5.x86_64-x86_64-with-centos-8.5.2111 - sys.maxsize > 2**32: True - platform.python_version: 3.6.8 - cx_Oracle.version: 8.3.0 - cx_Oracle.clientversion: (21, 6, 0, 0, 0) 2. Describe the...

mdobrzanski

cx_oracle library erring in databricks since this monday - DatabaseError: (cx_Oracle.DatabaseError) DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory". See https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for help

1

Hi, I have been using this library for very long in AWS databricks and it used to work without any issues, but since this Monday (7/25) I started to get...

aravindk777

New major cx_Oracle release has a new name and repo: python-oracledb

2

A new, major Python cx_Oracle driver release is available and comes with a brand new name: [python-oracledb](https://oracle.github.io/python-oracledb/). It is now a 'Thin' driver by default, with an optional 'Thick' mode...

cjbj

10 second delay when accessing an HighAvailabilty port 1539 environment...

5

1. What versions are you using? 8.3.0 3. Describe the problem t1 = perf_counter() dsn_tns = cx_Oracle.makedsn(config["MDMOWNER"]["SERVER"],config["MDMOWNER"]["PORT"],service_name=config["MDMOWNER"]["SID"]) cnx = cx_Oracle.connect(config["MDMOWNER"]["USER"],config["MDMOWNER"]["PASS"],dsn_tns) t2 = perf_counter() print(str(t2-t1)) the t2-t1 is about 10 seconds...

bostonareahuman

Fetch cursor rows as list of dict

6

Convert a cursor result set into a list of dictionary is a very common pattern, mainly when you are coding APIs that returns data as json. A list of dict...

rafaelreuber

User-defined exceptions as ProgrammingError

8

What kind of database errors are ProgrammingError? If you raise a user-defined exception through the procedure raise_application_error, the cx_Oracle raising an DatabaseError. I think is more clear use ProgrammingError for...

rafaelreuber

Is it possible to add deadlock exception as similarly there's IntegrityError? Then it's simple to catch it and retry the operation. try: ... except cx_Oracle.DeadlockError: ...

ancc

1. OracleDB version Oracle 11.2.1 2. Commands * print("sys.maxsize > 2**32:", sys.maxsize > 2**32) True * print("platform.platform:", platform.platform()) platform.platform: Linux-4.18.0-348.7.1.el8_5.x86_64-x86_64-with-glibc2.28 * print("platform.python_version:", platform.python_version()) platform.python_version: 3.9.6 * print("cx_Oracle.version:", cx_Oracle.version) cx_Oracle.version: 8.3.0...

robingie

Performance degradation in multi-threaded application on RHEL 8

12

1. What versions are you using? ``` DB: Oracle Database 12c Standard Edition Release 12.1.0.2.0 platform.platform: Linux-4.18.0-348.12.2.el8_5.x86_64-x86_64-with-glibc2.28 sys.maxsize > 2**32: True platform.python_version: 3.10.0 cx_Oracle.version: 8.3.0 cx_Oracle.clientversion: (18, 5, 0, 0,...

fv-mf

Failures with NCLOB text containing four byte Unicode emoji

19

Hi Anthony / Christopher - I've narrowed down at least one of the failures I'm having re: LOB to the NCLOB datatype, and it seems to be independent of whether...

zzzeek