Bug #74476 Command out of sync issue
Submitted: 21 Oct 2014 9:23 Modified: 18 Feb 2016 14:19
Reporter: Yu Zhang Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / C++ Documentation Severity:S1 (Critical)
Version: OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[21 Oct 2014 9:23] Yu Zhang
Description:
In Scenario 3: Using a Statement for a Stored Procedure That Returns a Result Set.

Running the SQL as shown in the examples will depict the following error:

"Commands out of sync; you can't run this command now"

MySQL version adopted is : 5.74. Please help to check whether it is a bug. Thanks!

How to repeat:
Follow the instructions from descriptions will reporduce the issue.
[8 Feb 2016 11:55] Chiranjeevi Battula
Hello  Zhang Yu,

Thank you for the bug report.
Verified as described on MySQL Connector / C++ 1.1.7 version.

Thanks,
Chiranjeevi.
[8 Feb 2016 11:56] Chiranjeevi Battula
Error message:
chiran@chiran-VirtualBox:~$ g++ -o test -I/usr/local/include -I/usr/local/include/cppconn test.cpp -L/usr/lib -lmysqlcppconn
chiran@chiran-VirtualBox:~Chiran/74476$ ./test
Connector/C++ tutorial framework...

# ERR: SQLException in test.cpp(main) on line 52
# ERR: Commands out of sync; you can't run this command now (MySQL error code: 2014, SQLState: HY000 )
chiran@chiran-VirtualBox:~Chiran/74476$
[18 Feb 2016 14:19] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.

Fixed the code example at
http://dev.mysql.com/doc/connector-cpp/en/connector-cpp-tutorials-stored-routines-prepared...
with fixed code from Luís Silva.