sql query works in database connector but not in ZSQL method
robert rottermann <[email protected]>
| Newsgroups | gmane.comp.web.zope.database |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi there,
I try the following statement:
CALL selectVertexProperties(1, @error2)
when I execute this directly in the test "window" of the database
connection, it works fine.
when i execute the same line in the test window of a ZSQL Method
then I get an error:
Error, Products.mxODBCZopeDA.ZopeDA.ReplayTransaction: OperationalError
on : ('HYT00', 2014, "[unixODBC][MySQL][ODBC 3.51
Driver][mysqld-5.0.26]Commands out of sync; you can't run this command
now", 6113) SQL used:
CALL selectVertexProperties(1, @error2)
when I call this method from plain python, it works fine also.
Any pointers what could be the reason would be greatly appreciated.
robert
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org
iD8DBQFFrjW8GaryJ0T9kUYRAj3iAJ0ccFcfy/y3q4eQs+80ZfDhQFuyfwCePLG+
wjLmLUZmHOvnkEkygo82HJA=
=Jq1+
-----END PGP SIGNATURE-----