Richard Pierce wrote:
How do I connect my java applications to open office's database?
I believe I need some kinf of connector>
Hello Richard,
For accuracy I really should say something about ODF v1.2 and the
Database Frontend Document specification..
I'll spare you and assume from your question that you have a physical
file with an .odb extension, that happens to be one of these ODF v1.2
Database Frontend Documents which stores the actual data in the file.
Currently if you must work with these files from an external program
then you have only two roads to take, TTBOMK.
1: You instantiate an instance of open office (headless) and use the api
to work with the HSQLdb database contained in the file. In this case you
would ask the OO.o api to give your java program a connection to the
database, should you want to execute SQL directly from the java
side...at least that is how I understand it.
-or-
2: You extract the HSQLdb database from the file at runtime, start your
own instance of an HSQLdb server and the put the data back into the Base
file when your application is finished.
Otherwise
- if you are starting with Java and you are opting to include Base as
part of your solution for some development progect I would suggest you
look at using a stand alone server pretty much any of your choice. Base
in this context is only an ODF front end file container and includes
just the needed connection data for the shared data source.
Hopefully that helps..
Best wishes,
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
