Bug 127154 - SDBC driver for existing hsqldb .odb file
Summary: SDBC driver for existing hsqldb .odb file
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.3.0.4 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-08-25 17:49 UTC by ratrace
Modified: 2019-08-26 08:26 UTC (History)
2 users (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 ratrace 2019-08-25 17:49:30 UTC
Description:
I can't open .odb files which i created with hsqldb or create new ones.

Steps to Reproduce:
In a new debian buster installation,

1. apt-get remove libreoffice
2. apt-get remove --purge libreoffice5*
3. apt-get remove --purge libreoffice6*
4. apt-get clean
5. apt-get autoremove
6. apt-get -t buster-backports install libreoffice
7. Open libreoffice
8. File-New-Database
9. Create an hsqldb
10. File can not be created because "The connection to the external data source could not be established. No SDBC driver was found for the URL 'sdbc:embedded:hsqldb'"
11. The same problem arise if i try to open an existing .odb hsqldb file.

Actual Results:
I can't create new or open existing .odb files that were created wiht hsqldb.

Expected Results:
I should be able to see table and forms in existing .odb files that have hsqldb.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
[Information automatically included from LibreOffice]
Locale: el
Module: StartModule
[Information guessed from browser]
OS: Linux (All) Debian buster
OS is 64bit: no

information from Help - About LibreOffice
Version: 6.3.0.4
Build ID: 1:6.3.0-2~bpo10+1
CPU threads: 2; OS: Linux 4.19; UI render: default; VCL: x11; 
Locale: el-GR (el_GR.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 mechtilde 2019-08-25 18:14:18 UTC
can't reproduce it

which packages from libreoffice did you install. You can see them with 

dpkg -l | grep libreoffice
Comment 2 ratrace 2019-08-25 18:23:23 UTC
Unfortunately i removed the libreoffice that i installed from backports and installed the stable release 6.1.5.2, which is working correctly. I can open existing .odb hsqldb files.

If i can find the files that i installed when i installed the backports libreoffice, please tell me what to do.
Comment 3 Julien Nabet 2019-08-26 08:00:20 UTC
if you upgrade to 6.3.0 again, you can try to rename your LO directory profile (see https://wiki.documentfoundation.org/UserProfile#GNU.2FLinux).

BTW, Debian stable is rather for servers. If you use your machine for desktop, you should give a try to Debian testing (which includes LO 6.3.0).

Meanwhile, let's put this one to WFM.
Comment 4 Alex Thurgood 2019-08-26 08:26:36 UTC
Actually, this isn't our bug, but a distrib packaging related one.