db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From to...@apache.org
Subject svn commit: r479070 [1/2] - in /db/ddlutils/trunk: ./ src/doc/src/documentation/content/xdocs/ src/doc/src/documentation/content/xdocs/databases/ src/java/org/apache/ddlutils/platform/mssql/ src/java/org/apache/ddlutils/platform/oracle/ src/java/org/ap...
Date Sat, 25 Nov 2006 02:25:36 GMT
Author: tomdz
Date: Fri Nov 24 18:25:35 2006
New Revision: 479070

URL: http://svn.apache.org/viewvc?view=rev&rev=479070
Log:
Finished updating the database support doc
Removed ToDo doc
Removed unnecessary platforminfo configuration calls from the platforms

Added:
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/axion.xml
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/db2.xml
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/derby.xml
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/firebird.xml
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/hsqldb.xml
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/interbase.xml
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/maxdb.xml
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/mckoi.xml
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/mysql.xml
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/oracle.xml
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/postgresql.xml
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/sqlserver.xml
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/sybase.xml
Removed:
    db/ddlutils/trunk/ToDo.txt
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/to-do.xml
Modified:
    db/ddlutils/trunk/build.xml
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/site.xml
    db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/mssql/MSSqlPlatform.java
    db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/oracle/Oracle8Platform.java
    db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java
    db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/sybase/SybasePlatform.java

Modified: db/ddlutils/trunk/build.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/build.xml?view=diff&rev=479070&r1=479069&r2=479070
==============================================================================
--- db/ddlutils/trunk/build.xml (original)
+++ db/ddlutils/trunk/build.xml Fri Nov 24 18:25:35 2006
@@ -105,12 +105,10 @@
     <copy todir="${build.doc.dir}">
       <fileset dir="${src.doc.dir}"/>
     </copy>
-  	<!-- We're copying the contents of the ToDo.txt and ReleaseNotes.txt into
-  	     the corresponding documentation source files, otherwise we would loose the
-  	     menu when the user clicks on the corresponding menu entries -->
-    <loadfile property="todo.content" srcfile="${basedir}/ToDo.txt"/>
+  	<!-- We're copying the contents of the ReleaseNotes.txt into
+  	     the corresponding documentation source file, otherwise we would loose the
+  	     menu when the user clicks on the corresponding menu entry -->
     <loadfile property="release-notes.content" srcfile="${basedir}/ReleaseNotes.txt"/>
-    <replace file="${build.doc.dir}/src/documentation/content/xdocs/to-do.xml" token="@@content@@" value="${todo.content}"/>
     <replace file="${build.doc.dir}/src/documentation/content/xdocs/release-notes.xml" token="@@content@@" value="${release-notes.content}"/>
 
     <!-- Copy generated javadoc into the forrest structure in the temporary directory -->

Added: db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/axion.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/axion.xml?view=auto&rev=479070
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/axion.xml (added)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/axion.xml Fri Nov 24 18:25:35 2006
@@ -0,0 +1,262 @@
+<?xml version="1.0" encoding="ISO-8859-15"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one
+  or more contributor license agreements.  See the NOTICE file
+  distributed with this work for additional information
+  regarding copyright ownership.  The ASF licenses this file
+  to you under the Apache License, Version 2.0 (the
+  "License"); you may not use this file except in compliance
+  with the License.  You may obtain a copy of the License at
+
+    http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing,
+  software distributed under the License is distributed on an
+  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+  KIND, either express or implied.  See the License for the
+  specific language governing permissions and limitations
+  under the License.
+-->
+<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "http://forrest.apache.org/dtd/document-v20.dtd">
+<document> 
+  <header> 
+  <title>Axion</title>
+  </header> 
+  <body>
+    <p>
+      Database support for Axion is legacy in DdlUtils because Axion does not appear to
+      be actively developed anymore. Also, support for fundamential JDBC functionality necessary
+      for DdlUtils (such as database metadata) is lacking to a certain degree in Axion.<br/>
+    </p>
+    <p>
+      Info about the datatypes supported by <a href="ext:axion">Axion</a> can be found
+      <a href="ext:axion/datatypes">here</a>.
+    </p>
+    <p>&nbsp;</p>
+    <p>
+      Platform identifier:
+    </p>
+    <ul>
+      <li><code>Axion</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC driver:
+    </p>
+    <ul>
+      <li><code>org.axiondb.jdbc.AxionDriver</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC sub protocol:
+    </p>
+    <ul>
+      <li><code>jdbc:axiondb</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <td class="platformPropName">The database supports SQL comments</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports delimited identifiers</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database's maximum identifier length</td>
+        <td class="platformPropValue">unlimited</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports default values for <code>LONG</code> types</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils uses sequences for identity columns</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-primary key columns as identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database allows INSERT/UPDATE statements to set values for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can read back the auto-generated value of an identity column</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-unique indices</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can create a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can drop a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+    </table>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <th class="typeMappingJdbcType">JDBC Type</th>
+        <th class="typeMappingNativeType">Database Type</th>
+        <th class="typeMappingComments">Additional comments</th>
+      </tr>
+      <tr>
+        <td>ARRAY</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>BIGINT</td>
+        <td>BIGINT</td>
+        <td>This requires Axion CVS head</td>
+      </tr>
+      <tr>
+        <td>BINARY</td>
+        <td>BINARY</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BIT</td>
+        <td>BOOLEAN</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BLOB</td>
+        <td>BLOB</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BOOLEAN</td>
+        <td>BOOLEAN</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>CHAR</td>
+        <td>CHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>CLOB</td>
+        <td>CLOB</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DATALINK</td>
+        <td>VARBINARY</td>
+        <td>Will be read back as VARBINARY</td>
+      </tr>
+      <tr>
+        <td>DATE</td>
+        <td>DATE</td>
+        <td>Axion handles DATE, TIME the same as TIMESTAMP</td>
+      </tr>
+      <tr>
+        <td>DECIMAL</td>
+        <td>DECIMAL</td>
+        <td><code>scale</code> is currently fixed to 2 in Axion (though a different one can be specified)</td>
+      </tr>
+      <tr>
+        <td>DISTINCT</td>
+        <td>VARBINARY</td>
+        <td>Will be read back as VARBINARY</td>
+      </tr>
+      <tr>
+        <td>DOUBLE</td>
+        <td>DOUBLE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>FLOAT</td>
+        <td>FLOAT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>INTEGER</td>
+        <td>INTEGER</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>JAVA_OBJECT</td>
+        <td>JAVA_OBJECT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>LONGVARBINARY</td>
+        <td>LONGVARBINARY</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>LONGVARCHAR</td>
+        <td>LONGVARCHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>NULL</td>
+        <td>VARBINARY</td>
+        <td>Will be read back as VARBINARYd</td>
+      </tr>
+      <tr>
+        <td>NUMERIC</td>
+        <td>NUMERIC</td>
+        <td><code>scale</code> is currently fixed to 2 (though a different one can be specified)</td>
+      </tr>
+      <tr>
+        <td>OTHER</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>REAL</td>
+        <td>REAL</td>
+        <td>Will be read back as FLOAT</td>
+      </tr>
+      <tr>
+        <td>REF</td>
+        <td>VARBINARY</td>
+        <td>Will be read back as VARBINARY</td>
+      </tr>
+      <tr>
+        <td>SMALLINT</td>
+        <td>SMALLINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>STRUCT</td>
+        <td>VARBINARY</td>
+        <td>Will be read back as VARBINARY</td>
+      </tr>
+      <tr>
+        <td>TIME</td>
+        <td>TIME</td>
+        <td>Axion handles DATE, TIME the same as TIMESTAMP</td>
+      </tr>
+      <tr>
+        <td>TIMESTAMP</td>
+        <td>TIMESTAMP</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TINYINT</td>
+        <td>SMALLINT</td>
+        <td>Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>VARBINARY</td>
+        <td>VARBINARY</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>VARCHAR</td>
+        <td>VARCHAR</td>
+        <td></td>
+      </tr>
+    </table>
+  </body>
+</document>

