[Django] #29541: Add support for cx_Oracle 6.4

[Django]

#29541: Add support for cx_Oracle 6.4
-------------------------------------+-------------------------------------
Reporter: felixxm | Owner: felixxm
Type: Bug | Status: assigned
Component: Database | Version: 2.0
layer (models, ORM) |
Severity: Normal | Keywords: Oracle cx_Oracle
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Django crashes with cx_Oracle 6.4. e.g. stack trace:

{{{
File "/home/jenkins/workspace/django-
oracle-2.0/database/oracle12/label/bionic/python/python3.4/django/db/backends/utils.py",
line 85, in _execute
return self.cursor.execute(sql, params)
File "/home/jenkins/workspace/django-
oracle-2.0/database/oracle12/label/bionic/python/python3.4/django/db/backends/oracle/base.py",
line 500, in execute
return self.cursor.execute(query, self._param_generator(params))
cx_Oracle.ProgrammingError: positional and named binds cannot be
intermixed
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/29541>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#29541: Add support for cx_Oracle 6.4
-------------------------------------+-------------------------------------
Reporter: felixxm | Owner: felixxm
Type: Bug | Status: assigned

Component: Database layer | Version: 2.0
(models, ORM) |
Severity: Normal | Resolution:
Keywords: Oracle cx_Oracle | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Tim Graham):

* stage: Unreviewed => Accepted

--
Ticket URL: <https://code.djangoproject.com/ticket/29541#comment:1>

[Django]

#29541: Add support for cx_Oracle 6.4
-------------------------------------+-------------------------------------
Reporter: felixxm | Owner: felixxm
Type: Bug | Status: assigned

Component: Database layer | Version: 2.0
(models, ORM) |
Severity: Normal | Resolution:

Keywords: Oracle cx_Oracle | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by felixxm):

* has_patch: 0 => 1

Comment:

[https://github.com/django/django/pull/10129 PR]

--
Ticket URL: <https://code.djangoproject.com/ticket/29541#comment:2>

[Django]

#29541: Add support for cx_Oracle 6.4
-------------------------------------+-------------------------------------
Reporter: felixxm | Owner: felixxm
Type: Bug | Status: assigned

Component: Database layer | Version: 1.11

(models, ORM) |
Severity: Normal | Resolution:

Keywords: Oracle cx_Oracle | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by felixxm):

* version: 2.0 => 1.11

Comment:

Fix is quite simple, therefore IMO we can backport it to the 1.11. Simple
release notes like `"Added support for cx_Oracle 6.4 (:ticket:29541)."`
should be enough.

--
Ticket URL: <https://code.djangoproject.com/ticket/29541#comment:3>

[Django]

#29541: Add support for cx_Oracle 6.4
-------------------------------------+-------------------------------------
Reporter: felixxm | Owner: felixxm
Type: Bug | Status: assigned

Component: Database layer | Version: 1.11
(models, ORM) |
Severity: Normal | Resolution:

Keywords: Oracle cx_Oracle | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by felixxm):

Anthony fixed this issue in the https://github.com/oracle/python-
cx_Oracle/commit/fee92abe5a6a0937e4789d251dc50825cb434113, so it should be
fixed in the next `cx_Oracle` version (6.4.1 ). I'm not sure if we will
backport this fix to 2.0.x or 1.11.x.

--
Ticket URL: <https://code.djangoproject.com/ticket/29541#comment:4>

[Django]

#29541: Add support for cx_Oracle 6.4
-------------------------------------+-------------------------------------
Reporter: felixxm | Owner: felixxm

Type: Bug | Status: closed

Component: Database layer | Version: 1.11
(models, ORM) |

Severity: Normal | Resolution: fixed
Keywords: Oracle cx_Oracle | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Tim Graham <timograham@…>):

* status: assigned => closed
* resolution: => fixed

Comment:

In [changeset:"d7d32964ef7b0951ecfd8565af2351ebfe1ea02b" d7d3296]:
{{{
#!CommitTicketReference repository=""
revision="d7d32964ef7b0951ecfd8565af2351ebfe1ea02b"
Fixed #29541 -- Fixed Cursor.execute() crash when setinputsizes() is
called without arguments wit cx_Oracle 6.4.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/29541#comment:5>