To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62160 Issue #:|62160 Summary:|Foreign Key Constraints not recognized Component:|Database access Version:|OOo 2.0.1 Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|atjensen
------- Additional comments from [EMAIL PROTECTED] Thu Feb 16 08:18:30 -0800 2006 ------- Using the java connector 3.1.12 (and 5.0 beta) for mySQL with the option overrideSupportsIntegrityEnhancementFacility set to true in the connection URL, Base will now open the relationship window. Base does not however, recognize existing foreign key constraints in the selected schema. This was tested with a MySQL 5.0.18 server running as a Windows service. InnoDB as the default engine and the following options: STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION The URL string used to make the connection was: jdbc:mysql://localhost/openoffice?overrideSupportsIntegrityEnhancementFacility=TRUE This was tested using the 2.0.1 release and the dev. build 156 binaries, there was no difference between the two. For test tables I used the Base supplied table definitions for employees, departments, and employeetasks. The foreign key constraints where created first in Base using the relationship windows 'Insert>New Relation...' dialog. The UI shows the relationship after completion. The MySQL Administrator application shows that they are successfully created. When the relationship window opened again, after closing it, the line connecting the related tables is no longer displayed. The same is true if the constraints where created by the MySQL Admin tool prior to the Base file being opened. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
