Hi Richard,
> Is it possible at all to edit/add cells to Java databases via JDBC
> from within OO?
It works for me. Have you got a primary key on the table you're trying
to edit?
Roger
Richard Ivarson wrote:
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
--
----------------------------------------
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]
