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]
