Questions tagged [ddlutils]

Apache DdlUtils is an apache utility which can generate database DDL for multiple databases from a common XML format. Examples of target databases might be PostgreSQL, HSqlDB or Oracle.

An XML definition for a simple database might look like:

<?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database.dtd">
<database name="stackoverflow">
  <table name="question">
    <column name="question_id"
            type="VARCHAR"
            size="40"
            primaryKey="true"
            required="true"/>
    <column name="title"
            type="VARCHAR"
            size="50"
            required="true"/>
    <column name="user_id"
            type="INTEGER"
            required="true"/>
    <column name="question"
            type="VARCHAR"
            size="255"
            required="true"/>
  </table>

  <table name="answers">
    <column name="answer_id"
            type="INTEGER"
            required="true"
            primaryKey="true"
            autoIncrement="true"/>
    <column name="question_id"
            type="VARCHAR"
            size="40"
            required="true"/>
    <column name="user_id"
            type="INTEGER"
            required="true"/>
    <column name="markdown"
            type="VARCHAR"
            size="255"
            defaultValue=""
            required="true"/>

    <foreign-key foreignTable="question">
      <reference local="question_id" foreign="question_id"/>
    </foreign-key>  

    <index name="user_id_idx">
      <index-column name="user_id"/>
    </index>
  </table>
</database>

DdlUtils includes integration with Ant for:

• Generating database DDL from a supplied XML file (model)
• Generating the DdlUtils XML model from an existing database.

Useful links:

• http://db.apache.org/ddlutils
• http://db.apache.org/ddlutils/ant/