Ask Your Question
0

The connection to the data source XYZ could not be established

asked 2019-11-05 11:15:18 +0200

Dennis1234 gravatar image

I did the new database wizard and get this error. I chose all the defaults (two options) and when the database opens I get the above error. The connection to the external data source could not be established. No SDBC driver was found for the url 'sdbc:embedded:hsqldb'.

I did some searching and I have Java installed 11 and it seems to be working.

I'm using Ubuntu 19.10 with LO 6.3.2.2

D

edit retag flag offensive close merge delete

Comments

Hello,

First insure you have the correct Java installed. See -> FAQ.

Then verify settings. From menu Tools->Options under LibreOffice->AdvancedUse a Java runtime environment needs to be selected. Then in the pane below valid installed version(s) will appear (can have multiple). Insure one is selected - dot is in circle in left column. If none appear you may have incorrect Java installed.

Ratslinger gravatar imageRatslinger ( 2019-11-05 17:29:49 +0200 )edit

yes, I already did those items (I saw your response on other post). I also changed to firebird that fixed it. Interesting in that the other was default, HSQLDB. I also found I needed to install HSQLDB or something, that which I did. I can't recall if that fixed it, I'm sure it didn't. I'm just concerned that I had to do all that to even get this to work, fresh clean install of LO base and recent upgrade to Ubuntu 19.10, I've used base years ago and never had to fiddle this much to get it to even work. With using the HSQLDB I was not able to see or use any wizards, the task area was blank. However, if I use firebird, everything seems to work as normal.

Dennis1234 gravatar imageDennis1234 ( 2019-11-05 20:41:54 +0200 )edit

Different LO versions had different default databases. Curently (v6.3.3.x) is HSQLDB. This is mainly due to the number of outstanding Firebird issues and the complexity to get around some of them.

Many different databases you can use do not require Java (with exception of Wizards and Report Builder) - Firebird, MySQL, PostgreSQL and many more.

It is questionable as to what you needed to install (definitely should not be HSQLDB - another could cause problems) since I have been using Base for years without any such problem. Wizards and Report Builder require the installation of a correct JAVA even with Firebird. I suspect you may have this problem if the JAVA situation wasn't resolved.

There is always the possibility of some corruption in the User Profile. A clean install of LO does not renew/replace/refresh this. To clear see -> LibreOffice user profile.

Ratslinger gravatar imageRatslinger ( 2019-11-05 22:41:08 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-11-06 09:19:46 +0200

Alex Thurgood gravatar image

The default installation of LO on Ubuntu does not generally install the required JDBC drivers or Java requirements for Base to function with Java database backends, including the default embedded hsqldb. This is a packaging decision by Ubuntu, not a decision by the LibreOffice project. You need to install these packages separately via the software installer UI, or else do things manually from the command line with apt-get.

edit flag offensive delete link more

Comments

libreoffice-sdbc-hsqldb:amd64 <none> 1:6.3.2-0ubuntu I installed this and it now works. Do I still need to install the JDBC driver? Which Java requirements or Java database backends would I need?

Dennis1234 gravatar imageDennis1234 ( 2019-11-06 11:46:56 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-11-05 11:15:18 +0200

Seen: 98 times

Last updated: Nov 06 '19