Hello
I have Oracle Database 10g Express Edition Release 10.2.0.1.0, Python 2.5.2,
Elixor 0.6.1 on Ubuntu x86 8.04
When stepping through the Elixir tutorial, I get an Oracle ORA-0911 error at
the create_all() step:
>>> create_all()
2008-09-19 19:06:33,987 INFO sqlalchemy.engine.base.Engine.0x..0c select
table_name from all_tables where table_name=:name
2008-09-19 19:06:33,988 INFO sqlalchemy.engine.base.Engine.0x..0c {'name':
'__MAIN___MOVIE'}
2008-09-19 19:06:34,320 INFO sqlalchemy.engine.base.Engine.0x..0c
CREATE TABLE __main___movie (
id INTEGER NOT NULL,
title VARCHAR(30),
year INTEGER,
description CLOB,
PRIMARY KEY (id)
)
2008-09-19 19:06:34,321 INFO sqlalchemy.engine.base.Engine.0x..0c {}
2008-09-19 19:06:34,464 INFO sqlalchemy.engine.base.Engine.0x..0c ROLLBACK
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/lib/python2.5/site-packages/PIL/__init__.py", line 127, in
create_all
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/schema.py",
line 1580, in create_all
bind.create(self, checkfirst=checkfirst, tables=tables)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/engine/base.py",
line 1139, in create
self._run_visitor(self.dialect.schemagenerator, entity,
connection=connection, **kwargs)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/engine/base.py",
line 1168, in _run_visitor
visitorcallable(self.dialect, conn, **kwargs).traverse(element)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/sql/visitors.py",
line 75, in traverse
return self._non_cloned_traversal(obj)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/sql/visitors.py",
line 134, in _non_cloned_traversal
self.traverse_single(target)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/sql/visitors.py",
line 35, in traverse_single
return meth(obj, **kwargs)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/sql/compiler.py",
line 759, in visit_metadata
self.traverse_single(table)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/sql/visitors.py",
line 35, in traverse_single
return meth(obj, **kwargs)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/sql/compiler.py",
line 795, in visit_table
self.execute()
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/engine/base.py",
line 1792, in execute
return self.connection.execute(self.buffer.getvalue())
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/engine/base.py",
line 844, in execute
return Connection.executors[c](self, object, multiparams, params)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/engine/base.py",
line 854, in _execute_text
self.__execute_raw(context)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/engine/base.py",
line 916, in __execute_raw
self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/engine/base.py",
line 960, in _cursor_execute
self._handle_dbapi_exception(e, statement, parameters, cursor)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/engine/base.py",
line 942, in _handle_dbapi_exception
raise exceptions.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
sqlalchemy.exceptions.DatabaseError: (DatabaseError) ORA-00911: invalid
character
'\nCREATE TABLE __main___movie (\n\tid INTEGER NOT NULL, \n\ttitle
VARCHAR(30), \n\tyear INTEGER, \n\tdescription CLOB, \n\tPRIMARY KEY
(id)\n)\n\n' {}
Can anyone please advise a workaround? Is Oracle XE a supported backend for
the Elixir / SQLAlchemy combination?
Regards
Bruce
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SQLElixir" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlelixir?hl=en
-~----------~----~----~----~------~----~------~--~---
