[Libreoffice-bugs] [Bug 103685] SQL... dialog Status: "Commands out of sync" when connecting to MySQL using direct (native) connector

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=103685

--- Comment #10 from robert at familiegrosskopf.de ---
(In reply to Julien Nabet from comment #9)
> 
> I'm not sure to understand, execute and executeUpdate never use resultsets
> or did I miss something?
> If yes, I don't achieve to use getMoreResults/getResultSet/disposeResultSet 
> to throw away rs correctly.

The procedure you are using for the test won't give a resultset in Tools > SQL
or in Query-GUI. But it has an resultset you can fetch through macrocode or if
you call the procedure in MySQL-console (or for example PHPMyAdmin).

ExecuteUpdate shouldn't give a resultset. ExecuteQuery (with the same code for
calling a procedure) should give a resultset.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170922/b9fcf662/attachment.html>