January 17, 2014

Upgrading to LibreOffice 4.1 on Ubuntu - Missing hsqldb.jdbcDriver

I've been really enjoying Ubuntu on this old Dell laptop for awhile now.  One thing I ran across was not being able to open MS Publisher documents with the default LibreOffice 3 that was installed.  Doing a little research, that functionality was added to LibreOffice 4, so I decided to upgrade.

Best I could tell, the proper way to proceed was to use the Software Center to uninstall version 3.  Then I found this article on installing LibreOffice 4.1 from the PPA.  After installing with sudo apt-get install libreoffice, I tried out LibreOffice Base.

I created a new database and tried to open it.  Uh-oh, I got this error:
The connection to the data source "SampleDatabase" could not be established.
and
The driver class 'org.hsqldb.jdbcDriver' could not be loaded.

Now what to do?  I went back into the Software Center and looked at LibreOffice Base and there were several optional add-ons for a variety of database drivers.  Select every one available and updated.   Nope, still not working.

Somehow installing from the PPA is not linking correctly so the hsqldb.jdbcDriver can be found.  Doing some more research I found another reference to exactly just that topic on the LibreOffice forum:  Upgraded to LO 4.1.0.4 now get 'connection to data source' error

Reading through that showed me how to install that specific driver with this:
sudo apt-get install libhsqldb-java

(Side note: I did not need to remove the old symbolic link and create a new one as mentioned in the post by dtmonterrey).

Bingo!  LibreOffice Base now opens my new database and I can connect to create and edit tables.