Davide Alberani wrote:
> It can be a problem:
> - in your database (some settings about unicode/collations?).
I use a standard installation of DB2 9.5 (latest fixpack) on CentOS 5,
which is a binary-compatiable clone of the Red Hat Enterprise Linux. The
latter is supported by IBM. Therefore, this shouldn't make any trouble,
should it?
> - in the ibm_db module.
> - of the ibm_db_sa adapter.
I made some more tests. The following code inserts the value successfully:
import ibm_db
ibm_db_conn =
ibm_db.connect('DATABASE=mydb;HOSTNAME=myhost;PORT=myport;PROTOCOL=TCPIP;UID=myuser;PWD=mypass;',
'', '')
import ibm_db_dbi
connection = ibm_db_dbi.Connection(ibm_db_conn)
cursor = connection.cursor()
cursor.execute('INSERT INTO kind_type (kind) VALUES (?)', ['movie'])
This one does not (based on your code) but also doesn't raise an error:
import ibm_db_dbi
connection =
ibm_db_dbi.connect('DATABASE=mydb;HOSTNAME=myhost;PORT=myport;PROTOCOL=TCPIP;UID=myuser;PWD=mypass;')
cursor = connection.cursor()
cursor.execute('INSERT INTO kind_type (kind) VALUES (?)', ['movie'])
Does this help?
> Anyway, a test with SQLAlchemy 0.5 looks like a good idea, now.
I tried that but it doesn't help. I get the same error as before
(sqlalchemy.exc.DatabaseError: (DatabaseError)
ibm_db_dbi::DatabaseError: Binding Error: 'INSERT INTO kind_type (kind)
VALUES (?)' [u'movie'])
What's next?
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