Added: db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/db2.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/db2.xml?view=auto&rev=479070
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/db2.xml (added)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/db2.xml Fri Nov 24 18:25:35 2006
@@ -0,0 +1,275 @@
+<?xml version="1.0" encoding="ISO-8859-15"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one
+  or more contributor license agreements.  See the NOTICE file
+  distributed with this work for additional information
+  regarding copyright ownership.  The ASF licenses this file
+  to you under the Apache License, Version 2.0 (the
+  "License"); you may not use this file except in compliance
+  with the License.  You may obtain a copy of the License at
+
+    http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing,
+  software distributed under the License is distributed on an
+  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+  KIND, either express or implied.  See the License for the
+  specific language governing permissions and limitations
+  under the License.
+-->
+<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "http://forrest.apache.org/dtd/document-v20.dtd">
+<document> 
+  <header> 
+    <title>DB 2</title>
+  </header> 
+  <body> 
+    <p>
+      The DdlUtils support for <a href="ext:db2">IBM DB2</a> is based upon version <strong>7</strong>.
+      The datatypes and SQL elements in DB2 are described in the
+      <a href="ext:db2/manual">DB2 SQL Reference V7</a>. Some specifics related to the JDBC driver and
+      suggested typemappings can also be found <a href="ext:db2/jdbc-mappings">here</a>.
+    </p>
+    <p>
+      DdlUtils provides two platforms for DB2, one for version 7 and one for version 8 and above, which
+      mainly differ in the maximum identifier lengths (see below for details.) Note that you have to
+      specify the v8 platform manually as the auto detection currently always selects the v7 platform.
+    </p>
+    <p>&nbsp;</p>
+    <p>
+      Platform identifiers:
+    </p>
+    <ul>
+      <li><code>DB2</code> for the v7 platform</li>
+      <li><code>DB2v8</code> for the v8 platform</li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC drivers:
+    </p>
+    <ul>
+      <li><code>com.ibm.db2.jcc.DB2Driver</code></li>
+      <li><code>COM.ibm.db2.jdbc.app.DB2Driver</code></li>
+      <li><code>COM.ibm.db2os390.sqlj.jdbc.DB2SQLJDriver</code></li>
+      <li><code>com.ibm.as400.access.AS400JDBCDriver</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC sub protocols:
+    </p>
+    <ul>
+      <li><code>jdbc:db2</code></li>
+      <li><code>jdbc:db2os390</code></li>
+      <li><code>jdbc:2os390sqlj</code></li>
+      <li><code>jdbc:as400</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <td class="platformPropName">The database supports SQL comments</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports delimited identifiers</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database's maximum identifier length</td>
+        <td class="platformPropValue">18 for the v7 platform<br/>The v8 platform supports 128 characters
+                                      for identifiers (e.g. table names), 30 characters for column names,
+                                      and 18 for constraints and foreign keys</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports default values for <code>LONG</code> types</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils uses sequences for identity columns</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-primary key columns as identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database allows INSERT/UPDATE statements to set values for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can read back the auto-generated value of an identity column</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-unique indices</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can create a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can drop a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+    </table>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <th class="typeMappingJdbcType">JDBC Type</th>
+        <th class="typeMappingNativeType">Database Type</th>
+        <th class="typeMappingComments">Additional comments</th>
+      </tr>
+      <tr>
+        <td>ARRAY</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>BIGINT</td>
+        <td>BIGINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BINARY</td>
+        <td>CHAR(n) FOR BIT DATA</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BIT</td>
+        <td>SMALLINT</td>
+        <td>DB2 has no native boolean type<br/>
+            Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>BLOB</td>
+        <td>BLOB</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BOOLEAN</td>
+        <td>SMALLINT</td>
+        <td>DB2 has no native boolean type<br/>
+            Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>CHAR</td>
+        <td>CHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>CLOB</td>
+        <td>CLOB</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DATALINK</td>
+        <td>DATALINK</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DATE</td>
+        <td>DATE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DECIMAL</td>
+        <td>DECIMAL</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DISTINCT</td>
+        <td>DISTINCT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DOUBLE</td>
+        <td>DOUBLE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>FLOAT</td>
+        <td>DOUBLE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>INTEGER</td>
+        <td>INTEGER</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>JAVA_OBJECT</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>LONGVARBINARY</td>
+        <td>LONG VARCHAR FOR BIT DATA</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>LONGVARCHAR</td>
+        <td>LONG VARCHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>NULL</td>
+        <td>LONG VARCHAR FOR BIT DATA</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>NUMERIC</td>
+        <td>DECIMAL</td>
+        <td>Will be read back as DECIMAL</td>
+      </tr>
+      <tr>
+        <td>OTHER</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>REAL</td>
+        <td>REAL</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>REF</td>
+        <td>REF</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>SMALLINT</td>
+        <td>SMALLINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>STRUCT</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>TIME</td>
+        <td>TIME</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TIMESTAMP</td>
+        <td>TIMESTAMP</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TINYINT</td>
+        <td>SMALLINT</td>
+        <td>Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>VARBINARY</td>
+        <td>VARCHAR(n) FOR BIT DATA</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>VARCHAR</td>
+        <td>VARCHAR</td>
+        <td></td>
+      </tr>
+    </table>
+  </body>
+</document>

