Hi Drew,
thanks for the report. It seems that the implementation of our mysql
driver has problems to create the relation and afterwards that the
databasemetadata doesn't know anything about the fkeys created. We have
to investigate it. Could please submit two issues, may be one of them is
not ours.
Best regards,
Ocke
Andrew Jensen wrote:
I thought I would ask about this here first.
Everything that follows holds for both 2.0.1 and dev. build 156 using
the MySQl java connectors 3.1.12 and 5.0beta.
MySQL has added the following option to the Java connector 3.1.12 and 5.0
overrideSupportsIntegrityEnhancementFacility
This was specifically so that OpenOffice could use the relationship
editor.
I have been testing this with the following results.
First - with the option set such as:
jdbc:mysql://localhost/openoffice?overrideSupportsIntegrityEnhancementFacility=TRUE
the relationship editor will open.
I can add tables to the window.
If I attempt to create a relationship by dragging a column in one
table to a column of a different table then a SQL syntax error is
generated. OO.o gets confused on this, as aparantly the error happens
at the server and OO.o believes it was created. You can not remove the
line between the two tables you must close the window without saving
to remove it.
If I create a relationship by selecting the menu Insert>New
relation... then the foreign key relationship is created successfully.
The relationship window displays the line and all is well. Checking
the MySQL server it also shows that the FK constraint was created
successfully.
If I save the relationship window and then reopen it, the tables will
return but all UI representations of the FK constraints are missing.
If I open the table editor in OO.o for the effected tables and check
on any indexes, it does pick up the index that is created for the FK.
Anyway, that is it for now. Not sure if I should open one or two
issues on any of this (one for the SQL syntax errror, and one for the
loss of the relationship lines on reopen ) or just let you know here..
Thanks
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Sachsenfeld 4 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Example isn't another way to teach,
it is the only way to teach.
Albert Einstein
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
