Re: Django and Oracle 10g

2017-10-08 Thread Jani Tiainen
Hi. There is nothing special with Oracle. Once you have cx_Oracle installed just setting proper django backend and connection params. Note oracle 10g had been out of support for good while and it's not officually supported any more in recent Django versions. Also 11g is going out of support soon

Re: Django and Oracle 10g

2017-10-07 Thread Constantine Covtushenko
Hi Paulo, Did you read https://docs.djangoproject.com/en/1.11/ref/databases/#oracle-notes? I did not use oracle backend in any of my projects. But with Django ORM one will never depend on DB type in common scenarios. I hope that helps. Regards, Constantine C. On Sat, Oct 7, 2017 at 8:51 PM,

Django and Oracle 10g

2017-10-07 Thread paulo . sovienski
I'm new Here. I'm know Java and C#. I know php with laravel framework. But in Python I'm starting. I need to connect Python with my oracle 10g database, and with the cx_Oracle driver everything worked out. But I do not know how to use this cx_Oracle driver in Django's frameWork. Would someone

How to config Django for Oracle RAC mode

2017-05-21 Thread hu huaxuan
such connection. Anyone has experience to config Oracle RAC for Django? Below is our old config which currently works well on non-RAC mode as a reference: DATABASES = { 'default': { 'ENGINE': 'django.db.backends.oracle', 'NAME': 'devdb', 'USER': 'devuser', 'HOST

Re: django and oracle

2014-05-16 Thread Jani Tiainen
On Thu, 15 May 2014 00:07:47 -0700 (PDT) "J. D." <john.arnold.dav...@gmail.com> wrote: > > On Wednesday, 14 May 2014 21:08:11 UTC+4, Avraham Serour wrote: > > > > it looks like your error occurs when using django ORM with oracle, but in > > the beginning

Re: django and oracle

2014-05-15 Thread J. D.
On Wednesday, 14 May 2014 21:08:11 UTC+4, Avraham Serour wrote: > > it looks like your error occurs when using django ORM with oracle, but in > the beginning of your email you mention that you don't want to use it, so > what's the problem here? > > I want to reuse esta

Re: django and oracle

2014-05-14 Thread Jani Tiainen
On Thu, 15 May 2014 07:02:08 +0300 Jani Tiainen <rede...@gmail.com> wrote: > On Wed, 14 May 2014 07:54:58 -0700 (PDT) > "J. D." <john.arnold.dav...@gmail.com> wrote: > > > Can someone help me with cx_Oracle and Django?! :) > > > >

Re: django and oracle

2014-05-14 Thread Jani Tiainen
On Wed, 14 May 2014 07:54:58 -0700 (PDT) "J. D." <john.arnold.dav...@gmail.com> wrote: > Can someone help me with cx_Oracle and Django?! :) > > I have Oracle DB 11.2 with many PLSQL-procedures in it that return cursor > with various output. I want to work

Re: django and oracle

2014-05-14 Thread Avraham Serour
it looks like your error occurs when using django ORM with oracle, but in the beginning of your email you mention that you don't want to use it, so what's the problem here? On Wed, May 14, 2014 at 5:54 PM, J. D. <john.arnold.dav...@gmail.com> wrote: > Can someone help me with

django and oracle

2014-05-14 Thread J. D.
Can someone help me with cx_Oracle and Django?! :) I have Oracle DB 11.2 with many PLSQL-procedures in it that return cursor with various output. I want to work with them without django ORM and directly call them. First of all i ran my python code without django, with the cx_Oracle driver

Query executed two times in database (django 1.4, oracle 11g)

2013-09-08 Thread Germán
I'm not familiar with caching internals but perhaps the fact that you are using `raw` has something to do with your problem? -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send

Query executed two times in database (django 1.4, oracle 11g)

2013-09-06 Thread bikeridercz
Dear colleagues, I'm facing a problem probably related to caching infrastructure in DJango. Documentation says that data are fetched from DB once a then readed from cache. However, my results are different. Query is executed two times. On my opinion the first fetch should be enough. Here is

