I've been using an Oracle database and reflection (i.e.,
autoload=True). I recently added a BLOB column to the database. I
never did any modification to the Python application code yet. The
application was made using Turbogears and it just serves two forms,
one for inserting records and one for updating . I am still able to
update records, but when I do an insert I get the error below. I tried
the latest oracle.py (r2303) and get the same thing (I couldn't do an
svn checkout of everything because of our companies firewall).
Page handler: <bound method Root.insertrequest of
<srt.controllers.Root object at 0x0180EDB0>>
Traceback (most recent call last):
File "c:\python24\lib\site-packages\CherryPy-2.2.1-py2.4.egg\cherrypy
\_cphttptools.py", line 105, in _run
self.main()
File "c:\python24\lib\site-packages\CherryPy-2.2.1-py2.4.egg\cherrypy
\_cphttptools.py", line 254, in main
body = page_handler(*virtual_path, **self.params)
File "<string>", line 3, in insertrequest
File "c:\python24\lib\site-packages\turbogears-1.0.1-py2.4.egg
\turbogears\controllers.py", line 334, in expose
output = database.run_with_transaction(
File "<string>", line 5, in run_with_transaction
File "c:\python24\lib\site-packages\turbogears-1.0.1-py2.4.egg
\turbogears\database.py", line 347, in sa_rwt
retval = dispatch_exception(e,args,kw)
File "c:\python24\lib\site-packages\turbogears-1.0.1-py2.4.egg
\turbogears\database.py", line 345, in sa_rwt
transaction.commit()
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\orm\session.py", line 54, in commit
self.session.flush()
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\orm\session.py", line 220, in flush
self.uow.flush(self, objects)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\orm\unitofwork.py", line 194, in flush
flush_context.execute()
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\orm\unitofwork.py", line 333, in execute
head.execute(self)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\orm\unitofwork.py", line 470, in execute
UOWExecutor().execute(trans, self)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\orm\unitofwork.py", line 793, in execute
self.execute_save_steps(trans, task)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\orm\unitofwork.py", line 815, in execute_save_steps
self.execute_childtasks(trans, task, False)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\orm\unitofwork.py", line 841, in execute_childtasks
self.execute(trans, child, isdelete)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\orm\unitofwork.py", line 793, in execute
self.execute_save_steps(trans, task)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\orm\unitofwork.py", line 810, in execute_save_steps
self.save_objects(trans, task)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\orm\unitofwork.py", line 798, in save_objects
task._save_objects(trans)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\orm\unitofwork.py", line 461, in _save_objects
self.mapper.save_obj(self.polymorphic_tosave_objects, trans)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\orm\mapper.py", line 998, in save_obj
c = connection.execute(statement, params)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\engine\base.py", line 258, in execute
return Connection.executors[type(object).__mro__[-2]](self,
object, *multiparams, **params)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\engine\base.py", line 282, in execute_clauseelement
return self.execute_compiled(elem.compile(engine=self.__engine,
parameters=param), *multiparams, **params)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\engine\base.py", line 297, in execute_compiled
context.pre_exec(self.__engine, proxy, compiled, parameters)
File "C:\Python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\databases\oracle.py", line 152, in pre_exec
super(OracleExecutionContext, self).pre_exec(engine, proxy,
compiled, parameters)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\engine\default.py", line 128, in pre_exec
self._process_defaults(engine, proxy, compiled, parameters)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\engine\default.py", line 204, in _process_defaults
elif not param.has_key(c.key) or param[c.key] is None:
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\sql.py", line 321, in __getitem__
v = self.binds[key].typeprocess(v, self.dialect)
File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\sql.py", line 836, in typeprocess
return self.type.dialect_impl(dialect).convert_bind_param(value,
dialect)
File "C:\Python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg
\sqlalchemy\databases\oracle.py", line 67, in convert_bind_param
return ''.join(["%.2X" % ord(c) for c in value])
TypeError: iteration over non-sequence
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
