Davide Alberani wrote:
> Let me know if it works.
Unfortunately, it doesn't. Same error as before:
RUNNING imdbpy2sql.py
SAVING imdbID values for movies... SKIPPING: no data.
SAVING imdbID values for people... SKIPPING: no data.
SAVING imdbID values for characters... SKIPPING: no data.
SAVING imdbID values for companies... SKIPPING: no data.
DROPPING current database... DONE!
CREATING new tables...
Traceback (most recent call last):
File "/home/selke/Desktop/imdb/IMDbPY/usr/bin/imdbpy2sql.py", line
2145, in <module>
run()
File "/home/selke/Desktop/imdb/IMDbPY/usr/bin/imdbpy2sql.py", line
2008, in run
createTables(DB_TABLES)
File "/usr/lib64/python2.5/site-packages/imdb/parser/sql/dbschema.py",
line 319, in createTables
File
"/usr/lib64/python2.5/site-packages/imdb/parser/sql/alchemyadapter.py",
line 315, in __call__
File "/usr/lib/python2.5/site-packages/sqlalchemy/sql/expression.py",
line 1087, in execute
return e.execute_clauseelement(self, multiparams, params)
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 1219, in execute_clauseelement
return connection.execute_clauseelement(elem, multiparams, params)
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 895, in execute_clauseelement
return self._execute_compiled(elem.compile(dialect=self.dialect,
column_keys=keys, inline=len(params) > 1), distilled_params=params)
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 907, in _execute_compiled
self.__execute_raw(context)
File "/usr/lib/python2.5/site-packages/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/engine/base.py",
line 960, in _cursor_execute
self._handle_dbapi_exception(e, statement, parameters, cursor)
File "/usr/lib/python2.5/site-packages/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)
ibm_db_dbi::DatabaseError: Binding Error: 'INSERT INTO kind_type (kind)
VALUES (?)' [u'movie']
> Besides that, I fear I'm out of ideas. :-/
Maybe this problem is not related to the autocommit issue at all. What
makes you conjecture that it is the cause here?
I would like to do some more systematic testing with a test case being
as minimalistic as possible. Could you please prepare such a test case,
which does exactly the same steps as IMDbPY is doing here (until the
error occurs)? I tried to do this by myself but I don't understand the
structure of the code very well ... This should be much easier for you. :-)
Joachim
--
M. Sc. Joachim Selke
Technische Universität Braunschweig, Institut für Informationssysteme
Mühlenpfordtstraße 23, 38106 Braunschweig, Germany
<http://www.l3s.uni-hannover.de/~selke>
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Imdbpy-devel mailing list
Imdbpy-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
