Bug Hunting Session
Bug 125882 - Oracle OpenJDK 12 and HSQLDB embedded ODB file fail to work together
Summary: Oracle OpenJDK 12 and HSQLDB embedded ODB file fail to work together
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.1.5.2 release
Hardware: All Mac OS X (All)
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-06-12 12:40 UTC by Alex Thurgood
Modified: 2019-06-12 15:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Alex Thurgood 2019-06-12 12:40:55 UTC
Description:
1) Install Oracle OpenJDK 12

2) Start LO, choose JDK12 under Tools > Options > Advanced (Preferences > Advanced for Mac users) and apply setting

3) Try to load an ODB file into a running instance of LO

5) Click on Tables icon

4) Error message : 
La classe de pilote 'org.hsqldb.jdbcDriver' n'a pas pu être chargée.Le chemin de classe du pilote supplémentaire est 'vnd.sun.star.expand:$LO_JAVA_DIR/hsqldb.jar vnd.sun.star.expand:$LO_JAVA_DIR/sdbc_hsqldb.jar'.

5) Click on OK

6) No tables can be loaded.

7 Shut down LO, and physically remove the JDK12 from the file system

8) Restart LO, via Options > Advanced, choose a lower version number of JDK

9) Reload ODB file, everything works as expected.

Steps to Reproduce:
See above

Actual Results:
No tables can be loaded.

Expected Results:
LO should interract correctly with the latest GA version of OpenJDK Java available.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Comment 1 Alex Thurgood 2019-06-12 12:43:41 UTC
Also reproduced in 

Version: 6.2.2.2
Build ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d
Threads CPU : 4; OS : Mac OS X 10.14.5; UI Render : par défaut; VCL: osx; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded
Comment 2 Alex Thurgood 2019-06-12 12:46:48 UTC
The tables will load without error in 

Version: 6.3.0.0.alpha0+
Build ID: 03a2f3ec4316a3953c2fa40e6e59c2ebbc824d09
CPU threads: 4; OS: Mac OS X 10.14.5; UI render: default; VCL: osx; 
Locale: fr-FR (fr_FR.UTF-8); UI-Language: en-US
Calc: threaded
Comment 3 Alex Thurgood 2019-06-12 13:06:43 UTC
Testing with :

Version: 6.2.4.2
Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64
CPU threads: 4; OS: Mac OS X 10.14.5; UI render: default; VCL: osx; 
Locale: fr-FR (fr_FR.UTF-8); UI-Language: en-US
Calc: threaded

No error message is displayed, however, no tables are shown either...

Setting to NEW as this has been confirmed separately on the user mailing list.
Comment 4 Stephan Bergmann 2019-06-12 14:11:22 UTC
The error message is fixed with <https://gerrit.libreoffice.org/plugins/gitiles/core/+/bfdae9412f6dfbbf961d462debeab392abe447f9%5E%21> "Avoid calling java.lang.Class.newInstance()" first appearing in LO 6.2.4.  (The error message box has a "More" button that brings up an "Error Details" dialog.  It lists multiple errors, the last one should have a description

  Error code: -1

  java.lang.NullPointerException

.)  LO 6.1 is EOL (<https://wiki.documentfoundation.org/ReleasePlan/6.1>), so no backporting.

However, according to comment 3 "no tables are shown" in LO 6.2.4 while they presumably are shown in LO 6.3 according to comment 2.  Alex, please check whether tables /are/ shown in LO 6.2.4 when using an older JRE.  If they are not, that's presumably a different bug, so please file an additional issue and we'll close this one as fixed.  If they are, then lets investigate further here.
Comment 5 Alex Thurgood 2019-06-12 15:27:54 UTC
(In reply to Stephan Bergmann from comment #4)
> The error message is fixed with
> <https://gerrit.libreoffice.org/plugins/gitiles/core/+/
> bfdae9412f6dfbbf961d462debeab392abe447f9%5E%21> "Avoid calling
> java.lang.Class.newInstance()" first appearing in LO 6.2.4.  (The error
> message box has a "More" button that brings up an "Error Details" dialog. 
> It lists multiple errors, the last one should have a description
> 
>   Error code: -1
> 
>   java.lang.NullPointerException


That's the one, spot on.

> 
> .)  LO 6.1 is EOL (<https://wiki.documentfoundation.org/ReleasePlan/6.1>),
> so no backporting.

Thanks Stephan, I kind of guessed as much, but I thought it might be a good idea to document it anyway, so that people can understand, where we are with this.

> 
> However, according to comment 3 "no tables are shown" in LO 6.2.4 while they
> presumably are shown in LO 6.3 according to comment 2.  Alex, please check
> whether tables /are/ shown in LO 6.2.4 when using an older JRE.  If they are
> not, that's presumably a different bug, so please file an additional issue
> and we'll close this one as fixed.  If they are, then lets investigate
> further here.

Indeed, I deleted JDK 12.01 and repeated the steps with JDK11, no tables in 6.2.4, and indeed I can reproduce the no tables issue all the way back to 
Version: 6.2.1.2
Build ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71
Threads CPU : 4; OS : Mac OS X 10.14.5; UI Render : par défaut; VCL: osx; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

so will open a different report for that (or check for DUP).

Closing this as RESOLVED FIXED