Ludovic, Thanks for the Mysql port. Can you specify your MySQL environment? Like version, etc. I would hope you can use MySQL 5.0 and above where many new features are available.
I checked your tables.sql. You do not use InnoDB option. Without that, the foreign key constraints can not be enforced. (The reverse engineered tables have InnoDB turned on) For an enterprise class application, I would prefer to have data integrity enforced as much as possible. As you may have found, many foreign keys are lacking in current tables.sql. We will need to improve that part of modeling, if you agree with me on the InnoDB option. Also we need to find a better way to populate the initial data set, particularly tmc_user_data.sql and tmc_instance_data.sql. Other apps have used an URL (like install.jsp) to envoke the initialization. This way we do not have to use sql files to populate them. What's your thought on this? Steve Lihn -----Original Message----- From: Ludovic Maitre [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 4:16 PM To: [email protected] Subject: [Patch] MySql Configuration files Hi all, The attached patch contains the following modifications: - in file file db.properties : add declaration of store procs and prepared statements to use with MySQL. There is perhaps better places than this file to put this (or we should keep separate copies for oracle and mysql: here this is just to see if this work). - in file lokahi.properties: - add 3 properties for the support of multiples types of databases. There is : lokahi.broker.implementation: the name of the class of broker to use lokahi.broker.autocommit: should we use commit after database calls (oracle) or no (mysql) lokahi.broker.type: type of broker, used to indicate which method to call in AdminBean. I have initially implemented it by a comparison on the class but perhaps it is better to do the comparison on a string/property (adminbean will be in next patches). - correct the property wap.function.HostingPool (there was an unexpected break of the value in 2 lines) Best regards, -- Cordialement, Ludo - http://www.ubik-products.com --- "L'amour pour principe et l'ordre pour base; le progres pour but" (A.Comte) ------------------------------------------------------------------------------ Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station, New Jersey, USA 08889), and/or its affiliates (which may be known outside the United States as Merck Frosst, Merck Sharp & Dohme or MSD and in Japan, as Banyu - direct contact information for affiliates is available at http://www.merck.com/contact/contacts.html) that may be confidential, proprietary copyrighted and/or legally privileged. It is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please notify us immediately by reply e-mail and then delete it from your system. ------------------------------------------------------------------------------
