<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - time change causes the return of "parameter index out of range... using mysql and J/connector" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123999#c16">Comment # 16</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - time change causes the return of "parameter index out of range... using mysql and J/connector" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123999">bug 123999</a> from <a class="email" href="mailto:cloph@documentfoundation.org" title="Christian Lohmaier <cloph@documentfoundation.org>"> Christian Lohmaier</a> <pre>adding comments lost during infra-outage: <a href="https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176623.html">https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176623.html</a> --- <a href="show_bug.cgi?id=123999#c14">Comment #14</a> from Lionel Elie Mamane --- If I understand well, all this is with the "MySQL (JDBC)" connection type, not the JDBC connection type. (In reply to Julien Nabet from <a href="show_bug.cgi?id=123999#c13">comment #13</a>) > Lionel: any thoughts about this patch? Does it seem the right lead or would > you prefer I provide a bt from this location to understand the full > mechanism? This looks like a LibreOffice-wide default. The right fix should probably be in the MySQL-JDBC specific defaults, in connectivity/registry/mysql_jdbc/org/openoffice/Office/DataAccess/Drivers.xcu In the "<node oor:name="sdbc:mysql:jdbc:*" oor:op="replace">" Properties part, it should give the correct value for ParameterNameSubstitution, that is "true". It seems it doesn't. As usual, this will solve it only for new files... <a href="https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176624.html">https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176624.html</a> --- <a href="show_bug.cgi?id=123999#c15">Comment #15</a> from Julien Nabet --- (In reply to Lionel Elie Mamane from <a href="show_bug.cgi?id=123999#c14">comment #14</a>) > ... > This looks like a LibreOffice-wide default. The right fix should probably be > in the MySQL-JDBC specific defaults, in > connectivity/registry/mysql_jdbc/org/openoffice/Office/DataAccess/Drivers.xcu > ... I thought about this after having commented but I just wonder in which case this option should be put to false. Anyway, I'll be able to propose a patch after my day time job. <a href="https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176625.html">https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176625.html</a> --- <a href="show_bug.cgi?id=123999#c16">Comment #16</a> from Lionel Elie Mamane --- (In reply to Julien Nabet from <a href="show_bug.cgi?id=123999#c15">comment #15</a>) > I thought about this after having commented but I just wonder in which case > this option should be put to false. Databases (or drivers) that support the :named_parameter syntax, as opposed to only the unnamed parameter syntax with "?". <a href="https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176626.html">https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176626.html</a> --- <a href="show_bug.cgi?id=123999#c17">Comment #17</a> from Mike Kaganski --- (In reply to Lionel Elie Mamane from <a href="show_bug.cgi?id=123999#c14">comment #14</a>) > This looks like a LibreOffice-wide default. The right fix should probably be > in the MySQL-JDBC specific defaults, in > connectivity/registry/mysql_jdbc/org/openoffice/Office/DataAccess/Drivers.xcu > > In the "<node oor:name="sdbc:mysql:jdbc:*" oor:op="replace">" Properties > part, it should give the correct value for ParameterNameSubstitution, that > is "true". It seems it doesn't. > > As usual, this will solve it only for new files... Please note that we have some issues, so that different defaults are used at different levels of execution, which makes strange results when a driver-specific default does not correspond to global defaults, like in bug 121092. I'm afraid <a class="bz_bug_link bz_status_NEW " title="NEW - Unhardcode different driver default settings" href="show_bug.cgi?id=124022">bug 124022</a> should be addressed first. <a href="https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176628.html">https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176628.html</a> --- <a href="show_bug.cgi?id=123999#c18">Comment #18</a> from Julien Nabet --- (In reply to Mike Kaganski from <a href="show_bug.cgi?id=123999#c17">comment #17</a>) > ... > Please note that we have some issues, so that different defaults are used at > different levels of execution, which makes strange results when a > driver-specific default does not correspond to global defaults, like in bug > 121092. I'm afraid <a class="bz_bug_link bz_status_NEW " title="NEW - Unhardcode different driver default settings" href="show_bug.cgi?id=124022">bug 124022</a> should be addressed first. Let's see the coming patch on connectivity/registry/mysql_jdbc/org/openoffice/Office/DataAccess/Drivers.xcu like quick bandaid fix. <a class="bz_bug_link bz_status_NEW " title="NEW - Unhardcode different driver default settings" href="show_bug.cgi?id=124022">tdf#124022</a> would be useful indeed but seems more a redesign/refactoring which needs someone wanting to spend some time on internal mechanism.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>