You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by to...@apache.org on 2006/11/25 03:25:36 UTC
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...
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> </p>
+ <p>
+ Platform identifier:
+ </p>
+ <ul>
+ <li><code>Axion</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC driver:
+ </p>
+ <ul>
+ <li><code>org.axiondb.jdbc.AxionDriver</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC sub protocol:
+ </p>
+ <ul>
+ <li><code>jdbc:axiondb</code></li>
+ </ul>
+ <p> </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> </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> </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> </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> </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> </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> </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> </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> </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> </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> </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> </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> </p>
+ <p>
+ Platform identifier:
+ </p>
+ <ul>
+ <li><code>Firebird</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC driver:
+ </p>
+ <ul>
+ <li><code>org.firebirdsql.jdbc.FBDriver</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC sub protocol:
+ </p>
+ <ul>
+ <li><code>jdbc:firebirdsql</code></li>
+ </ul>
+ <p> </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> </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> </p>
+ <p>
+ Platform identifier:
+ </p>
+ <ul>
+ <li><code>HsqlDb</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC driver:
+ </p>
+ <ul>
+ <li><code>org.hsqldb.jdbcDriver</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC sub protocol:
+ </p>
+ <ul>
+ <li><code>jdbc:hsqldb</code></li>
+ </ul>
+ <p> </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> </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> </p>
+ <p>
+ Platform identifier:
+ </p>
+ <ul>
+ <li><code>Interbase</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC driver:
+ </p>
+ <ul>
+ <li><code>interbase.interclient.Driver</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC sub protocol:
+ </p>
+ <ul>
+ <li><code>jdbc:interbase</code></li>
+ </ul>
+ <p> </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> </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> </p>
+ <p>
+ Platform identifiers:
+ </p>
+ <ul>
+ <li><code>MaxDB</code></li>
+ <li><code>SapDB</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC driver:
+ </p>
+ <ul>
+ <li><code>com.sap.dbtech.jdbc.DriverSapDB</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC sub protocol:
+ </p>
+ <ul>
+ <li><code>jdbc:sapdb</code></li>
+ </ul>
+ <p> </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> </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> </p>
+ <p>
+ Platform identifier:
+ </p>
+ <ul>
+ <li><code>McKoi</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC driver:
+ </p>
+ <ul>
+ <li><code>com.mckoi.JDBCDriver</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC sub protocol:
+ </p>
+ <ul>
+ <li><code>jdbc:mckoi</code></li>
+ </ul>
+ <p> </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> </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> </p>
+ <p>
+ Platform identifiers:
+ </p>
+ <ul>
+ <li><code>MySQL</code></li>
+ <li><code>MySQL5</code></li>
+ </ul>
+ <p> </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> </p>
+ <p>
+ Recognized JDBC sub protocol:
+ </p>
+ <ul>
+ <li><code>jdbc:mysql</code></li>
+ </ul>
+ <p> </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> </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> </p>
+ <p>
+ Platform identifiers:
+ </p>
+ <ul>
+ <li><code>Oracle</code></li>
+ <li><code>Oracle9</code></li>
+ <li><code>Oracle10</code></li>
+ </ul>
+ <p> </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> </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> </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> </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>