Bug 137951 - Base : connection to embedded HSQLDB impossible-FILEOPEN
Summary: Base : connection to embedded HSQLDB impossible-FILEOPEN
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.0.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-11-02 21:15 UTC by J-Paul
Modified: 2020-11-05 20:18 UTC (History)
0 users

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 J-Paul 2020-11-02 21:15:29 UTC
Ubuntu 20.10 64 bits, GNOME
French
I try only to create a new database with LO Base using the default HSQLDB system.

I create a new database choosing the first option : embedded HSQLDB 
When I try to select the tables to create one, I get an error :
/build/libreoffice-pLFcgN/libreoffice-7.0.2/connectivity/source/-commmontools/dbexception.cxx:399

The problem is the same with Ubuntu 20.04 (LO 6.4) but this problem doesn't exist with Ubuntu 18.04 (LO 6.0.7.3)
Comment 1 Alex Thurgood 2020-11-03 07:37:59 UTC
@J-Paul : 

instead of using the Ubuntu supplied packets, can you reproduce the problem using the TDF provided packets ?

You will need to purge your installation of all of the existing LO Ubuntu provided packets.

I am pretty certain that this is an Ubuntu packaging problem, and not a LibreOffice one. Unfortunately, this is an all too common experience.

Setting to NEEDINFO, but I would hasard a guess at this not being a LO bug.
Comment 2 Alex Thurgood 2020-11-03 07:42:35 UTC
Please indicate from where you downloaded the 7.0.2 packages or the repository name.
Comment 3 J-Paul 2020-11-03 07:52:11 UTC
It is the packages provided by the distribution version 1:7.0.2-0ubuntu1
It is not the snap one

I don't want to uninstall this version to get native one with maybe other problems. I can manage with a VM of Ubuntu 18.04.
But I will tell this bug in Launchpad.
Thanks.
Comment 4 Rene Engelhard 2020-11-05 20:18:00 UTC
@Alex: for the record this got "broken"

commit 3ad137e2bd6eb796b96f8f63ab01a2c3065483d1
Author: Rene Engelhard <rene@debian.org>
Date:   Wed Feb 20 17:32:56 2019 +0100

    move -sdbc-hsqldb from Recommends to Suggests given LO now defaults to firebird and there's a hsqldb->firebird migration running

as Suggests is not installed per default where Recommends are (and who installs without recommends should know what they do.)

This happens if you flip such stuff back-and-forth which happened with hsqldb. (and the above was forgotten to be reverted.)

Will readd it as Recommends for the Debian packages. (which Ubuntu then needs to sync.)