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 [2/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...
Added: db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/postgresql.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/postgresql.xml?view=auto&rev=479070
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/postgresql.xml (added)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/postgresql.xml Fri Nov 24 18:25:35 2006
@@ -0,0 +1,257 @@
+<?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>PostgreSQL</title>
+ </header>
+ <body>
+ <p>
+ DdlUtils supports <a href="ext:postgresql">PostgreSQL</a> version <strong>7.2.8</strong> and newer. SQL syntax
+ details and supported datatypes are described in the <a href="ext:postgresql/manual">Manual</a>.
+ </p>
+ <p> </p>
+ <p>
+ Platform identifier:
+ </p>
+ <ul>
+ <li><code>PostgreSql</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC driver:
+ </p>
+ <ul>
+ <li><code>org.postgresql.Driver</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC sub protocol:
+ </p>
+ <ul>
+ <li><code>jdbc:postgresql</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">yes</td>
+ </tr>
+ <tr>
+ <td class="platformPropName">DdlUtils can drop a database via JDBC</td>
+ <td class="platformPropValue">yes</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>BYTEA</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>BYTEA</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>BIT</td>
+ <td>BOOLEAN</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>BLOB</td>
+ <td>BYTEA</td>
+ <td></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>TEXT</td>
+ <td>Will be read back as LONGVARCHAR</td>
+ </tr>
+ <tr>
+ <td>DATALINK</td>
+ <td>BYTEA</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>NUMERIC</td>
+ <td>Will be read back as NUMERIC</td>
+ </tr>
+ <tr>
+ <td>DISTINCT</td>
+ <td>BYTEA</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>BYTEA</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>LONGVARBINARY</td>
+ <td>BYTEA</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>LONGVARCHAR</td>
+ <td>TEXT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>NULL</td>
+ <td>BYTEA</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>BYTEA</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>REAL</td>
+ <td>REAL</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>REF</td>
+ <td>BYTEA</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>BYTEA</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>BYTEA</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/sqlserver.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/sqlserver.xml?view=auto&rev=479070
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/sqlserver.xml (added)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/sqlserver.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>SQL Server</title>
+ </header>
+ <body>
+ <p>
+ The <a href="ext:sqlserver">SQL Server</a> is supported form version <strong>6.5</strong> onwards.
+ Information about the versions prior to SQL Server 2000 however is difficult to find online, you'll
+ have to resort to the documentation accompanying the database. Information for version 2000 can be found
+ <a href="ext:sqlserver/manual-2000">here</a>.
+ </p>
+ <p>
+ If possible, you should use the newest driver available. The older JDBC drivers (for SQL Server 2000 and
+ older) provided my Microsoft, are known to be buggy and slow. The new SQL Server 2005 driver is preferred
+ and can also work with SQL Server 2000.
+ </p>
+ <p> </p>
+ <p>
+ Platform identifier:
+ </p>
+ <ul>
+ <li><code>MsSql</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC drivers:
+ </p>
+ <ul>
+ <li><code>com.microsoft.jdbc.sqlserver.SQLServerDriver</code></li>
+ <li><code>com.microsoft.sqlserver.jdbc.SQLServerDriver</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC sub protocols:
+ </p>
+ <ul>
+ <li><code>jdbc:microsoft:sqlserver</code></li>
+ <li><code>jdbc:sqlserver</code></li>
+ <li><code>jdbc:sqljdbc</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">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">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>IMAGE</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>BIGINT</td>
+ <td>DECIMAL(19,0)</td>
+ <td>A native BIGINT type is supported only since SQL Server 2000</td>
+ </tr>
+ <tr>
+ <td>BINARY</td>
+ <td>BINARY</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>BIT</td>
+ <td>BIT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>BLOB</td>
+ <td>IMAGE</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>BOOLEAN</td>
+ <td>BIT</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>TEXT</td>
+ <td>Will be read back as LONGVARCHAR</td>
+ </tr>
+ <tr>
+ <td>DATALINK</td>
+ <td>IMAGE</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>DATE</td>
+ <td>DATETIME</td>
+ <td>Will be read back as TIMESTAMP</td>
+ </tr>
+ <tr>
+ <td>DECIMAL</td>
+ <td>DECIMAL</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>DISTINCT</td>
+ <td>IMAGE</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>DOUBLE</td>
+ <td>FLOAT</td>
+ <td>Will be read back as FLOAT</td>
+ </tr>
+ <tr>
+ <td>FLOAT</td>
+ <td>FLOAT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>INTEGER</td>
+ <td>INT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>JAVA_OBJECT</td>
+ <td>IMAGE</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>LONGVARBINARY</td>
+ <td>IMAGE</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>LONGVARCHAR</td>
+ <td>TEXT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>NULL</td>
+ <td>IMAGE</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>IMAGE</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>REAL</td>
+ <td>REAL</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>REF</td>
+ <td>IMAGE</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>IMAGE</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>TIME</td>
+ <td>DATETIME</td>
+ <td>Will be read back as TIMESTAMP</td>
+ </tr>
+ <tr>
+ <td>TIMESTAMP</td>
+ <td>DATETIME</td>
+ <td>The native <code>TIMESTAMP</code> type of SQL Server serves a different purpose: it provides a counter
+ that automatically increments upon each insertion or update of the table.</td>
+ </tr>
+ <tr>
+ <td>TINYINT</td>
+ <td>SMALLINT</td>
+ <td>The native <code>TINYINT</code> type only supports values between 0 and 255.<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/sybase.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/sybase.xml?view=auto&rev=479070
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/sybase.xml (added)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/databases/sybase.xml Fri Nov 24 18:25:35 2006
@@ -0,0 +1,264 @@
+<?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>Sybase</title>
+ </header>
+ <body>
+ <p>
+ DdlUtils supports the Sybase products <a href="ext:sybase/sqlserver">SQL Server</a> from version
+ <strong>10.0</strong> on, and <a href="ext:sybase/ase">Adaptive Server Enterprise</a> from version
+ <strong>11.5</strong> on. The Sybase documentation can be found in the
+ <a href="ext:sybase/manual-archive">Archive</a> in the <em>Transact-SQL User's Guide</em> document
+ for the respective version. The manual for the newest version is found <a href="ext:sybase/manual">here</a>.
+ </p>
+ <p> </p>
+ <p>
+ Platform identifier:
+ </p>
+ <ul>
+ <li><code>Sybase</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC drivers:
+ </p>
+ <ul>
+ <li><code>com.sybase.jdbc2.jdbc.SybDriver</code></li>
+ <li><code>com.sybase.jdbc.SybDriver</code></li>
+ </ul>
+ <p> </p>
+ <p>
+ Recognized JDBC sub protocol:
+ </p>
+ <ul>
+ <li><code>jdbc:sybase:Tds</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">28</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>IMAGE</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>BIGINT</td>
+ <td>DECIMAL(19,0)</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>BINARY</td>
+ <td>BINARY</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>BIT</td>
+ <td>SMALLINT</td>
+ <td>The native BIT type is rather limited (cannot be NULL, cannot be indexed), hence DdlUtils uses SMALLINT instead.<br/>
+ Will be read back as SMALLINT</td>
+ </tr>
+ <tr>
+ <td>BLOB</td>
+ <td>IMAGE</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>BOOLEAN</td>
+ <td>SMALLINT</td>
+ <td>The native BIT type is rather limited (cannot be NULL, cannot be indexed), hence DdlUtils uses SMALLINT instead.<br/>
+ Will be read back as SMALLINT</td>
+ </tr>
+ <tr>
+ <td>CHAR</td>
+ <td>CHAR</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>CLOB</td>
+ <td>TEXT</td>
+ <td>Will be read back as LONGVARCHAR</td>
+ </tr>
+ <tr>
+ <td>DATALINK</td>
+ <td>IMAGE</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>DATE</td>
+ <td>DATETIME</td>
+ <td>Will be read back as TIMSTAMP</td>
+ </tr>
+ <tr>
+ <td>DECIMAL</td>
+ <td>DECIMAL</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>DISTINCT</td>
+ <td>IMAGE</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>INT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>JAVA_OBJECT</td>
+ <td>IMAGE</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>LONGVARBINARY</td>
+ <td>IMAGE</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>LONGVARCHAR</td>
+ <td>TEXT</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>NULL</td>
+ <td>IMAGE</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>IMAGE</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>REAL</td>
+ <td>REAL</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>REF</td>
+ <td>IMAGE</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>IMAGE</td>
+ <td>Will be read back as LONGVARBINARY</td>
+ </tr>
+ <tr>
+ <td>TIME</td>
+ <td>DATETIME</td>
+ <td>Will be read back as TIMESTAMP</td>
+ </tr>
+ <tr>
+ <td>TIMESTAMP</td>
+ <td>DATETIME</td>
+ <td>Will be read back as TIMESTAMP</td>
+ </tr>
+ <tr>
+ <td>TINYINT</td>
+ <td>SMALLINT</td>
+ <td>The native <code>TINYINT</code> type only supports values between 0 and 255.<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>
Modified: db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/site.xml
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/site.xml?view=diff&rev=479070&r1=479069&r2=479070
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/site.xml (original)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/site.xml Fri Nov 24 18:25:35 2006
@@ -37,7 +37,6 @@
<about label="About">
<index label="Home" href="index.html" description="Welcome to DdlUtils"/>
<changes label="Release Notes" href="release-notes.html" description="Release Notes" />
- <todo label="Todo" href="to-do.html" description="ToDo list" />
<mail-lists label="Mailing lists" href="mail-lists.html" description="Info about DdlUtils' mailing lists"/>
<jira label="Bug database (JIRA)" href="ext:ddlutils/jira"/>
</about>
Modified: db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/mssql/MSSqlPlatform.java
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/mssql/MSSqlPlatform.java?view=diff&rev=479070&r1=479069&r2=479070
==============================================================================
--- db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/mssql/MSSqlPlatform.java (original)
+++ db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/mssql/MSSqlPlatform.java Fri Nov 24 18:25:35 2006
@@ -52,19 +52,14 @@
PlatformInfo info = getPlatformInfo();
info.setMaxIdentifierLength(128);
- info.setNullAsDefaultValueRequired(false);
- info.setPrimaryKeyEmbedded(true);
- info.setForeignKeysEmbedded(false);
- info.setIndicesEmbedded(false);
- //info.setCommentPrefix("#");
- info.addNativeTypeMapping(Types.ARRAY, "IMAGE");
+ info.addNativeTypeMapping(Types.ARRAY, "IMAGE", Types.LONGVARBINARY);
// BIGINT will be mapped back to BIGINT by the model reader
info.addNativeTypeMapping(Types.BIGINT, "DECIMAL(19,0)");
info.addNativeTypeMapping(Types.BLOB, "IMAGE", Types.LONGVARBINARY);
info.addNativeTypeMapping(Types.CLOB, "TEXT", Types.LONGVARCHAR);
info.addNativeTypeMapping(Types.DATE, "DATETIME", Types.TIMESTAMP);
- info.addNativeTypeMapping(Types.DISTINCT, "IMAGE");
+ info.addNativeTypeMapping(Types.DISTINCT, "IMAGE", Types.LONGVARBINARY);
info.addNativeTypeMapping(Types.DOUBLE, "FLOAT", Types.FLOAT);
info.addNativeTypeMapping(Types.INTEGER, "INT");
info.addNativeTypeMapping(Types.JAVA_OBJECT, "IMAGE", Types.LONGVARBINARY);
Modified: db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/oracle/Oracle8Platform.java
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/oracle/Oracle8Platform.java?view=diff&rev=479070&r1=479069&r2=479070
==============================================================================
--- db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/oracle/Oracle8Platform.java (original)
+++ db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/oracle/Oracle8Platform.java Fri Nov 24 18:25:35 2006
@@ -55,10 +55,6 @@
PlatformInfo info = getPlatformInfo();
info.setMaxIdentifierLength(30);
- info.setNullAsDefaultValueRequired(false);
- info.setPrimaryKeyEmbedded(true);
- info.setForeignKeysEmbedded(false);
- info.setIndicesEmbedded(false);
info.setIdentityStatusReadingSupported(false);
// Note that the back-mappings are partially done by the model reader, not the driver
Modified: db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java?view=diff&rev=479070&r1=479069&r2=479070
==============================================================================
--- db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java (original)
+++ db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java Fri Nov 24 18:25:35 2006
@@ -58,10 +58,6 @@
// this is the default length though it might be changed when building PostgreSQL
// in file src/include/postgres_ext.h
info.setMaxIdentifierLength(31);
- info.setNullAsDefaultValueRequired(false);
- info.setPrimaryKeyEmbedded(true);
- info.setForeignKeysEmbedded(false);
- info.setIndicesEmbedded(false);
info.addNativeTypeMapping(Types.ARRAY, "BYTEA", Types.LONGVARBINARY);
info.addNativeTypeMapping(Types.BINARY, "BYTEA", Types.LONGVARBINARY);
Modified: db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/sybase/SybasePlatform.java
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/sybase/SybasePlatform.java?view=diff&rev=479070&r1=479069&r2=479070
==============================================================================
--- db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/sybase/SybasePlatform.java (original)
+++ db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/sybase/SybasePlatform.java Fri Nov 24 18:25:35 2006
@@ -67,17 +67,14 @@
info.setMaxIdentifierLength(28);
info.setNullAsDefaultValueRequired(true);
- info.setPrimaryKeyEmbedded(true);
- info.setForeignKeysEmbedded(false);
- info.setIndicesEmbedded(false);
info.setCommentPrefix("/*");
info.setCommentSuffix("*/");
info.addNativeTypeMapping(Types.ARRAY, "IMAGE");
- // we're not using the native BIT type because it is rather limited (cannot be NULL, cannot be indexed)
- info.addNativeTypeMapping(Types.BIT, "SMALLINT", Types.SMALLINT);
// BIGINT is mapped back in the model reader
info.addNativeTypeMapping(Types.BIGINT, "DECIMAL(19,0)");
+ // we're not using the native BIT type because it is rather limited (cannot be NULL, cannot be indexed)
+ info.addNativeTypeMapping(Types.BIT, "SMALLINT", Types.SMALLINT);
info.addNativeTypeMapping(Types.BLOB, "IMAGE", Types.LONGVARBINARY);
info.addNativeTypeMapping(Types.CLOB, "TEXT", Types.LONGVARCHAR);
info.addNativeTypeMapping(Types.DATE, "DATETIME", Types.TIMESTAMP);