Added: db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/derby.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/derby.xml?view=auto&rev=479070
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/derby.xml (added)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/derby.xml Fri Nov 24 18:25:35 2006
@@ -0,0 +1,274 @@
+<?xml version="1.0" encoding="ISO-8859-15"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one
+  or more contributor license agreements.  See the NOTICE file
+  distributed with this work for additional information
+  regarding copyright ownership.  The ASF licenses this file
+  to you under the Apache License, Version 2.0 (the
+  "License"); you may not use this file except in compliance
+  with the License.  You may obtain a copy of the License at
+
+    http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing,
+  software distributed under the License is distributed on an
+  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+  KIND, either express or implied.  See the License for the
+  specific language governing permissions and limitations
+  under the License.
+-->
+<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "http://forrest.apache.org/dtd/document-v20.dtd">
+<document> 
+  <header> 
+    <title>Derby/Cloudscape</title>
+  </header> 
+  <body> 
+    <p>
+      DdlUtils supports <a href="ext:cloudscape">Cloudscape</a> version 10.0. Information about the
+      SQL elements and datatypes of Cloudscape is found in the
+      <a href="ext:cloudscape/manual">IBM Cloudscape Reference Manual</a>.
+    </p>
+    <p>
+      The <a href="ext:derby">Apache Derby</a> project is based upon Cloudscape version 10, which IBM
+      contributed to Apache in 2004. The SQL syntax and datatypes supported by Derby are described in
+      the Datatypes section in the <a href="ext:derby/manual">Reference Manual</a>.
+    </p>
+    <note>
+      Because development and support of Cloudscape has ended in favor of Derby, the DdlUtils support
+      for Cloudscape is legacy and will likely be removed in future versions. If you use Cloudscape
+      we strongly suggest that you update to Derby.
+    </note>
+    <p>&nbsp;</p>
+    <p>
+      Platform identifiers:
+    </p>
+    <ul>
+      <li><code>Derby</code> for the Derby platform</li>
+      <li><code>Cloudscape</code> for the Cloudscape platform</li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC drivers:
+    </p>
+    <ul>
+      <li><code>org.apache.derby.jdbc.ClientDriver</code> (Derby)</li>
+      <li><code>org.apache.derby.jdbc.EmbeddedDriver</code> (Derby)</li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC sub protocols:
+    </p>
+    <ul>
+      <li><code>jdbc:derby</code> (Derby)</li>
+      <li><code>jdbc:db2j:net</code> (Cloudscape)</li>
+      <li><code>jdbc:cloudscape:net</code> (Cloudscape)</li>
+    </ul>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <td class="platformPropName">The database supports SQL comments</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports delimited identifiers</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database's maximum identifier length</td>
+        <td class="platformPropValue">128</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports default values for <code>LONG</code> types</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils uses sequences for identity columns</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-primary key columns as identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database allows INSERT/UPDATE statements to set values for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can read back the auto-generated value of an identity column</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-unique indices</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can create a database via JDBC</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can drop a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+    </table>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <th class="typeMappingJdbcType">JDBC Type</th>
+        <th class="typeMappingNativeType">Database Type</th>
+        <th class="typeMappingComments">Additional comments</th>
+      </tr>
+      <tr>
+        <td>ARRAY</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>BIGINT</td>
+        <td>BIGINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BINARY</td>
+        <td>CHAR(n) FOR BIT DATA</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BIT</td>
+        <td>SMALLINT</td>
+        <td>Cloudscape/Derby have no native boolean type<br/>
+            Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>BLOB</td>
+        <td>BLOB</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BOOLEAN</td>
+        <td>SMALLINT</td>
+        <td>Cloudscape/Derby have no native boolean type<br/>
+            Will be read back as BOOLEAN</td>
+      </tr>
+      <tr>
+        <td>CHAR</td>
+        <td>CHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>CLOB</td>
+        <td>CLOB</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DATALINK</td>
+        <td>LONG VARCHAR FOR BIT DATA</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>DATE</td>
+        <td>DATE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DECIMAL</td>
+        <td>DECIMAL</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DISTINCT</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>DOUBLE</td>
+        <td>Cloudscape: DOUBLE PRECISION<br/>Derby: DOUBLE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>FLOAT</td>
+        <td>Cloudscape: DOUBLE PRECISION<br/>Derby: DOUBLE</td>
+        <td>Will be read back as DOUBLE</td>
+      </tr>
+      <tr>
+        <td>INTEGER</td>
+        <td>INTEGER</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>JAVA_OBJECT</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>LONGVARBINARY</td>
+        <td>LONG VARCHAR FOR BIT DATA</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>LONGVARCHAR</td>
+        <td>LONG VARCHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>NULL</td>
+        <td>LONG VARCHAR FOR BIT DATA</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>NUMERIC</td>
+        <td>NUMERIC</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>OTHER</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>REAL</td>
+        <td>REAL</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>REF</td>
+        <td>LONG VARCHAR FOR BIT DATA</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>SMALLINT</td>
+        <td>SMALLINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>STRUCT</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>TIME</td>
+        <td>TIME</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TIMESTAMP</td>
+        <td>TIMESTAMP</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TINYINT</td>
+        <td>SMALLINT</td>
+        <td>Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>VARBINARY</td>
+        <td>VARCHAR(n) FOR BIT DATA</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>VARCHAR</td>
+        <td>VARCHAR</td>
+        <td></td>
+      </tr>
+    </table>
+  </body>
+</document>

