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:
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
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
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.
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.
(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