<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Nested Queries using MySQL(JDBC) fail" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123879#c9">Comment # 9</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Nested Queries using MySQL(JDBC) fail" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123879">bug 123879</a> from <a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> Alex Thurgood</a> <pre>(In reply to Alex Thurgood from <a href="show_bug.cgi?id=123879#c8">comment #8</a>) > (In reply to tim from <a href="show_bug.cgi?id=123879#c5">comment #5</a>) > > If you use the mysql JDBC connector driver instead of the mariadb jdbc > connector, this would be string to enter instead of "org.mariadb.jdbc.Driver" In LO6.1, this can be set either when you configure a new database connection using a MySQL(JDBC) connection (via the wizard), or else, with the ODB already open, menu Edit > Databases > Properties > Additional Properties tab, and entering the class string com.mysql.jdbc.Driver instead of the one you have. You can then test that the class loads correctly with the test button. Save your ODB file, close it and restart LO for the changes to take effect.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>