Added: db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/firebird.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/firebird.xml?view=auto&rev=479070
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/firebird.xml (added)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/firebird.xml Fri Nov 24 18:25:35 2006
@@ -0,0 +1,258 @@
+<?xml version="1.0" encoding="ISO-8859-15"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one
+  or more contributor license agreements.  See the NOTICE file
+  distributed with this work for additional information
+  regarding copyright ownership.  The ASF licenses this file
+  to you under the Apache License, Version 2.0 (the
+  "License"); you may not use this file except in compliance
+  with the License.  You may obtain a copy of the License at
+
+    http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing,
+  software distributed under the License is distributed on an
+  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+  KIND, either express or implied.  See the License for the
+  specific language governing permissions and limitations
+  under the License.
+-->
+<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "http://forrest.apache.org/dtd/document-v20.dtd">
+<document> 
+  <header> 
+    <title>Firebird</title>
+  </header> 
+  <body> 
+    <p>
+      DdlUtils supports <a href="ext:firebird">Firebird</a>, version <strong>1</strong> and above.
+    </p>
+    <p>&nbsp;</p>
+    <p>
+      Platform identifier:
+    </p>
+    <ul>
+      <li><code>Firebird</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC driver:
+    </p>
+    <ul>
+      <li><code>org.firebirdsql.jdbc.FBDriver</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC sub protocol:
+    </p>
+    <ul>
+      <li><code>jdbc:firebirdsql</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <td class="platformPropName">The database supports SQL comments</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports delimited identifiers</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database's maximum identifier length</td>
+        <td class="platformPropValue">31</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports default values for <code>LONG</code> types</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils uses sequences for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-primary key columns as identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database allows INSERT/UPDATE statements to set values for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can read back the auto-generated value of an identity column</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-unique indices</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can create a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can drop a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+    </table>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <th class="typeMappingJdbcType">JDBC Type</th>
+        <th class="typeMappingNativeType">Database Type</th>
+        <th class="typeMappingComments">Additional comments</th>
+      </tr>
+      <tr>
+        <td>ARRAY</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>BIGINT</td>
+        <td>BIGINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BINARY</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>BIT</td>
+        <td>SMALLINT</td>
+        <td>Firebird has no native boolean type<br/>
+            Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>BLOB</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>BOOLEAN</td>
+        <td>SMALLINT</td>
+        <td>Firebird has no native boolean type<br/>
+            Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>CHAR</td>
+        <td>CHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>CLOB</td>
+        <td>BLOB SUB_TYPE TEXT</td>
+        <td>Will be read back as LONGVARCHAR</td>
+      </tr>
+      <tr>
+        <td>DATALINK</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>DATE</td>
+        <td>DATE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DECIMAL</td>
+        <td>DECIMAL</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DISTINCT</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>DOUBLE</td>
+        <td>DOUBLE PRECISION</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>FLOAT</td>
+        <td>DOUBLE PRECISION</td>
+        <td>Will be read back as DOUBLE</td>
+      </tr>
+      <tr>
+        <td>INTEGER</td>
+        <td>INTEGER</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>JAVA_OBJECT</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>LONGVARBINARY</td>
+        <td>BLOB</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>LONGVARCHAR</td>
+        <td>BLOB SUB_TYPE TEXT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>NULL</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>NUMERIC</td>
+        <td>NUMERIC</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>OTHER</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>REAL</td>
+        <td>FLOAT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>REF</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>SMALLINT</td>
+        <td>SMALLINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>STRUCT</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>TIME</td>
+        <td>TIME</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TIMESTAMP</td>
+        <td>TIMESTAMP</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TINYINT</td>
+        <td>SMALLINT</td>
+        <td>Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>VARBINARY</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>VARCHAR</td>
+        <td>VARCHAR</td>
+        <td></td>
+      </tr>
+    </table>
+  </body>
+</document>

Added: db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/hsqldb.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/hsqldb.xml?view=auto&rev=479070
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/hsqldb.xml (added)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/hsqldb.xml Fri Nov 24 18:25:35 2006
@@ -0,0 +1,261 @@
+<?xml version="1.0" encoding="ISO-8859-15"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one
+  or more contributor license agreements.  See the NOTICE file
+  distributed with this work for additional information
+  regarding copyright ownership.  The ASF licenses this file
+  to you under the Apache License, Version 2.0 (the
+  "License"); you may not use this file except in compliance
+  with the License.  You may obtain a copy of the License at
+
+    http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing,
+  software distributed under the License is distributed on an
+  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+  KIND, either express or implied.  See the License for the
+  specific language governing permissions and limitations
+  under the License.
+-->
+<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "http://forrest.apache.org/dtd/document-v20.dtd">
+<document> 
+  <header> 
+    <title>HsqlDB</title>
+  </header> 
+  <body> 
+    <p>
+      DdlUtils supports the <a href="ext:hsqldb">HSQLDB</a> database, version <strong>1.7.2</strong> or newer.
+      SQL Documentation for HSQLDB can be found in the distribution, and for the newest version
+      <a href="ext:hsqldb/sql-syntax">here</a>.
+    </p>
+    <p>&nbsp;</p>
+    <p>
+      Platform identifier:
+    </p>
+    <ul>
+      <li><code>HsqlDb</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC driver:
+    </p>
+    <ul>
+      <li><code>org.hsqldb.jdbcDriver</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC sub protocol:
+    </p>
+    <ul>
+      <li><code>jdbc:hsqldb</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <td class="platformPropName">The database supports SQL comments</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports delimited identifiers</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database's maximum identifier length</td>
+        <td class="platformPropValue">unlimited</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports default values for <code>LONG</code> types</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils uses sequences for identity columns</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-primary key columns as identity columns</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database allows INSERT/UPDATE statements to set values for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can read back the auto-generated value of an identity column</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-unique indices</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can create a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can drop a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+    </table>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <th class="typeMappingJdbcType">JDBC Type</th>
+        <th class="typeMappingNativeType">Database Type</th>
+        <th class="typeMappingComments">Additional comments</th>
+      </tr>
+      <tr>
+        <td>ARRAY</td>
+        <td>LONGVARBINARY</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>BIGINT</td>
+        <td>BIGINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BINARY</td>
+        <td>BINARY</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BIT</td>
+        <td>BOOLEAN</td>
+        <td>Will be read back as BOOLEAN</td>
+      </tr>
+      <tr>
+        <td>BLOB</td>
+        <td>LONGVARBINARY</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>BOOLEAN</td>
+        <td>BOOLEAN</td>
+        <td>BOOLEAN is supported natively by Hsqldb only since version 1.7.2</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>CHAR</td>
+        <td>CHAR</td>
+        <td>The size is optional because per default Hsqldb does not enforce it</td>
+      </tr>
+      <tr>
+        <td>CLOB</td>
+        <td>LONGVARCHAR</td>
+        <td>Will be read back as LONGVARCHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DATALINK</td>
+        <td>LONGVARBINARY</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>DATE</td>
+        <td>DATE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DECIMAL</td>
+        <td>DECIMAL</td>
+        <td>Precision and scale are ignored by Hsqldb, as it uses unlimited precision and scale</td>
+      </tr>
+      <tr>
+        <td>DISTINCT</td>
+        <td>LONGVARBINARY</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>DOUBLE</td>
+        <td>DOUBLE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>FLOAT</td>
+        <td>DOUBLE</td>
+        <td>Will be read back as DOUBLE</td>
+      </tr>
+      <tr>
+        <td>INTEGER</td>
+        <td>INTEGER</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>JAVA_OBJECT</td>
+        <td>OBJECT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>LONGVARBINARY</td>
+        <td>LONGVARBINARY</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>LONGVARCHAR</td>
+        <td>LONGVARCHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>NULL</td>
+        <td>LONGVARBINARY</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>NUMERIC</td>
+        <td>NUMERIC</td>
+        <td>Precision and scale are ignored by Hsqldb, as it uses unlimited precision and scale</td>
+      </tr>
+      <tr>
+        <td>OTHER</td>
+        <td>OTHER</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>REAL</td>
+        <td>REAL</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>REF</td>
+        <td>LONGVARBINARY</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>SMALLINT</td>
+        <td>SMALLINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>STRUCT</td>
+        <td>LONGVARBINARY</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>TIME</td>
+        <td>TIME</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TIMESTAMP</td>
+        <td>TIMESTAMP</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TINYINT</td>
+        <td>SMALLINT</td>
+        <td>JDBC's TINYINT requires a value range of -255 to 255, but HsqlDb's is only -128 to 127<br/>
+            Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>VARBINARY</td>
+        <td>VARBINARY</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>VARCHAR</td>
+        <td>VARCHAR</td>
+        <td>The size is optional because per default Hsqldb does not enforce it</td>
+      </tr>
+    </table>
+  </body>
+</document>

