Base error message in Base connection to data source not found

asked 2019-04-24 13:23:43 +0200

JE1 gravatar image

When creating a new database, after naming the file (in this instance, New Database Wed 2) and saving, I get this message.

The connection to the data source "New Database Wed 2" could not be established.

The driver class 'org.hsqldb.jdbcDriver' could not be loaded.The additional driver class path is 'vnd.sun.star.expand:$LO_JAVA_DIR/hsqldb.jar vnd.sun.star.expand:$LO_JAVA_DIR/sdbc_hsqldb.jar'.

I have Java 12.0.1 installed and it is selected in Libre Office preferences.

edit retag flag offensive close merge delete

Comments

Hello,

You have not included some primary information - OS & specific LO version. It does appear you may be on a Mac. If so, you must install Oracle JDK and NOT JRE.

Ratslinger gravatar imageRatslinger ( 2019-04-24 17:54:04 +0200 )edit

Apologies. Yes, Mac OS 10.11.6 El Capitan. Libre Office 6.1.5.2. I have already installed Oracle JDK. I presume this is what is showing as Java 12.0.1. in LO preferences (Advanced).

JE1 gravatar imageJE1 ( 2019-04-24 18:37:28 +0200 )edit

@JE1 The confusing issue here is that you see and have a selected version in preferences.

One remote possibility may be the spaces within the name you are creating. You may want to try a name without spaces first.

The only other item I can offer is to install a different Java version. See answer in this post -> Java 8 JRE not found on macOS Mojave 10.14.4.

Have seen in past some reported bug issues with MAC & Java when new versions were released. Unfortunately don't have a MAC to test with.

Ratslinger gravatar imageRatslinger ( 2019-04-25 04:38:44 +0200 )edit

Thanks for your help. I've tried removing the spaces and that doesn't help. I've looked at installing an older version of Java but the company 'strongly advises' against doing this for security reasons. Looks like I'm stumped.

JE1 gravatar imageJE1 ( 2019-04-25 15:22:45 +0200 )edit

@JE1 You could file a report at -> Bugzilla. This may get you further answers.

Also another possibility, but not all that clear on Mac - use a different database. Many databases do not require the use or installation of Java. Firebird (embedded is optional in Base), MySQL, PostgreSQL and more. Now you may not have certain other functions available such as Wizards or the Report Builder but the DB would work.

Ratslinger gravatar imageRatslinger ( 2019-04-25 15:57:50 +0200 )edit

Thanks. Have just done that.

JE1 gravatar imageJE1 ( 2019-04-25 16:06:38 +0200 )edit