incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan <elderdanle...@gmail.com>
Subject Re: Connecting to a database
Date Fri, 03 Aug 2012 17:59:21 GMT
You are right. I changed the name, and it works. Thanks!

--Dan

Reizinger Zoltán wrote:
> 2012.08.03. 17:03 keltezéssel, Dan írta:
>> Reizinger Zoltán wrote:
>>> 2012.08.03. 15:46 keltezéssel, Dan írta:
>>>>      I have a database located at ~/.openoffice.org/3/user/database/budget-personal/
>>>> that extracted from an embedded Base database. I want to use Base to connect
to this
>>>> database. I know that the Datasource URL is hsqldb:file:/home/<user
>>>> name>/.openoffice.org/3/user/database/budget-personal/. But what do I
enter as the JDBC
>>>> Class? Should there be something entered in Tools > Openoffice.org >
Java > Class Path?
>>>> Is so what?
>>>>      I want to be able to connect to the database files using hsqldb 1.8.
I can do this
>>>> if I use hsqldb 2.2.8. How do I do this using Base?
>>
>>
>>>>
>>>> The Datasource URL:
>>>>         hsqldb:file:/home/<user name>/.openoffice.org/3/user/database/budget-personal/
>>>> The JDBC driver class:     org.hsqldb.jdbc.JDBCDriver
>>>> Class Path: /usr/local/hsqldb-2.2.8/hsqldb/lib/hsqldb.jar
>>>>
>>>> --Dan
>>
>> > Hi Dan,
>> > You can not use simultaneously hsqldb 1.8 and 2.2.x version.
>> > You can add only one hsqldb.jar to the class path, first remove 2.2.8 version,
restart
>> AOO,
>> > add 1.8.
>> >  From AOO add built in hsqldb 1.8 to classes under win7: from c:\Program
>> > Files\OpenOffice.org 3\Basis\program\classes\
>> > or under Linux from
>> > The driver class is same for the both hsqldb version.
>> > If you connected to this file with 2.2.8 version, you can get error message,
it
>> created in
>> > newer version.
>> > Zoltan
>>
>>      I removed 2.2.8 version of hsqldb from the Class Path.
>> Closed AOO.
>> Opened AOO.
>> Tools > Options > Java > Class Path.
>> There are not class paths listed.
>> Add Archive
>> Browsed to /opt/openoffice.org/basis3.4/program/classes/hsqldb.jar
>> Click OK twice.
>> Closed AOO
>> Opened AOO
>> Open the Base Wizard selecting "Connect to an existing database": JDBC.
>> Click Next.
>> Entered the Datasource URL as above.
>> Entered the JDBC driver class: org.hsqldb.jdbc.JDBCDriver

> I missed the wrong driver: org.hsqldb.jdbcDriver is the correct one.
> This will work with 2.2.8, too.
> Zoltan

>> Clicked "Test class".
>> Error message appears: The JDBC driver could not be loaded.
>>
>> What is wrong with these steps? I can follow the very same steps, this time using
the
>> latest version of hsqldb (/usr/local/hsqldb-2.2.8/lib/hsqldb.jar entered in the Class
>> Path). Then instead of an error message, the message tells me that the JDBC driver
was
>> successfully loaded.
>>
>> --Dan
>>

>


---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org


Mime
View raw message