Added: db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/interbase.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/interbase.xml?view=auto&rev=479070
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/interbase.xml (added)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/interbase.xml Fri Nov 24 18:25:35 2006
@@ -0,0 +1,262 @@
+<?xml version="1.0" encoding="ISO-8859-15"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one
+  or more contributor license agreements.  See the NOTICE file
+  distributed with this work for additional information
+  regarding copyright ownership.  The ASF licenses this file
+  to you under the Apache License, Version 2.0 (the
+  "License"); you may not use this file except in compliance
+  with the License.  You may obtain a copy of the License at
+
+    http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing,
+  software distributed under the License is distributed on an
+  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+  KIND, either express or implied.  See the License for the
+  specific language governing permissions and limitations
+  under the License.
+-->
+<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "http://forrest.apache.org/dtd/document-v20.dtd">
+<document> 
+  <header> 
+    <title>Interbase</title>
+  </header> 
+  <body> 
+    <p>
+      DdlUtils supports <a href="ext:interbase">Interbase</a> version <strong>7.0</strong> and above.
+    </p>
+    <p>&nbsp;</p>
+    <p>
+      Platform identifier:
+    </p>
+    <ul>
+      <li><code>Interbase</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC driver:
+    </p>
+    <ul>
+      <li><code>interbase.interclient.Driver</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC sub protocol:
+    </p>
+    <ul>
+      <li><code>jdbc:interbase</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <td class="platformPropName">The database supports SQL comments</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports delimited identifiers</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database's maximum identifier length</td>
+        <td class="platformPropValue">31</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports default values for <code>LONG</code> types</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils uses sequences for identity columns</td>
+        <td class="platformPropValue">sort-of, DdlUtils uses a GENERATOR</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-primary key columns as identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database allows INSERT/UPDATE statements to set values for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can read back the auto-generated value of an identity column</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-unique indices</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can create a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can drop a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+    </table>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <th class="typeMappingJdbcType">JDBC Type</th>
+        <th class="typeMappingNativeType">Database Type</th>
+        <th class="typeMappingComments">Additional comments</th>
+      </tr>
+      <tr>
+        <td>ARRAY</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>BIGINT</td>
+        <td>NUMERIC(18,0)</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BINARY</td>
+        <td>BLOB</td>
+        <td>We could use <code>CHAR(n) CHARACTER SET OCTETS</code> but the JDBC driver
+            cannot handle these types properly.<br/>
+            Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>BIT</td>
+        <td>SMALLINT</td>
+        <td>Interbase has no native boolean type<br/>
+            Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>BLOB</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>BOOLEAN</td>
+        <td>SMALLINT</td>
+        <td>Interbase has no native boolean type<br/>
+            Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>CHAR</td>
+        <td>CHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>CLOB</td>
+        <td>BLOB SUB_TYPE TEXT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DATALINK</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>DATE</td>
+        <td>DATE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DECIMAL</td>
+        <td>DECIMAL</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DISTINCT</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>DOUBLE</td>
+        <td>DOUBLE PRECISION</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>FLOAT</td>
+        <td>DOUBLE PRECISION</td>
+        <td>Will be read back as DOUBLE</td>
+      </tr>
+      <tr>
+        <td>INTEGER</td>
+        <td>INTEGER</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>JAVA_OBJECT</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>LONGVARBINARY</td>
+        <td>BLOB</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>LONGVARCHAR</td>
+        <td>BLOB SUB_TYPE TEXT</td>
+        <td>Will be read back as CLOB</td>
+      </tr>
+      <tr>
+        <td>NULL</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>NUMERIC</td>
+        <td>NUMERIC</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>OTHER</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>REAL</td>
+        <td>FLOAT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>REF</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>SMALLINT</td>
+        <td>SMALLINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>STRUCT</td>
+        <td>BLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>TIME</td>
+        <td>TIME</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TIMESTAMP</td>
+        <td>TIMESTAMP</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TINYINT</td>
+        <td>SMALLINT</td>
+        <td>Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>VARBINARY</td>
+        <td>BLOB</td>
+        <td>We could use <code>VARCHAR(n) CHARACTER SET OCTETS</code> but the JDBC driver
+            cannot handle these types properly.<br/>
+            Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>VARCHAR</td>
+        <td>VARCHAR</td>
+        <td></td>
+      </tr>
+    </table>
+  </body>
+</document>

