LibreOffice Base will not load my odb file. I get an error messge

[Hugh Lupien]

I just upgraded to LTS 20.04. For a data base that worked perfectly under LTS 18.04,afterloading my database NamesU.odb, when I try to open any table, query or Form, I get the error messageI get the message:
"The connection to the data source "NamesU" could not be established.
he connection to the external data source could not be established. No SDBC driver was found for the URL 'sdbc:embedded:hsqldb".

Please help by telling me how to fix this. Thank you,

Hugh Lupien

ProblemType: Bug
DistroRelease: Ubuntu 20.04
Package: ubuntu-release-upgrader-core 1:20.04.18
ProcVersionSignature: Ubuntu 5.4.0-26.30-generic 5.4.30
Uname: Linux 5.4.0-26-generic x86_64
ApportVersion: 2.20.11-0ubuntu27
Architecture: amd64
CasperMD5CheckResult: skip
CrashDB: ubuntu
CurrentDesktop: ubuntu:GNOME
Date: Mon Apr 27 15:01:45 2020
InstallationDate: Installed on 2018-04-30 (727 days ago)
InstallationMedia: Ubuntu 18.04 LTS "Bionic Beaver" - Release amd64 (20180426)
PackageArchitecture: all
ProcEnviron:
 PATH=(custom, no user)
 XDG_RUNTIME_DIR=<set>
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: ubuntu-release-upgrader
Symptom: dist-upgrade
UpgradeStatus: Upgraded to focal on 2020-04-23 (3 days ago)
VarLogDistupgradeTermlog:

[Davide (tarski10)]

You must install hsqldb driver, open a terminal and type:
sudo apt install libreoffice-sdbc-hsqldb.

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Davide (tarski10)]

It should have been installed together with the libreoffice-base package

[Hugh Lupien (hubolu)]

Thank you Davide, I did what you said to install the hsqldb driver and it worked perfectly. Thank you, thank you, thank you!

[Hugh Lupien (hubolu)]

 Thank you Davide. I did the sudo apt install libreoffice-sdbc-hsqldb as you suggested and it worked perfectly. Thank you, thank you, thank you!

    On Monday, June 29, 2020, 4:10:56 PM EDT, Davide <email address hidden> wrote:

 It should have been installed together with the libreoffice-base package

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1875477

Title:
  LibreOffice Base will not load my odb file. I get an error messge

Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  I just upgraded to LTS 20.04. For a data base that worked perfectly under LTS 18.04,afterloading my database NamesU.odb, when I try to open any table, query or Form, I get the error messageI get the message:
  "The connection to the data source "NamesU" could not be established.
  he connection to the external data source could not be established. No SDBC driver was found for the URL 'sdbc:embedded:hsqldb".

  Please help by telling me how to fix this. Thank you,

  Hugh Lupien

  ProblemType: Bug
  DistroRelease: Ubuntu 20.04
  Package: ubuntu-release-upgrader-core 1:20.04.18
  ProcVersionSignature: Ubuntu 5.4.0-26.30-generic 5.4.30
  Uname: Linux 5.4.0-26-generic x86_64
  ApportVersion: 2.20.11-0ubuntu27
  Architecture: amd64
  CasperMD5CheckResult: skip
  CrashDB: ubuntu
  CurrentDesktop: ubuntu:GNOME
  Date: Mon Apr 27 15:01:45 2020
  InstallationDate: Installed on 2018-04-30 (727 days ago)
  InstallationMedia: Ubuntu 18.04 LTS "Bionic Beaver" - Release amd64 (20180426)
  PackageArchitecture: all
  ProcEnviron:
  PATH=(custom, no user)
  XDG_RUNTIME_DIR=<set>
  LANG=en_US.UTF-8
  SHELL=/bin/bash
  SourcePackage: ubuntu-release-upgrader
  Symptom: dist-upgrade
  UpgradeStatus: Upgraded to focal on 2020-04-23 (3 days ago)
  VarLogDistupgradeTermlog:

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1875477/+subscriptions