incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Reizinger Zoltán <zreizin...@hdsnet.hu>
Subject Re: Connecting to a database
Date Fri, 03 Aug 2012 17:17:52 GMT
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
>
>
>


---------------------------------------------------------------------
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