<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - 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""
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120091">120091</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>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"
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.7.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>jnplg@outlook.com
</td>
</tr></table>
<p>
<div>
<pre>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</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>