[Libreoffice-bugs] [Bug 123999] time change causes the return of "parameter index out of range... using mysql and J/connector

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #16 from Christian Lohmaier <cloph at documentfoundation.org> ---
adding comments lost during infra-outage:
https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176623.html
--- Comment #14 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 comment #13)
> 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...

https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176624.html
--- Comment #15 from Julien Nabet ---
(In reply to Lionel Elie Mamane from comment #14)
> ...
> 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.

https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176625.html
--- Comment #16 from Lionel Elie Mamane ---
(In reply to Julien Nabet from comment #15)

> 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 "?".

https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176626.html
--- Comment #17 from Mike Kaganski ---
(In reply to Lionel Elie Mamane from comment #14)
> 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 bug 124022 should be addressed first.

https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176628.html
--- Comment #18 from Julien Nabet ---
(In reply to Mike Kaganski from comment #17)
> ...
> 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 bug 124022 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.

tdf#124022 would be useful indeed but seems more a redesign/refactoring which
needs someone wanting to spend some time on internal mechanism.

-- 
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/20190327/6bb39fd5/attachment-0001.html>