Added: db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/maxdb.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/maxdb.xml?view=auto&rev=479070
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/maxdb.xml (added)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/maxdb.xml Fri Nov 24 18:25:35 2006
@@ -0,0 +1,261 @@
+<?xml version="1.0" encoding="ISO-8859-15"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one
+  or more contributor license agreements.  See the NOTICE file
+  distributed with this work for additional information
+  regarding copyright ownership.  The ASF licenses this file
+  to you under the Apache License, Version 2.0 (the
+  "License"); you may not use this file except in compliance
+  with the License.  You may obtain a copy of the License at
+
+    http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing,
+  software distributed under the License is distributed on an
+  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+  KIND, either express or implied.  See the License for the
+  specific language governing permissions and limitations
+  under the License.
+-->
+<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "http://forrest.apache.org/dtd/document-v20.dtd">
+<document> 
+  <header> 
+    <title>MaxDB/SapDB</title>
+  </header> 
+  <body> 
+    <p>
+      The <a href="ext:sapdb">SapDB</a> database was open-sourced and rebranded <a href="ext:maxdb">MaxDB</a> 
+      beginning with version 7.4. DdlUtils supports SapDB version <strong>7.2</strong> and MaxDB version
+      <strong>7.5</strong>, and newer. Documentation of the SQL supported by SapDB is found in the
+      <a href="ext:sapdb/manual">Reference manual</a>. Likewise, documentation for MaxDB is contained in
+      the <a href="ext:maxdb/manual">MaxDB documentation</a>.
+    </p>
+    <p>&nbsp;</p>
+    <p>
+      Platform identifiers:
+    </p>
+    <ul>
+      <li><code>MaxDB</code></li>
+      <li><code>SapDB</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC driver:
+    </p>
+    <ul>
+      <li><code>com.sap.dbtech.jdbc.DriverSapDB</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC sub protocol:
+    </p>
+    <ul>
+      <li><code>jdbc:sapdb</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <td class="platformPropName">The database supports SQL comments</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports delimited identifiers</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database's maximum identifier length</td>
+        <td class="platformPropValue">32</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports default values for <code>LONG</code> types</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils uses sequences for identity columns</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-primary key columns as identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database allows INSERT/UPDATE statements to set values for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can read back the auto-generated value of an identity column</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-unique indices</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can create a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can drop a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+    </table>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <th class="typeMappingJdbcType">JDBC Type</th>
+        <th class="typeMappingNativeType">Database Type</th>
+        <th class="typeMappingComments">Additional comments</th>
+      </tr>
+      <tr>
+        <td>ARRAY</td>
+        <td>LONG BYTE</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>BIGINT</td>
+        <td>FIXED(38,0)</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BINARY</td>
+        <td>CHAR(n) BYTE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BIT</td>
+        <td>BOOLEAN</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BLOB</td>
+        <td>LONG BYTE</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>BOOLEAN</td>
+        <td>BOOLEAN</td>
+        <td>Will be read back as BIT</td>
+      </tr>
+      <tr>
+        <td>CHAR</td>
+        <td>CHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>CLOB</td>
+        <td>LONG</td>
+        <td>Will be read back as LONGVARCHAR</td>
+      </tr>
+      <tr>
+        <td>DATALINK</td>
+        <td>LONG BYTE</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>DATE</td>
+        <td>DATE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DECIMAL</td>
+        <td>FIXED</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DISTINCT</td>
+        <td>LONG BYTE</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>DOUBLE</td>
+        <td>FLOAT(38)</td>
+        <td>Will be read back as FLOAT</td>
+      </tr>
+      <tr>
+        <td>FLOAT</td>
+        <td>FLOAT(38)</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>INTEGER</td>
+        <td>INTEGER</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>JAVA_OBJECT</td>
+        <td>LONG BYTE</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>LONGVARBINARY</td>
+        <td>LONG BYTE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>LONGVARCHAR</td>
+        <td>LONG</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>NULL</td>
+        <td>LONG BYTE</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>NUMERIC</td>
+        <td>FIXED</td>
+        <td>Will be read back as DECIMAL</td>
+      </tr>
+      <tr>
+        <td>OTHER</td>
+        <td>LONG BYTE</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>REAL</td>
+        <td>FLOAT(16)</td>
+        <td>Will be read back as FLOAT</td>
+      </tr>
+      <tr>
+        <td>REF</td>
+        <td>LONG BYTE</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>SMALLINT</td>
+        <td>SMALLINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>STRUCT</td>
+        <td>LONG BYTE</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>TIME</td>
+        <td>TIME</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TIMESTAMP</td>
+        <td>TIMESTAMP</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TINYINT</td>
+        <td>SMALLINT</td>
+        <td>Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>VARBINARY</td>
+        <td>VARCHAR(n) BYTE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>VARCHAR</td>
+        <td>VARCHAR</td>
+        <td></td>
+      </tr>
+    </table>
+  </body>
+</document>

Added: db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/mckoi.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/mckoi.xml?view=auto&rev=479070
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/mckoi.xml (added)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/mckoi.xml Fri Nov 24 18:25:35 2006
@@ -0,0 +1,258 @@
+<?xml version="1.0" encoding="ISO-8859-15"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one
+  or more contributor license agreements.  See the NOTICE file
+  distributed with this work for additional information
+  regarding copyright ownership.  The ASF licenses this file
+  to you under the Apache License, Version 2.0 (the
+  "License"); you may not use this file except in compliance
+  with the License.  You may obtain a copy of the License at
+
+    http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing,
+  software distributed under the License is distributed on an
+  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+  KIND, either express or implied.  See the License for the
+  specific language governing permissions and limitations
+  under the License.
+-->
+<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "http://forrest.apache.org/dtd/document-v20.dtd">
+<document> 
+  <header> 
+    <title>Mckoi</title>
+  </header> 
+  <body> 
+    <p>
+      The open source database <a href="ext:mckoi">McKoi</a> is supported in version <strong>1.0.3</strong>.
+      Details on the supported SQL and datatypes can be found in Chapter 2 of the
+      <a href="ext:mckoi/manual">Database Manual</a>.
+    </p>
+    <p>&nbsp;</p>
+    <p>
+      Platform identifier:
+    </p>
+    <ul>
+      <li><code>McKoi</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC driver:
+    </p>
+    <ul>
+      <li><code>com.mckoi.JDBCDriver</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC sub protocol:
+    </p>
+    <ul>
+      <li><code>jdbc:mckoi</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <td class="platformPropName">The database supports SQL comments</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports delimited identifiers</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database's maximum identifier length</td>
+        <td class="platformPropValue">unlimited</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports default values for <code>LONG</code> types</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils uses sequences for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-primary key columns as identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database allows INSERT/UPDATE statements to set values for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can read back the auto-generated value of an identity column</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-unique indices</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can create a database via JDBC</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can drop a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+    </table>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <th class="typeMappingJdbcType">JDBC Type</th>
+        <th class="typeMappingNativeType">Database Type</th>
+        <th class="typeMappingComments">Additional comments</th>
+      </tr>
+      <tr>
+        <td>ARRAY</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>BIGINT</td>
+        <td>BIGINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BINARY</td>
+        <td>BINARY</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BIT</td>
+        <td>BOOLEAN</td>
+        <td>Will be read back as BOOLEAN</td>
+      </tr>
+      <tr>
+        <td>BLOB</td>
+        <td>BLOB</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BOOLEAN</td>
+        <td>BOOLEAN</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>CHAR</td>
+        <td>CHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>CLOB</td>
+        <td>CLOB</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DATALINK</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>DATE</td>
+        <td>DATE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DECIMAL</td>
+        <td>DECIMAL</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DISTINCT</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>DOUBLE</td>
+        <td>DOUBLE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>FLOAT</td>
+        <td>DOUBLE</td>
+        <td>Will be read back as DOUBLE</td>
+      </tr>
+      <tr>
+        <td>INTEGER</td>
+        <td>INTEGER</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>JAVA_OBJECT</td>
+        <td>JAVA_OBJECT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>LONGVARBINARY</td>
+        <td>LONGVARBINARY</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>LONGVARCHAR</td>
+        <td>LONGVARCHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>NULL</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>NUMERIC</td>
+        <td>NUMERIC</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>OTHER</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>REAL</td>
+        <td>REAL</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>REF</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>SMALLINT</td>
+        <td>SMALLINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>STRUCT</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>TIME</td>
+        <td>TIME</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TIMESTAMP</td>
+        <td>TIMESTAMP</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TINYINT</td>
+        <td>TINYINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>VARBINARY</td>
+        <td>VARBINARY</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>VARCHAR</td>
+        <td>VARCHAR</td>
+        <td></td>
+      </tr>
+    </table>
+  </body>
+</document>

