Hi,
some issues has been raised using the proposal of Van fro issues 1634.
Van proposed to replace the following statement that is in
latest_update.sql:
INSERT INTO LOOKUP_VALUE(LOOKUP_ID,ENTITY_ID,LOOKUP_NAME) VALUES(190,74,'
');
with one like the following ones embedded in the Java code ( I guess in the
initialize):
INSERT INTO LOOKUP_VALUE(LOOKUP_ID,ENTITY_ID,LOOKUP_NAME) VALUES(<dynamic
unique value>,74,' ');
The concerns were mainly on <dynamic unique value>: how to generate it? A
clean way is to have a sequence on the ID of the table, but this requires
to review the code.
Van: what is your idea on the mechanism that should generate the <dynamic
unique value> and what your idea on where to put the Java code
(ApplicationInitializer class?)
Best Regards
"Van
Mittal-Henkle"
<[EMAIL PROTECTED] To
ndation.org> "Developer"
Sent by: <[EMAIL PROTECTED]
mifos-developer-b net>
[EMAIL PROTECTED] cc
ceforge.net
Subject
[Mifos-developer] Database upgrades
03/06/2008 02:00 using Java
AM
Please respond to
Developer
<mifos-developer@
lists.sourceforge
.net>
Questions surrounding Java based database upgrades have come up a number
of times, so I have taken a stab at adding some initial documentation
about when to do a Java based upgrade rather than a SQL based upgrade
and what basic steps should be followed.
http://www.mifos.org/developers/technical-orientation/mifos-database-dev
elopment#how-to-properly-script
http://mifos.org/developers/wiki/HowToDoJavaBasedDatabaseUpgrades
Questions and suggestions for improvement are welcomed :-)
--Van
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