Re: django and oracle --

2012-05-01 Thread Giovanni Bronzini
Simple one you are missing * item* just before *['prezzo']* :-) On 28 April 2012 18:30, gmail <marco.giard...@gmail.com> wrote: > hello django boys, > > i hope someone here can help me. i have a problem with django e oracle. > above the code with problem: >

django and oracle --

2012-04-28 Thread gmail
hello django boys, i hope someone here can help me. i have a problem with django e oracle. above the code with problem: insert = """insert into modello (title, descrizione, url, prezzo, sconto) values (:title, :descrizione, :url,

Re: Django and Oracle XE - Empty models file

2011-01-28 Thread Jani Tiainen
On Friday 28 January 2011 11:45:48 Nathan wrote: > Cheers for the reply. The database in question is a remote database. I > presume by Django user that you're referring to the local user account? > Otherwise the user credentials in settings should be adequate. > > I'm guessing the only resolution

Re: Django and Oracle XE - Empty models file

2011-01-28 Thread Nathan
Cheers for the reply. The database in question is a remote database. I presume by Django user that you're referring to the local user account? Otherwise the user credentials in settings should be adequate. I'm guessing the only resolution to this is to hand craft the models? -- You received

Re: Django and Oracle XE - Empty models file

2011-01-27 Thread Ian
On Jan 27, 3:53 am, Nathanael Dyke wrote: > I've only recently started playing with Django to undertake a technology > assessment of the various frameworks available. As part of the assessment it > needs to integrate with a legacy Oracle XE database (I know) which will >

Django and Oracle XE - Empty models file

2011-01-27 Thread Nathanael Dyke
I've only recently started playing with Django to undertake a technology assessment of the various frameworks available. As part of the assessment it needs to integrate with a legacy Oracle XE database (I know) which will contain customer data, with the default database being MySQL and

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

2010-12-02 Thread Ian Kelly
On Thu, Dec 2, 2010 at 5:52 PM, Anurag Chourasia wrote: > Hi Ian, > Can't tell you how much this helps :-) > Setting the variable using ctypes before the import of cx_Oracle does the > trick for me. > Appreciate the time you spent in helping resolve this. > Is there

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

2010-12-02 Thread Anurag Chourasia
me. > > In your transcript, it appears that Django has already been loaded > when you call the ctypes code. The environment variable needs to be > set *before* cx_Oracle is imported by Django, or it won't have any > effect. This is why I suggested patching it into the >

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

2010-12-02 Thread Ian Kelly
call the ctypes code. The environment variable needs to be set *before* cx_Oracle is imported by Django, or it won't have any effect. This is why I suggested patching it into the django/db/backends/oracle/base.py file. Cheers, Ian -- You received this message because you are subscribed to th

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

2010-12-02 Thread Anurag Chourasia
esult = iter((lambda: cursor.fetchmany(GET_ITERATOR_CHUNK_SIZE)), File "/usr/lib/python2.5/site-packages/django/db/backends/oracle/base.py", line 552, in fetchmany for r in self.cursor.fetchmany(size)]) File "/usr/lib/python2.5/site-packages/django/db/backends/oracle/base.py"

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

2010-12-02 Thread Ian Kelly
8') I've tried it, and it works. I suggest patching the above into your django/db/backends/oracle/base.py file, in place of the line: os.environ['NLS_LANG'] = '.UTF8' Cheers, Ian -- You received this message because you are subscribed to the Google Groups "Django users" group.

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

2010-12-02 Thread Ian Kelly
On Thu, Dec 2, 2010 at 1:21 PM, Anurag Chourasia wrote: > Hi Ian, > Here is the information requested by you. > $ python > Python 2.5.2 (r252:60911, Dec  2 2008, 09:26:14) > [GCC 3.4.4 (cygming special, gdc 0.12, using dmd 0.125)] on cygwin > Type "help", "copyright",

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

2010-12-02 Thread Anurag Chourasia
Hi Ian, Here is the information requested by you. $ python Python 2.5.2 (r252:60911, Dec 2 2008, 09:26:14) [GCC 3.4.4 (cygming special, gdc 0.12, using dmd 0.125)] on cygwin Type "help", "copyright", "credits" or "license" for more information. >>> import os >>> print os.environ['NLS_LANG']

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

2010-12-02 Thread Ian Kelly
On Thu, Dec 2, 2010 at 6:43 AM, Anurag Chourasia wrote: > Hi Ian, > Yes.I set the NLS_LANG in my shell to UTF8 before trying this. > Query using Django model still fails (direct query using cx_Oracle works > fine) > Regards, > Anurag Okay, so it would appear that

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

2010-12-02 Thread Anurag Chourasia
Hi Ian, Yes.I set the NLS_LANG in my shell to UTF8 before trying this. Query using Django model still fails (direct query using cx_Oracle works fine) Regards, Anurag On Thu, Dec 2, 2010 at 1:20 PM, Ian Kelly wrote: > On Wed, Dec 1, 2010 at 7:58 PM, Anurag Chourasia

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

2010-12-01 Thread Ian Kelly
On Wed, Dec 1, 2010 at 7:58 PM, Anurag Chourasia wrote: > This is using cx_Oracle and it works fine > === cx_Oracle.version > '5.0.3' cursor.execute("select to_term from terminology_map where id=316") cursor.fetchone()[0] >

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

2010-12-01 Thread Anurag Chourasia
ATOR_CHUNK_SIZE)), File "/usr/lib/python2.5/site-packages/django/db/backends/oracle/base.py", line 552, in fetchmany for r in self.cursor.fetchmany(size)]) File "/usr/lib/python2.5/site-packages/django/db/backends/oracle/base.py", line 625, in _rowfactory value = to_unicode

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

2010-12-01 Thread Ian
On Nov 30, 8:31 pm, Anurag Chourasia wrote: > On Oracle 10.2 with Character-Set set to WE8MSWIN1252, > > When using Django, I try to select a Oracle row which contains a field with > value as 'Páginas', i encounter the following error "'utf8' codec can't > decode bytes

Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

2010-11-30 Thread Anurag Chourasia
r/lib/python2.5/site-packages/django/db/models/sql/compiler.py", line 672, in results_iter for rows in self.execute_sql(MULTI): File "/usr/lib/python2.5/site-packages/django/db/models/sql/compiler.py", line 741, in result = iter((lambda: cursor.fetchmany(GET_ITERATOR_CHUNK_SIZE)

Re: Django and Oracle Cartridges

2010-03-19 Thread Tom Evans
On Fri, Mar 19, 2010 at 1:21 PM, huw_at1 wrote: > Hi Tom, > > Sorry if I gave the impression that I had not read around before > posting here. Believe it or not I already have the top 5 hits on this > search marked as read. Was it a particular page you were referring to >

Re: Django and Oracle Cartridges

2010-03-19 Thread huw_at1
t;> using Django however from what I have read so far it appears that > >> Django is not designed to store BLOBs. I think I can encode the SQL > >> for thecartridgecommands as Django allows for this. My main concern > >> is how I go about storing these BLOBS however. Do

Re: Django and Oracle Cartridges

2010-03-19 Thread Tom Evans
hink I can encode the SQL >> for thecartridgecommands as Django allows for this. My main concern >> is how I go about storing these BLOBS however. Does anyone know about >> this or have any experience with integrating other Oracle cartridges >> into Django? >>

Re: Django and Oracle Cartridges

2010-03-19 Thread huw_at1
about storing these BLOBS however. Does anyone know about > this or have any experience with integrating other Oracle cartridges > into Django? > > Many thanks > > Huw -- You received this message because you are subscribed to the Google Groups "Django users" group. To po

Django and Oracle Cartridges

2010-03-18 Thread huw_at1
is not designed to store BLOBs. I think I can encode the SQL for the cartridge commands as Django allows for this. My main concern is how I go about storing these BLOBS however. Does anyone know about this or have any experience with integrating other Oracle cartridges into Django? Many thanks Huw -- You

Re: More DJango Tagging Oracle Issues

2009-03-24 Thread Brandon Taylor
I have confirmed that it also works as expected with cx_Oracle-5.0.1 Woohoo On Mar 24, 2:14 pm, Brandon Taylor wrote: > After much digging, I was able to find the problem. In fields.py in > django-tagging, the tags are pulled from cache when they are saved, > rather

Re: More DJango Tagging Oracle Issues

2009-03-24 Thread Brandon Taylor
After much digging, I was able to find the problem. In fields.py in django-tagging, the tags are pulled from cache when they are saved, rather than going back to the database. The problem I was seeing wasn't that tags werent' being applied to objects, or added to the database, but the input

Re: More DJango Tagging Oracle Issues

2009-03-23 Thread Brandon Taylor
Hi Ian, I'm not that familiar with Oracle, so I have no idea if the problems I'm experiencing are related in some way to permissions, etc, but I have been reassured by my Oracle person that my user has full permissions on my schema. That being said, the TagField() will show up in admin when

Re: More DJango Tagging Oracle Issues

2009-03-23 Thread Ian Kelly
On Mar 23, 1:52 pm, Brandon Taylor wrote: > Hi Everyone, > > Is anyone having issues with Django Tagging (svn) not updating tags on > an existing model? I'm running cx_Oracle-4.4.1 - thanks to (Ian Kelly) > and Django Trunk. Hmm. I tried running the same model you

More DJango Tagging Oracle Issues

2009-03-23 Thread Brandon Taylor
Hi Everyone, Is anyone having issues with Django Tagging (svn) not updating tags on an existing model? I'm running cx_Oracle-4.4.1 - thanks to (Ian Kelly) and Django Trunk. I can add tags when a model instance is created, but update/delete is not working. TIA, Brandon

django-jython-oracle

2008-10-09 Thread dusans
Im currenty trying to make a prototype for my company, which would use django-jython and a oracle database. Im expiriencing problem cuz the documentation is sparse: http://code.google.com/p/django-jython/wiki/DatabaseBackends -> jython doesnt find the .jar in classpath :( tryed for a test with

Re: Django and Oracle, again

2006-07-07 Thread BP
My testing procedure was simple. Typed DATABASE_ENGINE = 'oracle' in settings.py and tried initializing that (with proper credentials, of course). It just failed, on the basic model taken directly from the 1st part of the official tutorial. The error was "incorrect character" so I guess noone

Re: Django and Oracle, again

2006-07-06 Thread Brett Parker
On Thu, Jul 06, 2006 at 11:52:57AM +0100, Frankie Robertson wrote: > > I think the plan is that if anyone offers to maintain it then it'll > happen, otherwise it probably won't. > > On 06/07/06, BP <[EMAIL PROTECTED]> wrote: > > > > I've just run the 3278 revision of Django trunk against 10g XE

Re: Django and Oracle, again

2006-07-06 Thread Frankie Robertson
I think the plan is that if anyone offers to maintain it then it'll happen, otherwise it probably won't. On 06/07/06, BP <[EMAIL PROTECTED]> wrote: > > I've just run the 3278 revision of Django trunk against 10g XE and it's > far from working. Any comment on its status and planned inclusion in >

Django and Oracle, again

2006-07-06 Thread BP
I've just run the 3278 revision of Django trunk against 10g XE and it's far from working. Any comment on its status and planned inclusion in the 0.95 release? BP --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

Django and Oracle

2006-06-19 Thread [EMAIL PROTECTED]
Hi, I have seen some moves in the integration of Oracle with Django. However, I am quite lost between Trac tickets, svn (which I cannnot access behind my corp firewall), and the latest changes in Django. Is it planned to support Oracle? Are there any works done in that direction? Lack