Hi Ric,
The .odb file is a zip of the HSQLDB database and OOo forms & queries.
If you extract the 'database' directory from the zip you should be able
to access it directly with the hsqldb jdbc driver.
I believe that OOo uses some sort of I/O stream wrapper around the stock
JDBC driver to get it to read and write from a .odb file. Unfortunately,
this is a combination of C++ and Java and can't be reused easily. I'm
not aware of anybody who has written a pure Java version.
Roger
R.Ivarson wrote:
Hi,
from within a Java program I'd like to access (read/write) a HsqlDB
database file which has been created within Openoffice 2.0 (OO).
Is this possible?
One should think so, because OO uses HsqlDB "internally" (I read), but
so far I fail miserably...
Say, I created the database with OO and it's stored at:
C:/Db/Name.odb
Now when I use the standalone HsqlDB's database-manager (or any other
Java databse tool) to open this database, I enter the following JDCB URL:
jdbc:hsqldb:file:C/Db/Name.odb
However, the standalone Java HsqlDB then thinks this databse doesn't
exist and creates own database files, like:
c:/Db/Name.odb.properties
and so on.
Looks like it expects all these files to be there but somehow they're
"inside" the Name.odb?
What am I missing, please?
Thanks a lot, and have a nice weekend!
-ric
--
----------------------------------------
Ninth Avenue Software
p: +61 7 3870 8494 (UTC +10)
f: +61 7 3870 8491
w: http://www.ninthavenue.com.au
e: [EMAIL PROTECTED]
----------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
