[Libreoffice-bugs] [Bug 120091] New: After upgrading MySQL Connector/J from 5.1.46 to 8.0.11 or 8.0.12, getting error msg "the data could not be loaded"

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 120091
           Summary: After upgrading MySQL Connector/J from 5.1.46 to
                    8.0.11 or 8.0.12, getting error msg "the data could
                    not be loaded"
           Product: LibreOffice
           Version: 5.4.7.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jnplg at outlook.com

Description:
My LO Base form works correctly with MySQL Connector/J 5.1.46 (and earlier). 
I am using MySQL 5.7.23 server.
If I change the connector to the new version of Connector/J (8.0.11 or 8.0.12),
then, when opening the form in Base, I immediately get error msg "the data
could not be loaded".
All my other forms are working correctly with both connector versions.

Steps to Reproduce:
1. import the attached file (Dump20180923) into MySQL. It creates the database
(or schema) testcj8 and loads tables and views.
2. open the attached LO Base file (TestCJ8 on localhost).
3. open the LO Base form (Form-per-Dag).
4. reply "root" as username and password.
5. you get error message "the data could not be loaded"

Actual Results:
5. you get error message "the data could not be loaded" (see attached
screenshot testcj8NOTOK)

Expected Results:
6. go to "Tools", "Options...", "LibreOffice", "advanced", "Class path...",
"Add Archive..." and select "C:\Program Files (x86)\MySQL\Connector J
5.1\mysql-connector-java-5.1.46" instead of "C:\Program Files
(x86)\MySQL\Connector J 8.0\mysql-connector-java-8.0.12"
7. result : the 2nd grid table is correctly filled. see attached screenshot
(testcj8OK)


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 6.0.6.2 (x64)
Build ID: 0c292870b25a325b5ed35f6b45599d2ea4458e77
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: nl-BE (en_US); Calc: group

-- 
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/20180923/55badc3a/attachment.html>