Andrew Douglas Pitonyak wrote:
(..)
You can not use JDBC to access a document created by OOo because the
HSQLDB stuff is contained inside of an OOo document. What you can do,
however, is write a Java program that accesses OOo and then use that to
manipulate/access the data inside of an OOo Base document.
Your other option is to have OOo reference an external database and then
you can also directly access this data.
It would be nice if there were a JDBC driver to access an OOo Base
document directly.
Hi Andrew and Roger,
thanks for your replies!
So it's a container, which explains everything. :-)
To work around I created a real Hsql database, run the Hsql server in another
task and tried to access it from within OO and the internal JDBC driver.
It basically works: I can browse the database's contents, but not edit any cell.
To see if this was a problem of Hsql's JDBC driver, I started another Java
database, Apache Derby (which also looks very promising) in an own task, added
its JDBC driver JAR file (the small derbyclient.jar) to OO's Java classpath
(Options) and connected to the databse from within OO (re-start needed):
Again it "just" basically works: I can browse the database's contents, but not
edit any cell.
Is it possible at all to edit/add cells to Java databases via JDBC from within
OO?
-ric
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
