[Django] #22368: db settings does not support SERVICE_NAME
Django
-------------------------------------+-------------------------------------
Reporter: michael.cherkasov@… | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: 1.6
(models, ORM) | Keywords: oracle, database, db
Severity: Normal | config
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
I need to connect to oracle db, but I don't have SID of db, I know only
SERVICE_NAME - that is used all the time in other tools.
To connect to db I need a dsn like this one:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host-name.com)(PORT=1523))\
(CONNECT_DATA=(SERVICE_NAME=some-service-name.com)))
but django generate the following:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host-
name.com)(PORT=1523)))(CONNECT_DATA=(SID=some-service-name.com)))
the possible fix is described here:
http://stackoverflow.com/questions/19246643/how-do-i-force-django-to-
connect-to-oracle-using-service-name
--
Ticket URL: <https://code.djangoproject.com/ticket/22368>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
Django
-------------------------------------+-------------------------------------
Reporter: michael.cherkasov@… | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: 1.6
Severity: Normal | Triage Stage:
Keywords: oracle, database, | Unreviewed
db config | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------
Changes (by timo):
* needs_better_patch: => 0
* needs_tests: => 0
* needs_docs: => 0
Comment:
Does http://stackoverflow.com/a/20486810 not work?
--
Ticket URL: <https://code.djangoproject.com/ticket/22368#comment:1>
Django
-------------------------------------+-------------------------------------
Reporter: michael.cherkasov@… | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: 1.6
Severity: Normal | Triage Stage:
Keywords: oracle, database, | Unreviewed
db config | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------
Comment (by anonymous):
Replying to [comment:1 timo]:
> Does http://stackoverflow.com/a/20486810 not work?
it works fine, I think this should be added to docs.
--
Ticket URL: <https://code.djangoproject.com/ticket/22368#comment:2>
Django
-------------------------------------+-------------------------------------
Reporter: michael.cherkasov@… | Owner: nobody
Type: New feature | Status: new
Severity: Normal | Resolution:
Keywords: oracle, database, | Triage Stage: Accepted
db config | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------
* component: Database layer (models, ORM) => Documentation
* stage: Unreviewed => Accepted
--
Ticket URL: <https://code.djangoproject.com/ticket/22368#comment:3>
Django
-------------------------------------+-------------------------------------
Type: New feature | Status: assigned
Component: Documentation | Version: 1.6
Severity: Normal | Resolution:
Keywords: oracle, database, | Triage Stage: Accepted
db config | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------
* owner: nobody => mardini
* status: new => assigned
--
Ticket URL: <https://code.djangoproject.com/ticket/22368#comment:4>
Django
-------------------------------------+-------------------------------------
Reporter: michael.cherkasov@… | Owner: mardini
Type: New feature | Status: assigned
Component: Documentation | Version: 1.6
Severity: Normal | Resolution:
Keywords: oracle, database, | Triage Stage: Accepted
db config | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------
Comment (by mardini):
PR: https://github.com/django/django/pull/2683
Thanks.
--
Ticket URL: <https://code.djangoproject.com/ticket/22368#comment:5>
Django
-------------------------------------+-------------------------------------
Reporter: michael.cherkasov@… | Owner: mardini
Component: Documentation | Version: 1.6
Severity: Normal | Resolution: fixed
Keywords: oracle, database, | Triage Stage: Accepted
db config | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------
* status: assigned => closed
* resolution: => fixed
Comment:
In [changeset:"bfac6bef833d2520853c88188560b81bc7e3988d"]:
{{{
#!CommitTicketReference repository=""
revision="bfac6bef833d2520853c88188560b81bc7e3988d"
Fixed #22368 -- clarified connecting to Oracle DB using service name
Used the official terminology listed in
http://docs.oracle.com/cd/B19306_01/network.102/b14212/glossary.htm#i997309
Thanks michael.cherkasov for the report.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/22368#comment:6>
Django
-------------------------------------+-------------------------------------
Reporter: michael.cherkasov@… | Owner: mardini
Type: New feature | Status: closed
Component: Documentation | Version: 1.6
Severity: Normal | Resolution: fixed
Keywords: oracle, database, | Triage Stage: Accepted
db config | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------
Comment (by Tim Graham <timograham@…>):
In [changeset:"4dd37a3a6eb744a9901eb53454a86bf304a71426"]:
{{{
#!CommitTicketReference repository=""
revision="4dd37a3a6eb744a9901eb53454a86bf304a71426"
[1.7.x] Fixed #22368 -- clarified connecting to Oracle DB using service
name
Used the official terminology listed in
http://docs.oracle.com/cd/B19306_01/network.102/b14212/glossary.htm#i997309
Thanks michael.cherkasov for the report.
Backport of bfac6bef83 from master
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/22368#comment:7>
Django
-------------------------------------+-------------------------------------
Reporter: michael.cherkasov@… | Owner: mardini
Type: New feature | Status: closed
Component: Documentation | Version: 1.6
Severity: Normal | Resolution: fixed
Keywords: oracle, database, | Triage Stage: Accepted
db config | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------
Comment (by Tim Graham <timograham@…>):
In [changeset:"26221445df5855d189b2dc4dd76ff0a9f0bd77d0"]:
{{{
#!CommitTicketReference repository=""
revision="26221445df5855d189b2dc4dd76ff0a9f0bd77d0"
[1.6.x] Fixed #22368 -- clarified connecting to Oracle DB using service
name
Used the official terminology listed in
http://docs.oracle.com/cd/B19306_01/network.102/b14212/glossary.htm#i997309
Thanks michael.cherkasov for the report.
Backport of bfac6bef83 from master
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/22368#comment:8>