Oracle database sequences generated by Django

Hello everyone. I have a web application built in Django == 1.11.6, when the migrations were generated in oracle the sequences are created and they can be modified and even deleted. When I update to django 3 and I generate the migrations again, it creates the sequences with a name similar to

Oracle database sequences generated by Django

Hello everyone. I have a web application built in Django == 1.11.6, when the migrations were generated in oracle the sequences are created and they can be modified and even deleted. When I update to django 3 and I generate the migrations again, it creates the sequences with a name similar to

Oracle database sequences generated by Django

Hello everyone. I have a web application built in Django == 1.11.6, when the migrations were generated in oracle the sequences are created and they can be modified and even deleted. When I update to django 3 and I generate the migrations again, it creates the sequences with a name similar to

Re: Oracle database

You need to define your db connection details , server schema user password within file settings.py inside your project directory :) Sent from my iPhone > On Nov 3, 2018, at 1:26 PM, fatoubinetou...@gmail.com wrote: > > Hi!!! Do you know how to use oracle database with django? &g

Oracle database

Hi!!! Do you know how to use oracle database with django? -- 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 an email to django-users+unsubscr...@googlegroups.com.

Re: Deploying Oracle database to production enviroment

Heh... why make things easier when we can complicate? 😁 Instead of bringing your problem to you, you could push back on to them: ask them to have a "stage" schema (where you do have permission to change) they would just export later to the production environment. If they want audit, the database

Deploying Oracle database to production enviroment

Hi, I've been working with django within the place I work and in order to deploy the django app we're developing we need to migrate the database to a production enviroment. The database backend we are using is Oracle, and the users permission created for that are just for select, insert, etc, n

Re: Django 1.10.3 with Oracle database and --keepdb

It will appear in the next release. W dniu poniedziałek, 7 listopada 2016 14:38:46 UTC+1 użytkownik Carsten Fuchs napisał: > > Am 05.11.2016 um 15:55 schrieb Carsten Fuchs: > > Am 2016-11-05 um 13:11 schrieb Mariusz Felisiak: > >> Yes. Please, make sure that your main oracle user has *ALTER USE

Re: Django 1.10.3 with Oracle database and --keepdb

Am 05.11.2016 um 15:55 schrieb Carsten Fuchs: Am 2016-11-05 um 13:11 schrieb Mariusz Felisiak: Yes. Please, make sure that your main oracle user has *ALTER USER* permission. I'll check (it may take until Monday or Tuesday though) and post an update here. Indeed, after having added the ALTER

Re: Django 1.10.3 with Oracle database and --keepdb

Hi Mariusz, Am 2016-11-05 um 13:11 schrieb Mariusz Felisiak: Yes. Please, make sure that your main oracle user has *ALTER USER* permission. It is well possible that that is the culprit. I've set my database user's privileges as described at https://docs.djangoproject.com/en/1.10/ref/database

Re: Django 1.10.3 with Oracle database and --keepdb

Hi Simon, Am 05.11.2016 um 08:46 schrieb Simon Charette: [0] https://code.djangoproject.com/ticket/27435#ticket Thank you! Best regards, Carsten -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receivi

Re: Django 1.10.3 with Oracle database and --keepdb

W dniu piątek, 4 listopada 2016 17:12:09 UTC+1 użytkownik Carsten Fuchs napisał: > > supposed to work without having an explicit test password set? > > Yes. Please, make sure that your main oracle user has *ALTER USER* permission. -- You received this message because you are subscribed to th

Re: Django 1.10.3 with Oracle database and --keepdb

https://code.djangoproject.com/ticket/27435#ticket Le vendredi 4 novembre 2016 12:12:09 UTC-4, Carsten Fuchs a écrit : > > Dear Django fellows, > > using Django 1.10.3 with Oracle database, is running > >./manage.py test --keepdb > > supposed to work without having

Django 1.10.3 with Oracle database and --keepdb

