On Wed, Mar 6, 2013 at 1:38 AM, Ian wrote:
> In the meanwhile, the commonly used workaround for this is to include the
> schema in the db_table declaration like so:
The other workaround which is mentioned in the ticket I linked but
which I completely neglected to include
On Wed, Jan 9, 2013 at 11:40 PM, Jani Tiainen wrote:
> If we just force using force_unicode everything works except in older
> versions of cx_Oracle (our server had 5.0.4 or something) connection strings
> can't be unicode for some reason.
Sure, that's why the check exists in
On Wed, Jan 9, 2013 at 3:55 AM, Jani Tiainen wrote:
> Server is running Oracle Database 10g Release 10.2.0.5.0 - 64bit Production.
> (EE edition)
>
> and charset info:
> NLS_CHARACTERSETWE8ISO8859P1
> NLS_NCHAR_CHARACTERSET AL16UTF16
Sorry, I meant your web server
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
On Wed, Jun 20, 2012 at 12:31 PM, André Pang wrote:
> I honestly don't mind whether Django decides to do this or not, since I can
> always hack our local tree to enforce this at the database level, but I
> thought it's an idea worth discussing. In my case, I found a couple
On Tue, Oct 4, 2011 at 2:28 PM, msbuck wrote:
> Below is the settings. I am fairly new to python unit testing so my
> understanding of things could be better. But right now, if I select
> Run As -> Python Unit Test will my project is selected, it runs all of
> my Django tests
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
On Thu, Dec 2, 2010 at 5:34 PM, Anurag Chourasia
wrote:
> Hi Ian,
> I just tried the ctypes solution that you mentioned in your previous email
> but it does not work for me.
In your transcript, it appears that Django has already been loaded
when you call the ctypes
On Thu, Dec 2, 2010 at 3:23 PM, Ian Kelly <ian.g.ke...@gmail.com> wrote:
> Weird. From what I can tell, this seems to have something to do with
> Cygwin, or at least I'm able to replicate it in that environment.
> Setting NLS_LANG in or out of process and changing the registry
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",
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
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]
>
On Oct 1, 6:26 pm, alphacc wrote:
> I installed 9i at home and did some more test.
> With the same application running (and updating the same field) I
> discovered that the limit is not the same for my database.
> It is now 1246 Characters.
> I started a new application (a
On Sep 30, 11:35 am, Thomas wrote:
> Hello,
>
> OS : windows
> Python : 2.6.2
>
> I have an issue with Textfield in django models.
> The textfield are created as NCLOB in the Oracle 9i DB.
> When I try to save a textfield from the django admin it works fine if
> the limit of
On Jul 16, 7:51 am, Petry wrote:
> Hello,
>
> I am working on a project where I have to store a large amount of
> content, (html) in a record from a table, I am using Oracle as the
> database
>
> What is very strange ... is put a text reasonably small, (around 2000
>
On Jul 15, 7:07 am, Karen Tracey wrote:
> On Wed, Jul 15, 2009 at 4:18 AM, pho...@gmail.com wrote:
>
> > the code of models:
> > mgsyxs = models.DecimalField(decimal_places=-127, null=True,
> > max_digits=126, db_column='MGSYXS', blank=True) # Field name
On Jul 3, 6:13 am, Wanpeng wrote:
> Hello,
> I am writing my first app in Django. I already have existing
> tables/sequences/triggers in Oracle. so I used "inspectdb" to generate the
> models for django. Here's one model for example:
>
> class Instructors(models.Model):
>
On Jun 30, 2:55 am, "arli...@gmail.com" wrote:
> I can use the oracle with django admin runserver,
> but when i use apche with mod_wsgi , apache error log :
> ImproperlyConfigured: Error loading cx_Oracle module: DLL load failed:
> What's wrong with it ?
Make sure you're
On Jun 15, 11:11 am, Miles wrote:
> Connections aren't thread safe - you have to ensure every thread gets
> its own connection. You can create a new connection every request or
> use a thread-local to cache connections.
The latter is what Django does, although it's very easy
On May 25, 1:07 pm, Andrási László (g) wrote:
> Hi,
>
> We have a problem with an Oracle DB version 10g Release 10.2.0.1.0., Django
> latest svn version and cx_Oracle 5.0.1-2
>
> "select * from nls_database_parameters where parameter='NLS_CHARACTERSET';"
> returns
On May 22, 10:59 am, Christina wrote:
> Hi all,
>
> I'm trying to set up a new Django app that will have several models
> based on existing Oracle tables. I'm running Django 1.0.2, python
> 2.5.1 and cxOracle 5.0.1.
>
> These tables are in a different schema than the
On May 15, 1:23 am, modelmike wrote:
> How do I use 'primary_key=True' with Oracle 10g R2 to create a primary
> key on a custom field instead of on the default ID field?
>
> 'python manage.py sqlall ' shows that Django's SQL
> generation correctly assigns the PRIMARY KEY
On Apr 30, 12:30 pm, Jason Geiger wrote:
> Hello. I'm using Oracle and I would like to have a restricted user for
> Django that can only do DML. Is there a way to specify a schema that
> would prefix all "naked" table references so that this user can find
> the tables as it
On Mar 23, 1:52 pm, Brandon Taylor <btaylordes...@gmail.com> 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 runni
On Mar 20, 3:00 pm, elm wrote:
> Thanxs for the advice Ian!!!
>
> But unfortunately I haven't been succesful.
>
> I have set the NLS_LANG to .UTF8 in the directive at the
> apache conf file:
>
>
> SetHandler python-program
> PythonHandler
On Mar 20, 1:52 pm, Brandon Taylor wrote:
> Hmm. Well, I guess the only thing left to ask is what version of
> Django and Tagging you're running?
>
> I'm using Oracle 10g, cx_Oracle-5.0.1, Django and Tagging from svn.
> Other than that, I'm at a loss :)
The same, but
On Mar 20, 11:16 am, Ian Kelly <ian.g.ke...@gmail.com> wrote:
> As far as I know, the NLS_LANG environment variable is the only way to
> specify the client encoding in cx_Oracle. If that can't be relied
> upon within your Apache process, then I think you would need to run
On Mar 20, 12:08 pm, Brandon Taylor wrote:
> Nope, still not working. If you're not defining tags = TagField() in
> the model, how are you defining it? As a CharField? I'd like to see
> how your model is set up.
>
> Of course, if I create a CharField and call it tags, it
On Mar 20, 6:51 am, elm wrote:
> > Are you sharing the web server with web applications written using
> > something else, such as PHP? If PHP is playing with the language
> > settings, you might be hitting an ordering problem. That is, it works
> > if any PHP code gets
On Mar 20, 8:26 am, Brandon Taylor wrote:
> Hi Ian,
>
> Thanks for the response. The test case is adding the TagField() to any
> model.
>
> Here's an excerpt from my model class:
>
> #models.py
> from django.db import models
> from django.contrib import admin
> from
On Mar 19, 4:55 pm, elm wrote:
> I have bee trying to deal with an erratic error for the last 3 day. I
> hope you can rescue me!!!
>
> After experiencing erratic errors that appeared from time to time on a
> larger project (i.e. ViewDoesNotExist) I have reduced my
On Mar 19, 9:21 am, Brandon Taylor wrote:
> Hi Everyone,
>
> I'm using the svn checkout of Django-Tagging and Django-Trunk. Tagging
> is working perfectly for me with any other database except, of course,
> Oracle, which is what I need it to work in.
>
> I can't get the
On Mar 14, 8:04 am, Sergio wrote:
> wow, that's interesting. I was not aware if this.
>
> So, coming to the real question, here is my use case which raised this
> questions:
>
> I've a class in the model with two CharFields. When validating data
> inputs, I need to check
On Mar 5, 2:29 pm, "robertmalik...@googlemail.com"
wrote:
> Edit settings.py and;
> DATABASE_NAME = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=db_hostname)
> (Port=1521))(CONNECT_DATA=(SID=db_sid)))'
>
> Replace the db_sid with your database sid and db_hostname the
On Feb 20, 3:26 pm, Brandon Taylor wrote:
> Yes, I'm just using the built-in server for local development. I've
> restarted it dozens of times, cleared my browser cache, etc.
>
> Is the built-in server not compatible with Oracle? If not, I'll just
> get an
On Feb 20, 3:14 pm, Brandon Taylor wrote:
> I think I may have found the culprit (?), but I have no idea how to
> fix this. In my project folder, there is a file called sqlnet.log.
> Here's the last entry:
>
> Fatal NI connect error 12505, connecting to:
>
On Feb 20, 3:01 pm, Brandon Taylor wrote:
> Actually I was referring to my action in views.py to get the Category
> objects:
>
> from activity_codes.models import * (this is the auto-generated
> models.py)
>
> def home(request):
> categories =
On Feb 20, 2:25 pm, Brandon Taylor wrote:
> however attempting to retrieve the Category objects from a view
> results in:
> DatabaseError: ORA-00942: table or view does not exist
>
> Thoughts?
You can definitely use views with Django (although inspectdb will
blissfully
On Feb 20, 2:08 pm, Brandon Taylor wrote:
> Hi Ian,
>
> Here's her's the quick model I wrote to try to select *something*:
>
> class TestCategory(models.Model):
> name = models.CharField(max_length=255)
> class Meta:
> db_table =
On Feb 20, 12:50 pm, Brandon Taylor wrote:
> OK, I am pretty sure I found out where to put the tns_names.ora file:
> $ORACLE_HOME/network/admin
>
> But, I'm confused as to how to specify the database name. From the
> Django Oracle docs
40 matches
Mail list logo