The form was created only minutes previously. I just encountered this message with an LO Base form which uses a MariaDB installation on Windows 10, using a JDBC connection with the mysql-connector-java-8.0.28.jar connector. Such statements should be avoided as they are clearly very difficult to prove except with rigorous analysis of all other situations, which is clear was not done and in practical terms cannot be done. This is NOT (as per chosen answer) "specific to distributions like Linux Mint that install LibreOffice Base by default". In the text box (as in the screenshot above). We need to have just ucanaccess:///home/gord/Documents/Database1.accdb Then apparently Base will try to use jdbc:jdbc:ucanaccess:///home/gord/Documents/Database1.accdbĪnd that won't work.
So if the textbox contains jdbc:ucanaccess:///home/gord/Documents/Database1.accdb When Base opens, chooseĪnd notice that the "Database URL" text box has "jdbc:" in front of it. It looks like the setup instructions on Ask Ubuntu may need to be tweaked. I was able to reproduce your issue with LibreOffice 6.4.6.2 on Xubuntu 20.04. For Linux Mint that would be sudo apt remove libhsqldb1.8.0-java To fix that, remove LibreOffice's copy of HSQLDB. Presumably in order to enable embedded HSQLDB databases they also install a rather old version of HSQLDB which conflicts with UCanAccess. I hope some of you may find this information to be of use.It appears that this issue is specific to distributions like Linux Mint that install LibreOffice Base by default. I now have a “testing” environment and will explore the functionality, step by step. Here I was able to create a new “embedded database” without any problems.
In version 6.2.0 Firebird becomes the default embedded database. 6.2.0 RC1) from “ ” (lots of individual debs to install - in the correct sequence of course!). Then I installed the latest testing version of LibreOffice (i.e. I spun up a Virtualbox VM for Ubuntu-Mate 18.10. I have not been able find a solution on the internet. The “graphical way” did not work for me, I could not establish a connection to the database, the error message pointed to a failed “firebird sdbc connection”. In the actual stable version of LibreOffice 6.0.7 (my Ubuntu-Mate 18.04 installation has version 6.0.6.2) you are supposed to be able to “try out” the new Base-with-integrated-Firebird database.
0 kommentar(er)