Dear Django fellows, using Django 1.10.3 with Oracle database, is running ./manage.py test --keepdb supposed to work without having an explicit test password set? DATABASES = { 'default': { 'ENGINE': 'django.db.backends.oracle'

Re: Django M2M with Oracle database FieldDoesNotExist error

Hi everyone, I'm following this thread and I'm having the same error. Im running a postgis db, and despite the biginteger pk, my problem is the same. Could you solve it? Thanks! On Monday, August 3, 2015 at 11:16:12 PM UTC-6, mohse...@gmail.com wrote: > > i found that even trying to access the

Re: Django M2M with Oracle database FieldDoesNotExist error

i found that even trying to access the relation (i.e. foo.bars) will trigger the same error !!! the only special thing about my model is that i defined foo's primary key as BigIntegerField On Tuesday, August 4, 2015 at 8:15:42 AM UTC+4:30, mohse...@gmail.com wrote: > > Erik, as stated in documen

Re: Django M2M with Oracle database FieldDoesNotExist error

Erik, as stated in documentation , what you said is equivalent to what i did and the error exists yet. to have more details, here is the stack trace: Traceback (most recent call last): File "", line 2, in File "

Re: Django M2M with Oracle database FieldDoesNotExist error

> Den 03/08/2015 kl. 08.50 skrev mohsenba...@gmail.com: > > Hello Django community. > I have two Django models Foo and Bar that have a ManyToMany relation: > > Class Foo(models.model): > > ... > > bars = models.ManyToManyField('Bar', related_name='foos') > somewhere in the code, i do dire

Django M2M with Oracle database FieldDoesNotExist error

Hello Django community. I have two Django models Foo and Bar that have a ManyToMany relation: Class Foo(models.model): ... bars = models.ManyToManyField('Bar', related_name='foos') somewhere in the code, i do direct assignment

Re: Why is list(Model.objects.all()) 10x slower against an Oracle database as compared to Postgres?

; local Postgresql database. It takes at least 10x longer against an Oracle > database. The thing is the query itself doesn't seem to be holding it up. > > I don't really know how to track this down without going and putting > random print datetimes in the django sourcecode. I&

Re: Why is list(Model.objects.all()) 10x slower against an Oracle database as compared to Postgres?

t a postgres database but > our dev/test/prod servers all run Oracle. > > The command list(Person.objects.all()) runs remarkably faster against my > local Postgresql database. It takes at least 10x longer against an Oracle > database. The thing is the query itself doesn't seem to

Why is list(Model.objects.all()) 10x slower against an Oracle database as compared to Postgres?

I have an application that we run locally against a postgres database but our dev/test/prod servers all run Oracle. The command list(Person.objects.all()) runs remarkably faster against my local Postgresql database. It takes at least 10x longer against an Oracle database. The thing is the

Django doesn't close connections to Oracle database.

Hi everyone, I'm hosting django (1.4) app via httpd (apache - 2.2.21) and mod_wsgi (3.3.1) on fedora 15 and having problem with Oracle, which blocks further connections after limit is reached. I know Django connects to a db for every query, which will be changed in 1.6 with persistent connectio

Re: Oracle database TextField limitations and Django admin interface queries

On Saturday, April 13, 2013 7:54:43 PM UTC+3, Ian wrote: > > On Saturday, April 13, 2013 10:40:10 AM UTC-6, Ian wrote: >> >> On Friday, April 12, 2013 7:43:32 AM UTC-6, Lauri Savolainen wrote: >>> >>> Thank you for the reply, >>> >>> The field is defined in the Django model as: >>> location_descr

Re: Oracle database TextField limitations and Django admin interface queries

On Saturday, April 13, 2013 10:40:10 AM UTC-6, Ian wrote: > > On Friday, April 12, 2013 7:43:32 AM UTC-6, Lauri Savolainen wrote: >> >> Thank you for the reply, >> >> The field is defined in the Django model as: >> location_description = models.TextField(_('additional route >> information'), blank

Re: Oracle database TextField limitations and Django admin interface queries

On Friday, April 12, 2013 7:43:32 AM UTC-6, Lauri Savolainen wrote: > > Thank you for the reply, > > The field is defined in the Django model as: > location_description = models.TextField(_('additional route information'), > blank=True) > > Data length for the corresponding column in the database

Re: Oracle database TextField limitations and Django admin interface queries

ects parameters like ?route_no=1234 and > > so forth into the url resulting in a filtered list view. For the most > > part this works but when I want to search for routes that, for example, > > have observation events past certain date with a query like > > ?observationev

Re: Oracle database TextField limitations and Django admin interface queries

while using an Oracle database in production. The query seems to work when using a development SQLite database or doing a query like Route.objects.filter(observationevent__observation_date__gte='2012-01-01') directly in the management console even when using the Oracle production database

Oracle database TextField limitations and Django admin interface queries

ation events past certain date with a query like ?observationevent__observation_date__gte=2010-01-01 (supposed to show all routes that have been observed this decade) it raises an DatabaseError: ORA-00932: inconsistent datatypes: expected - got NCLOB-exception while using an Oracle databa

Re: Syncdb Error With Oracle Database - IntegrityError Exception

Thanks, Ian, I did miss that. Bookmarked for future reference. On Saturday, September 1, 2012 3:16:38 PM UTC+10, Ian wrote: > > On Fri, Aug 31, 2012 at 10:03 PM, Jon Blake > > wrote: > > Querying column timestamp of view user_objects for tables, sequences and > > triggers appears to confirm my

Re: Syncdb Error With Oracle Database - IntegrityError Exception

Again, many thanks. I'm on my way with Django - looking like a great framework! Jon On Saturday, September 1, 2012 2:03:42 PM UTC+10, Jon Blake wrote: > > Thanks, Ian and Amyth, for your responses. > > I encountered the CREATE TRIGGER privilege issue early in my trials with &

Re: Syncdb Error With Oracle Database - IntegrityError Exception

On Fri, Aug 31, 2012 at 10:03 PM, Jon Blake wrote: > Querying column timestamp of view user_objects for tables, sequences and > triggers appears to confirm my understanding of what base.py does. I'll drop > and recreate my user account, and try again. I'll advise how this goes. Does > the Django d

Re: Syncdb Error With Oracle Database - IntegrityError Exception

Thanks, Ian and Amyth, for your responses. I encountered the CREATE TRIGGER privilege issue early in my trials with Django with the Oracle database back end - Django propagated an Oracle "insufficient privileges" exception. That was quickly sorted by granting the required privilege

Re: Syncdb Error With Oracle Database - IntegrityError Exception

On Friday, August 31, 2012 12:10:54 AM UTC-6, Amyth wrote: > > Hey Jon, > > I guess this is because of a bug in django. Django already has a open > ticket for this bug. Check it out > here > . > > As described in that ticket, the reason for the proble

Re: Syncdb Error With Oracle Database - IntegrityError Exception

hat schema django contains 9 tables (including > auth_permission), 16 indexes, 7 triggers and 8 sequences. Table > django_content_type contains three rows, and the others are empty. > > Can anyone advise on how to resolve the ORA-01400 error? > > Run-time environment: > O/S: Fedor

Syncdb Error With Oracle Database - IntegrityError Exception

ins 9 tables (including auth_permission), 16 indexes, 7 triggers and 8 sequences. Table django_content_type contains three rows, and the others are empty. Can anyone advise on how to resolve the ORA-01400 error? Run-time environment: O/S: Fedora 14 Django: 1.4.1 Python: 2.7 DB: Oracl

Re: Oracle Database Other User Tables/Views

The quoting trick worked well. Thank You Chris >>> Ian 10/20/10 2:48 PM >>> On Oct 20, 8:20 am, "Christopher Conover" wrote: > Hello, > > I am using Django's multiple database support to connect to an existing > Oracle database (10g). I do not

Re: Oracle Database Other User Tables/Views

On Oct 20, 8:20 am, "Christopher Conover" wrote: > Hello, > > I am using Django's multiple database support to connect to an existing > Oracle database (10g). I do not have control of the schema nor do I have any > other privileges beyond SELECT. Further, th

Oracle Database Other User Tables/Views

Hello, I am using Django's multiple database support to connect to an existing Oracle database (10g). I do not have control of the schema nor do I have any other privileges beyond SELECT. Further, the tables and views that I have access to are owned by a different user. Because of thi

Re: multiple oracle database queries in one request problem

th threads: mod_wsgi on windows. - It occurs when talking to the oracle database. - It occurs when I talk to two databases on the same oracle server (well, that's database in django speak, oracle calls it a schema: it is in the same physical oracle-speak database). So I'm desperately

Re: multiple oracle database queries in one request problem

On 9/1/2010 5:54 PM, Reinout van Rees wrote: > On 09/01/2010 02:00 PM, Reinout van Rees wrote: >> Hi, >> >> I'm deploying a site on windows with oracle (and I don't know either of >> them well). Simple apache+wsgi setup for now. > > I'll have to test it out tomorrow when I'm near the windows machi

Re: multiple oracle database queries in one request problem

On 09/01/2010 02:00 PM, Reinout van Rees wrote: Hi, I'm deploying a site on windows with oracle (and I don't know either of them well). Simple apache+wsgi setup for now. I'll have to test it out tomorrow when I'm near the windows machine again, but I might have found the solution in an existi

multiple oracle database queries in one request problem

Hi, I'm deploying a site on windows with oracle (and I don't know either of them well). Simple apache+wsgi setup for now. Problem: one specific page kills off the mod_wsgi/django part. The rest of apache keeps working. "Kill off" meaning "it doesn't react anymore and takes quite some time f

Re: legacy oracle database -w- existing schema

Yes, this resolve the issue. Thank you! On Mar 16, 2:29 pm, "Mad Sweeney" wrote: > - Original Message - > From: "bruce" > To: "Django users" > Sent: Monday, March 16, 2009 9:00 PM > Subject: legacy oracle database -w- existing schema

Re: legacy oracle database -w- existing schema

I can look into that as an option. I don't have access to administrate this database. On Mar 16, 2:29 pm, "Mad Sweeney" wrote: > - Original Message - > From: "bruce" > To: "Django users" > Sent: Monday, March 16, 2009 9:00 PM > S

Re: legacy oracle database -w- existing schema

- Original Message - From: "bruce" To: "Django users" Sent: Monday, March 16, 2009 9:00 PM Subject: legacy oracle database -w- existing schema > > Hi- > I'm a new user to Django. I've searched through the documentation and > other posted que

legacy oracle database -w- existing schema

Hi- I'm a new user to Django. I've searched through the documentation and other posted questions. I'm currently attempting to setup the model to access an Oracle 9 database. I have access the database, yet the tables and views are stored in another existing schema not owned by me. Other than c

Re: Django tutorial with Oracle Database

Ah... I guess it was maybe a bug that got fixed. I upgraded from 0.96 to the SVN trunk, and the problem went away. Thanks, Brian On Aug 5, 7:34 pm, Brian Duff <[EMAIL PROTECTED]> wrote: > Hi, > > I'm following the Django tutorial > athttp://www.djangoproject.com/documentation/tutorial01/ > with

Django tutorial with Oracle Database

Hi, I'm following the Django tutorial at http://www.djangoproject.com/documentation/tutorial01/ with an Oracle XE 10.2 database. cx_Oracle is installed and seems to be working fine. At the point where the tutorial instructs me to "python manage.py syncdb", I see: Creating table auth_message Tr

Re: using oracle database with django running on an Intel Mac

forgot to add: - I tried compiling with both gcc 4.01 and gcc 3.3 - invoking "python setup.py build" needs env ORACLE_HOME set, I set it to point to the instaclient directory frank h. wrote: > Hello all > I have an Intel based Macbook, universal Python 2.4 and the Oracle > instaclient installed.

using oracle database with django running on an Intel Mac

Hello all I have an Intel based Macbook, universal Python 2.4 and the Oracle instaclient installed. I can connect fine to my Oracle db which runs on another server using sqlplus. I am on trunk (r4365) and I just want to use django to make some nice views of some of the tables in that oracle db -