Added: db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/mysql.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/mysql.xml?view=auto&rev=479070
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/mysql.xml (added)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/mysql.xml Fri Nov 24 18:25:35 2006
@@ -0,0 +1,269 @@
+<?xml version="1.0" encoding="ISO-8859-15"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one
+  or more contributor license agreements.  See the NOTICE file
+  distributed with this work for additional information
+  regarding copyright ownership.  The ASF licenses this file
+  to you under the Apache License, Version 2.0 (the
+  "License"); you may not use this file except in compliance
+  with the License.  You may obtain a copy of the License at
+
+    http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing,
+  software distributed under the License is distributed on an
+  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+  KIND, either express or implied.  See the License for the
+  specific language governing permissions and limitations
+  under the License.
+-->
+<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "http://forrest.apache.org/dtd/document-v20.dtd">
+<document> 
+  <header> 
+    <title>MySQL</title>
+  </header> 
+  <body> 
+    <p>
+      <a href="ext:mysql">MySQL</a> is supported from version <strong>3.23</strong> onwards. Note that
+      the major versions (3, 4, 5) differ in their datatype support. The supported SQL syntax and datatypes
+      can be found in the <a href="ext:mysql/manual">MySQL Reference Manual</a>.
+    </p>
+    <p>
+      DdlUtils provides two platforms, one for MySql versions 3 and 4, and one for MySql version 5 and above.
+      The latter implements some aspects of reading back a model from the database differently to address
+      some changes in MySql 5.
+    </p>
+    <p>&nbsp;</p>
+    <p>
+      Platform identifiers:
+    </p>
+    <ul>
+      <li><code>MySQL</code></li>
+      <li><code>MySQL5</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC drivers:
+    </p>
+    <ul>
+      <li><code>com.mysql.jdbc.Driver</code></li>
+      <li><code>org.gjt.mm.mysql.Driver</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC sub protocol:
+    </p>
+    <ul>
+      <li><code>jdbc:mysql</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <td class="platformPropName">The database supports SQL comments</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports delimited identifiers</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database's maximum identifier length</td>
+        <td class="platformPropValue">64</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports default values for <code>LONG</code> types</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils uses sequences for identity columns</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-primary key columns as identity columns</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database allows INSERT/UPDATE statements to set values for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can read back the auto-generated value of an identity column</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-unique indices</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can create a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can drop a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+    </table>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <th class="typeMappingJdbcType">JDBC Type</th>
+        <th class="typeMappingNativeType">Database Type</th>
+        <th class="typeMappingComments">Additional comments</th>
+      </tr>
+      <tr>
+        <td>ARRAY</td>
+        <td>LONGBLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>BIGINT</td>
+        <td>BIGINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BINARY</td>
+        <td>BINARY</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BIT</td>
+        <td>TINYINT(1)</td>
+        <td>MySQL has no native boolean type</td>
+      </tr>
+      <tr>
+        <td>BLOB</td>
+        <td>LONGBLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>BOOLEAN</td>
+        <td>TINYINT(1)</td>
+        <td>MySQL has no native boolean type<br/>
+            Will be read back as BIT</td>
+      </tr>
+      <tr>
+        <td>CHAR</td>
+        <td>CHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>CLOB</td>
+        <td>LONGTEXT</td>
+        <td>Will be read back as LONGVARCHAR</td>
+      </tr>
+      <tr>
+        <td>DATALINK</td>
+        <td>MEDIUMBLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>DATE</td>
+        <td>DATE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DECIMAL</td>
+        <td>DECIMAL</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DISTINCT</td>
+        <td>LONGBLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>DOUBLE</td>
+        <td>DOUBLE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>FLOAT</td>
+        <td>DOUBLE</td>
+        <td>Will be read back as DOUBLE</td>
+      </tr>
+      <tr>
+        <td>INTEGER</td>
+        <td>INTEGER</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>JAVA_OBJECT</td>
+        <td>LONGBLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>LONGVARBINARY</td>
+        <td>MEDIUMBLOB</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>LONGVARCHAR</td>
+        <td>MEDIUMTEXT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>NULL</td>
+        <td>MEDIUMBLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>NUMERIC</td>
+        <td>DECIMAL</td>
+        <td>Will be read back as DECIMAL</td>
+      </tr>
+      <tr>
+        <td>OTHER</td>
+        <td>LONGBLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>REAL</td>
+        <td>FLOAT</td>
+        <td>MySQL has a REAL datatype that is per default an alias for DOUBLE, though it might be mapped to FLOAT
+            via configuration of the server. Therefore, DdlUtils explicitly uses FLOAT.</td>
+      </tr>
+      <tr>
+        <td>REF</td>
+        <td>MEDIUMBLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>SMALLINT</td>
+        <td>SMALLINT</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>STRUCT</td>
+        <td>LONGBLOB</td>
+        <td>Will be read back as LONGVARBINARY</td>
+      </tr>
+      <tr>
+        <td>TIME</td>
+        <td>TIME</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>TIMESTAMP</td>
+        <td>DATETIME</td>
+        <td>TIMESTAMP is not a stable MySQL datatype yet, and it does not support a higher precision
+            than DATETIME (year to seconds) as of MySQL 5, DdlUtils maps the JDBC type to DATETIME instead.</td>
+      </tr>
+      <tr>
+        <td>TINYINT</td>
+        <td>SMALLINT</td>
+        <td>In MySQL, TINYINT only has a range of -128 to +127. This DdlUtils uses SMALLINT instead.<br/>
+            Will be read back as SMALLINT</td>
+      </tr>
+      <tr>
+        <td>VARBINARY</td>
+        <td>VARBINARY</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>VARCHAR</td>
+        <td>VARCHAR</td>
+        <td></td>
+      </tr>
+    </table>
+  </body>
+</document>

