Hi,
Thanks for pointing me in the right direction. I
thought that I can use Java to access the databases
(eg. Microsoft Access, mysql, hsql, etc.), since the
database engine is using hsqldb.
thanks & rgds,
--- Frank Schönheit - Sun Microsystems Germany
<[EMAIL PROTECTED]> wrote:
> 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]
>
>
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
