Oracle (cx_Oracle 4.4) exception raises AttributeError (no attribute message) with some errors

[erny]

• Description: Django requires the exception to have "message" attribute, but some errors don't. The real error is hidden and difficult to get.
• How to reproduce:
  • install cx_Oracle: sudo easy_install cx_Oracle #requires python-setuptools
  • in your settings.py, use:

          * DATABASE_ENGINE = 'oracle'
          * DATABASE_NAME = 'XE'  # your dbname here
          * DATABASE_USER = 'testuser' # your user here
          * DATABASE_PASSWORD = 'password' # your password here
          * DATABASE_HOST = 'localhost'    # your db host
          * DATABASE_PORT = ''       # leave empty if default port 1521 
          * DEFAULT_TABLESPACE = 'NONEXISTING'  # use some invalid tablespace
          * DEFAULT_INDEX_TABLESPACE = 'NONEXISTING' # here also
    

  • with an empty database, run syncdb: ./manage syncdb

Traceback:

...
  File "/opt/csa-1.0.0-beta/parts/django/django/core/management/commands/syncdb.py", line 80, in handle_noargs
    cursor.execute(statement)
  File "/opt/csa-1.0.0-beta/parts/django/django/db/backends/oracle/base.py", line 364, in execute
    if e.message.code == 1400 and type(e) != IntegrityError:
AttributeError: DatabaseError instance has no attribute 'message'

[erny]

I should have put the settings.py part into brackets.

[Karen Tracey]

Fixed formatting.

[erny]

Patch for "AttributeError: DatabaseError instance has no attribute 'message'"

[erny]

The patch is not valid. It was made against trunk, but trunk does work correctly.