Added: db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/oracle.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/oracle.xml?view=auto&rev=479070
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/oracle.xml (added)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/oracle.xml Fri Nov 24 18:25:35 2006
@@ -0,0 +1,277 @@
+<?xml version="1.0" encoding="ISO-8859-15"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one
+  or more contributor license agreements.  See the NOTICE file
+  distributed with this work for additional information
+  regarding copyright ownership.  The ASF licenses this file
+  to you under the Apache License, Version 2.0 (the
+  "License"); you may not use this file except in compliance
+  with the License.  You may obtain a copy of the License at
+
+    http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing,
+  software distributed under the License is distributed on an
+  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+  KIND, either express or implied.  See the License for the
+  specific language governing permissions and limitations
+  under the License.
+-->
+<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "http://forrest.apache.org/dtd/document-v20.dtd">
+<document> 
+  <header> 
+    <title>Oracle</title>
+  </header> 
+  <body> 
+    <p>
+      DdlUtils has support for the <a href="ext:oracle">Oracle database</a> for versions <strong>8.1.7</strong>
+      and above.<br/>
+      Info about the datatypes and SQL elements supported in this version can be found in the
+      <strong>Oracle SQL Reference</strong>. You can access this documentation from the
+      <a href="ext:oracle/otn">Oracle Technology Network</a>. Registration to this area is free.
+    </p>
+    <p>
+      DdlUtils provides different platforms for Oracle v8, v9, and v10. The v9 platform adds support for
+      the native <code>TIMESTAMP</code> type, and the v10 platform handles the recycle bin that was
+      introduced in version 10 of the Oracle database.<br/>
+      Note that DdlUtils currently does not automatically detect the database version, so it will always
+      choose the v8 version. If you want to make use of the additional features, then you have to
+      specify the platform identifier manually.
+    </p>
+    <p>&nbsp;</p>
+    <p>
+      Platform identifiers:
+    </p>
+    <ul>
+      <li><code>Oracle</code></li>
+      <li><code>Oracle9</code></li>
+      <li><code>Oracle10</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC drivers:
+    </p>
+    <ul>
+      <li><code>oracle.jdbc.driver.OracleDriver</code></li>
+      <li><code>oracle.jdbc.dnlddriver.OracleDriver</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC sub protocols:
+    </p>
+    <ul>
+      <li><code>jdbc:oracle:thin</code></li>
+      <li><code>jdbc:oracle:oci8</code></li>
+      <li><code>jdbc:oracle:dnldthin</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <td class="platformPropName">The database supports SQL comments</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports delimited identifiers</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database's maximum identifier length</td>
+        <td class="platformPropValue">30</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports default values for <code>LONG</code> types</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils uses sequences for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-primary key columns as identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database allows INSERT/UPDATE statements to set values for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can read back the auto-generated value of an identity column</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-unique indices</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can create a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can drop a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+    </table>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <th class="typeMappingJdbcType">JDBC Type</th>
+        <th class="typeMappingNativeType">Database Type</th>
+        <th class="typeMappingComments">Additional comments</th>
+      </tr>
+      <tr>
+        <td>ARRAY</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>BIGINT</td>
+        <td>NUMBER(38)</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BINARY</td>
+        <td>RAW</td>
+        <td>Oracle requires the specification of the size for <code>RAW</code> columns.
+            If no size was specified, then 254 is used.<br/>
+            Will be read back as VARBINARY</td>
+      </tr>
+      <tr>
+        <td>BIT</td>
+        <td>NUMBER(1)</td>
+        <td>Oracle has no native boolean type.</td>
+      </tr>
+      <tr>
+        <td>BLOB</td>
+        <td>BLOB</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>BOOLEAN</td>
+        <td>NUMBER(1)</td>
+        <td>Oracle has no native boolean type.<br/>
+            Will be read back as BIT</td>
+      </tr>
+      <tr>
+        <td>CHAR</td>
+        <td>CHAR</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>CLOB</td>
+        <td>CLOB</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DATALINK</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>DATE</td>
+        <td>DATE</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DECIMAL</td>
+        <td>NUMBER</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>DISTINCT</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>DOUBLE</td>
+        <td>DOUBLE PRECISION</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>FLOAT</td>
+        <td>FLOAT</td>
+        <td>Will be read back as DOUBLE</td>
+      </tr>
+      <tr>
+        <td>INTEGER</td>
+        <td>INTEGER</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>JAVA_OBJECT</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>LONGVARBINARY</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>LONGVARCHAR</td>
+        <td>CLOB</td>
+        <td>Will be read back as CLOB</td>
+      </tr>
+      <tr>
+        <td>NULL</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>NUMERIC</td>
+        <td>NUMBER</td>
+        <td>Will be read back as DECIMAL</td>
+      </tr>
+      <tr>
+        <td>OTHER</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>REAL</td>
+        <td>REAL</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>REF</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>SMALLINT</td>
+        <td>NUMBER(5)</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>STRUCT</td>
+        <td>BLOB</td>
+        <td>Will be read back as BLOB</td>
+      </tr>
+      <tr>
+        <td>TIME</td>
+        <td>DATE</td>
+        <td>Will be read back as TIMESTAMP</td>
+      </tr>
+      <tr>
+        <td>TIMESTAMP</td>
+        <td>Oracle8 platform: DATE<br/>Oracle9/10 platforms: TIMESTAMP</td>
+        <td>The TIMESTAMP native type is only supported in Oracle 9 and above.</td>
+      </tr>
+      <tr>
+        <td>TINYINT</td>
+        <td>NUMBER(3)</td>
+        <td></td>
+      </tr>
+      <tr>
+        <td>VARBINARY</td>
+        <td>RAW</td>
+        <td>Oracle requires the specification of the size for <code>RAW</code> columns.
+            If no size was specified, then 254 is used.</td>
+      </tr>
+      <tr>
+        <td>VARCHAR</td>
+        <td>VARCHAR2</td>
+        <td></td>
+      </tr>
+    </table>
+  </body>
+</document>



Mime
View raw message