Hi Justin,
you just miss the word hsqldb after jdbc: :-)
jdbc:hsqldb:/home/yyy/mydb
Best regards,
Ocke
Justin Gray wrote:
Hi,
I'm trying to use Hsqldb with OpenOffice 1.1.3 on a Linux system and having what appears to be driver connection problems.
The error message I get is more or less "Connection to data source HSQLDB could not be established. The connection to the external data source could not be established. An unknown error occurred. The driver is probably defective".
Depending on a few minor changes I made to the setup, the error messages have varied, most saying simply that the driver could not be found.
My Oo General Tab Data Source setup is as follows:
Name HSQLDB Database Type JDBC Data Source URL jdbc:/home/justin/HsqlDocs
My Oo JDBC Tab Data Source setup is as follows:
JDBC Driver Class org:hsqldb:jdbcDriver URL jdbc:/home/justin/HsqlDocs User Name sa
Oo Tools/Options/Security
Java Class Path /usr/share/java/hsqldb-1.71.jar (I have also tried /usr/share/java/ )
The Oo jvmsetup (Java setup) shows two run-time versions of Java installed on my system, both are the same version (version 1.4.2, I think), just located in two different directories; the first in /usr/java and the second in (if I remember correctly) /usr/lib/java. Everything on the computer is newly installed software and are the latest software versions. Using jvmsetup and changing the installed (location of) Java, does not seem to make any difference. I am assuming that Java is indeed installed correctly and that Oo is just seeing this one program twice, but perhaps I am wrong on this count.
Can anyone offer any suggestions as to why I am not able to connect to Hsqldb? Perhaps my paths are wrong? Do I need to add the word "file:" in any of these set up lines, such as, jdbc:file:/home/justin/HsqlDocs? Or perhaps two // before home in the URL?
My feeling is that the URL is not the problem, but that it is a Class Path issue, or a problem with Java. Do I need to additionally have a Linux path for Java also, or does the Oo Class Path do that for me?
I'm just starting out with Linux which explains some of my questions. I know the newer test versions of Oo now have Hsql as a database however as I am new with Linux, I'd rather stay with very stable software until I know the system a bit better. That's why I am trying to run Hsql with 1.1.3 at this time.
Sorry for the longwinded questions and thanks in advance for listening!
-Justin
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
