<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - SQL... dialog Status: "Commands out of sync" when connecting to MySQL using direct (native) connector"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=103685#c10">Comment # 10</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - SQL... dialog Status: "Commands out of sync" when connecting to MySQL using direct (native) connector"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=103685">bug 103685</a>
from <span class="vcard"><a class="email" href="mailto:robert@familiegrosskopf.de" title="robert@familiegrosskopf.de">robert@familiegrosskopf.de</a>
</span></b>
<pre>(In reply to Julien Nabet from <a href="show_bug.cgi?id=103685#c9">comment #9</a>)
<span class="quote">>
> 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.</span >
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>