Re: Unexpected error when calling stored procedure.
Posted by: John Cuyle
Date: March 03, 2020 06:36PM

* mysql-connector-java-8.0.17

* 8.0.17

* Yes, it does seem to work when executed synchronously. Interesting, the C++ API has no built-in asynchronous support so I threw the synchronous call into a task and forgot about it. Good catch. I just tested this just now and there appears to be an issue with my result parsing code (first time it has been exercised since it's the first time I've had results to exercise it with) so I'll need to do a little more checking to make sure what I'm getting is the same as what I'm getting in the C++ version.

*Yes, the procedure has a SELECT statement as the last statement.

*I get a SqlResult with data present, where the data is the set of rows retrieved by the SELECT statement in the stored procedure.

The stored procedure is minimal (it's essentially a test stored procedure that's a placeholder while developing around it) that has two statements:

UPDATE ... WHERE _id = idParam;
SELECT ... WHERE _id = idParam;

The results I get from the SqlResult in C++ are the same as those that would be displayed in MySQL Workbench. If you're wondering why I have a C++ and Java version, I'm using C++ for fast prototyping. The Java version will eventually be production code.

Options: ReplyQuote

Written By
Re: Unexpected error when calling stored procedure.
March 03, 2020 06:36PM

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.