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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
