Patches item #870303, was opened at 2004-01-04 11:23 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376687&aid=870303&group_id=22866
Category: JBossCMP Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: Joachim Van der Auwera (triathlon98) Assigned to: Nobody/Anonymous (nobody) Summary: automatic database update at deployment, replace #856849 Initial Comment: New option to check the database structure at deployment and update it if possible. For this behaviour, in jbosscmp-jdbc.xml, in defaults, you have to add <alter-table>true</alter-table> It should normally be used in combination with <create-table>true</create-table>. The structure of the database is checked at deployment. The missing fields are added. The string fields have their length adjusted when the new type is longer than the old (numeric fields are not modified for the time being). Fields which are no longer needed are dropped. For relation tables, the code checks whether the definition is correct and logs a warning if not (the code also has the line to drop the table in this case commented out - it may cause a bit too much data loss). The current code has a limitation in that it converts fieldnames to upper case for comparison. This may cause problems for some systems (though, as JBossCMP does not allow quoting of fieldnames at this time, this should be minimal). Compared with the original patch, this one tries to respect coding style as much as possible, not modifying code which is not touched (should make integration a lot easier), and is based on the 3.2.4RC1 CVS snapshot of 2003-12-30. The original patch also deleted way to many fields, was less efficient and tried altering the structure of each field. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376687&aid=870303&group_id=22866 ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
