Prepared stmt in cluster 4.1.14
Posted by:
Jörg Nowak
Date: October 06, 2005 09:18AM
Hello,
I try to run "prepared statements" to get some extra performance in my cluster.
I did the following:
1. PREPARE jn_stmt FROM "update a, b set a.TimeStampWaitingSms = 'WWWWWWWWWWWWWWWWWWWWWWWWWWWW', b.associatedBasicServices = 'WWWWWWWWWWWWWWWWWWWWWWWWWWWWW' where b.subScriberNumberId = a.mSubIdentificationNumberId AND a.mSubIdentificationNumberId = '?';";
Query OK, 0 rows affected (0.00 sec)
Statement prepared
2. SET @param="000575";
Query OK, 0 rows affected (0.00 sec)
3. EXECUTE jn_stmt USING @param;
ERROR 1210 (HY000): Incorrect arguments to EXECUTE
I read in documentation the error code:
Error: 1012 SQLSTATE: HY000 (ER_CANT_FIND_SYSTEM_REC)
It's not clear to me what does it mean.
The same statement works fine with this value as "mSubIdentificationNumberId = '000575'" in the where clause.
Are prepared statements not supported by MySQL Cluster ?
What did I wrong ?
Maybe it's not a cluster question but I'm not sure about that.
Joerg Nowak
Subject
Views
Written By
Posted
Prepared stmt in cluster 4.1.14
2139
October 06, 2005 09:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.