[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 #11 from Julien Nabet <serval2412 at yahoo.fr> ---
(In reply to robert from comment #10)
> (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).
Ok
> 
> ExecuteUpdate shouldn't give a resultset. ExecuteQuery (with the same code
> for calling a procedure) should give a resultset.
Depending where we're looking at we can have until 3 functions :
- executeQuery
- execute
- executeUpdate

for Tools/SQL, it's just executeQuery or execute. But the levels below have the
3 ones.
Anyway, I'll try to find a way to obtain the right result.

-- 
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/63edcee3/attachment.html>