Skip to Content.
Sympa Menu

grouper-dev - new ddl management

Subject: Grouper Developers Forum

List archive

new ddl management

Chronological Thread 
  • From: Chris Hyzer <>
  • To: "" <>
  • Subject: new ddl management
  • Date: Sun, 27 Jul 2008 03:47:44 -0400
  • Accept-language: en-US
  • Acceptlanguage: en-US



I wrapped this enhancement up.  Here are some advantages:


- Don’t want to have to xml export / import on upgrades that require ddl changes

- Will do ddl diffs easily (e.g. if you accidentally drop a column, it will be detected)

- Some things hibernate schemaexport wont do (e.g. multiple indexes on the same columns, foreign keys)

- Can mix ddl with sql (e.g. to remove the id cols)

- Can have custom (not ddlutils generated) ddl/sql for particular databases easily


It is unit tested and all unit tests work, though I wouldn’t be surprised to see issues arise, please let me know asap.  In oracle (and maybe other non-mysql dbs), ddlutils has issues with unique constraints (not indexes), so some foreign keys don’t work.  When I remove the ID cols (next step), the UUIds will be primary keys, so most of those issues will go away, and the others can be solved with custom sql I think…


The next time you upgrade, follow the change log step:


2008/07/27: v1.4 HEAD: DDL management changed.

   - Copy the DDL section from the into your, configure them

   - Add the jar to lib dir: ant-1.7.1.jar

   - run: ant schemaexport to sync everything up (or generate the script to sync everything up, depending on

   - Remove any schema-export.sql files




  • new ddl management, Chris Hyzer, 07/27/2008

Archive powered by MHonArc 2.6.16.

Top of Page