On 9/27/06, Lihn, Steve <[EMAIL PROTECTED]> wrote:
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.
Let's not add foreign key constraints now, we'll end up adding new
bugs. The application functions fine with out them.
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?
Nice idea for a feature, however I had more of a complete database
install, from start to finish, including the inital setup in mind.
Steve
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.
------------------------------------------------------------------------------
