On Sun, May 17, 2009 at 3:14 PM, Doug <doug.rea...@rmsfinance.com> wrote:
> > When I attempt to use Oracle as the backend for Django, I get this > error on issuing the 'syndb' command: > "cx_Oracle.DatabaseError: ORA-00911: invalid character". > > ** Configuration: Python 2.5; cx_Oracle 5.0.1- 10g and Django version...? > > ** Setting: Backend=oracle; User=django; PW=django; Host=BLANK; > Port=BLANK > > ** Complete Error Stack: > > Traceback (most recent call last): > File "manage.py", line 11, in <module> > execute_manager(settings) > File "C:\Python25\lib\site-packages\django\core\management.py", line > 1672, in > execute_manager > execute_from_command_line(action_mapping, argv) > File "C:\Python25\lib\site-packages\django\core\management.py", line > 1571, in > execute_from_command_line > action_mapping[action](int(options.verbosity), > options.interactive) > File "C:\Python25\lib\site-packages\django\core\management.py", line > 534, in s > yncdb > cursor.execute(statement) File "C:\Python25\lib\site-packages\django\db\backends\oracle > \base.py", line 7 > 2, in execute > return Database.Cursor.execute(self, query, params) > cx_Oracle.DatabaseError: ORA-00911: invalid character > > > ** I can connect outside of Django: > >>> USER = 'django'; DATABASE_PW = 'django'; DATABASE_NAME = 'XE'; > >>> conn_str = "%s/%...@%s" % (USER, DATABASE_PW, DATABASE_NAME) > >>> conn_str > 'django/dja...@xe' > >>> myDB = cx_Oracle.connect(conn_str) > >>> myDB > <cx_Oracle.Connection to dja...@xe> > > Can someone help me with some guidance? What am I doing wrong? > The file django\core\management.py, referenced several times in that traceback, doesn't exist in Django 1.0. It existed in Django 0.96 but was refactored into a directory django\core\management before the 1.0 release. So you seem to be running some version of Django lower than 1.0. Yet 1.0 was the first version to have working Oracle support -- the branch that got Oracle working wasn't merged back to trunk until after 0.96 was released. So, if you are running a 0.96.x version of Django I wouldn't expect the Oracle backend to work there. If you are running an SVN checkout from after the Oracle branch merge (r5519), I have no idea what's going wrong. Karen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
