Hello Mesa,
> I am trying to create / access to OpenOffice 2.0 Base
> from a java program. Here is my program for creating a
> file. It seems like successful because after that I
> can try to access the data from another java program.
> ...
> DriverManager.getConnection("jdbc:hsqldb:file:Test103","sa","");
what this line does is creating a connection to an HSQLDB database,
located in the working directory of the JVM, and named "Test103".
Effectively, a number of files named Test103.* will be created in this
directory.
This, however, is *not* an OpenOffice.org database. OpenOffice.org Base
internally uses the HSQLDB engine to create database, and *wraps* the
files produces by HSQLDB into an own file (with extension .odb).
At the moment, there's no JDBC driver accessing those "embedded" HSQLDB
data, yet, so you cannot access OpenOffice.org Base databases using
JDBC. However, you can access it with SDBC, which is OOo's database
access API (and pretty similar to JDBC in many respects).
Ciao
Frank
--
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Database http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
