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
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,
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
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
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
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
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?! :)
> >
> >
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
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
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
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
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
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:
>
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,
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
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
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
>
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
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
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
>
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
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"
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.
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",
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']
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
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
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]
>
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
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
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)
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
>
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
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?
>>
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
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
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
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
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
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
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
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
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
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
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
>
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
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
47 matches
Mail list logo