base error - no SDBC drive

users
#1

I don't understand why this is happening. I've never seen it before. I depend on base for a few things, but weeks or even months can go by with my not using it. In recent times, I've installed a number of copies of the Master version of LO. I'm now using this version: 4.3.0.2
Build ID: 14ed55896fdfcb93ff437b85c4f3e1923d2b1409, on Kubuntu Linux 14.04.

When I try to open a table I've use for quite some time, I now get this:

/SQL Status: HY000//
//
//The connection to the external data source could not be established. No SDBC driver was found for the URL 'sdbc:embedded:hsqldb'.//

/What's the best way to respond to this?

t.

#2

Hi :slight_smile:
Have you been able to search the Apache OpenOffice forum for this?

Is the data-source really an external one or is it embedded. The error
message seems confused as to which it is.
Regards from
Tom :slight_smile:

#3

Hi Tom,

Build ID: 14ed55896fdfcb93ff437b85c4f3e1923d2b1409, on Kubuntu Linux 14.04.

Check to see whether all of the LO components are installed. By default,
14.04 doesn't install the Base module and additional components.

Alex

#4

Hi Tom,

I had it turned off, on the premise (read on the LO list a while back)
that if you didn't need it it was likely to cause problems needlessly.
It appears to be need for Base, at least for the hsqldb.

I see that this problem is a recurrent one, at least according to
Google, although it may not be at all due to the issue I found.

Yes, I had assumed that you knew this - my bad (assuming often makes an
"ass" out of "u" and "me") - glad you got it sorted though :slight_smile:

Java is a prerequisite for working with Base, always was (at least with
LO) and will remain to be so for the foreseeable future if you want to
use the built-in reporting module (written in Java). If Java can not be
found, then no SDBC-JDBC bridge can be established.

Alex

#5

Alex,

I've just installed LO Version: 4.2.5.2. On two different boxes I'm getting the same error as before when I try to open a db form or table.

I'm NOT installing from the packages, but from the *.deb download at the LO website. So, your idea no longer makes a lot of sense to me. I've never had this error before, and can't imagine why the download wouldn't be complete.

Any ideas?

I rarely use Base, but when I do it's important, so I do need to get this fixed somehow.

t.

#6

Hi :slight_smile:
Using an external back-end might get around the Java issue. MySql/MariaDb
and Postgresql don't need java do they?

Also the internal HsqlDb back-end is being swapped out to be replaced by
Firebird as the internal back-end. If that does work then maybe the
reliance on Java will be over.
Regards from
Tom :slight_smile:

#7

Using an external back-end might get around the Java issue. MySql/MariaDb
and Postgresql don't need java do they?

No, using an external backend does not get around the Java issue, if you
want to use the built-in Pentaho LO report builder - this is all Java
and requires the Java bridge to be instantiated and working, in other
words, you need to tell LO that you have a JVM somewhere (preferably one
that works with LO too).

Also the internal HsqlDb back-end is being swapped out to be replaced by
Firebird as the internal back-end. If that does work then maybe the
reliance on Java will be over.

That won't make a hoot of a difference until the report builder gets
replaced by a C++ or python alternative.

Alex

#8

Well, nuts.

Problem solved: *

I just needed to go to Settings > LibreOffice > Advanced, and enable my installed Sun java runtime 1.6.0_31.*

I had it turned off, on the premise (read on the LO list a while back) that if you didn't need it it was likely to cause problems needlessly. It appears to be need for Base, at least for the hsqldb.

I see that this problem is a recurrent one, at least according to Google, although it may not be at all due to the issue I found.

t.

#9

Hi :slight_smile:
The 1.6.0_31xx is the old branch of Java and has known issues "out in the
wild".

Oracle keep insisting that people upgrade to their newest version of Java
because all previous ones have been compromised. Often they don't even
release some versions because each one gets compromised so quickly,
sometimes even before the newer one gets released!

In the US their "Homeland Security" issued a warning;
https://www.us-cert.gov/ncas/alerts/TA13-010A
Oracle released another upgrade and claimed to have fixed the problem but
http://www.zdnet.com/homeland-security-warns-java-still-poses-risks-after-security-fix-7000009785/

https://www.java.com/en/download/faq/remove_olderversions.xml
http://www.theguardian.com/technology/askjack/2013/feb/08/java-remove-ask-jack-technology
http://threatpost.com/oracle-java-patch-update-pushes-2013-totals-past-last-year

OpenJDK is one response to all this and works well for almost everything
that needs Java.
http://openjdk.java.net/
It is still owned by Oracle but it does seem to have a proper community in
addition to their regular programmers so it seems quite a lot more secure
and less vulnerable to problems.

Java has almost entirely been written out of LibreOffice but there are
still some things that depend on Java. Accessibility stuff such as
screen-readers are in the process of moving away from Java en-masse. Some
wizards and Extensions probably still use Java.

Oddly i still see a LOT of job adverts for programmers who can write Java.
I'm hoping that is to help companies migrate away or to re-write existing
java packages!

Regards from
Tom :slight_smile:

#10

[snip]

Oddly i still see a LOT of job adverts for programmers who can
write Java. I'm hoping that is to help companies migrate away or to
re-write existing java packages!

[snip]

How sad :frowning:

Java had such great promise. Java was *supposed* to be immune to all
this. Instead, due to the realities of market pressures and the
scourge of poor design and coding, Java has become at least as bad a
word in the I.T. community as ActiveX -- possibly worse.

Plus it's a PITA to code in, has horrible load times, and "write
once, run anywhere" never did become fully real.

It was bad enough under Sun. Now that Oracle owns it, I think it's
doomed.

Regards,
Jim

#11

Hi :slight_smile:
Similarly DocX promises to be cross-platform and able to be used by any
relevant program. So did Rtf. Whenever these things are in the hands of
single profit-making companies they don't seem to live up to promises or
expectations. Ownership through a committee of a large number of
profit-making companies and others seems to make things more stable as long
as it's possible to pull any errant company back in-line if it fails to
implement it as per agreements.
Regards from
Tom :slight_smile: