Home Original page

SQLError: (2014, "Commands out of sync; You can't run this command now")

JZ jroznfgre at jngpugbjreQBGbet.cy
Wed Oct 8 05:57:04 EDT 2003 
On Tue, 07 Oct 2003 23:30:23 GMT, Dennis Lee Bieber
<wlfraed at ix.netcom.com> wrote:

>>     def execute(self, sql):
>>         self.dbConnect()
>>         self.rowcount = self.cursor.execute(sql)
>>         self.dbDisconnect()
>>         return self.rowcount
>
>        Just out of curiosity, do you ever do anything with the data from the 
>query? 

No. I have just typed part of my code.

>All you return here is the affected rows (I believe) and you 
>close the cursor/connection which likely trashes any results.

No. For my convenience, I created methods based on PEAR syntax. E.g.
getAll(), getMany(), getOne() which return desired values without
explicit using cursors or fetchone() methods of API 2.0

>        You don't show the application generating the error(s) -- what type of 
>operation was requested?

I got advise from webware maillist, that it is MySQLdb problem. I
appears during using one db connection and more than one cursors
working on two or more servlets parallelly.

--
JZ ICQ:6712522
More information about the Python-list mailing list