db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From to...@apache.org
Subject svn commit: r479070 [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...
Date Sat, 25 Nov 2006 02:25:36 GMT
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>&nbsp;</p>
+    <p>
+      Platform identifier:
+    </p>
+    <ul>
+      <li><code>PostgreSql</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC driver:
+    </p>
+    <ul>
+      <li><code>org.postgresql.Driver</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <p>
+      Recognized JDBC sub protocol:
+    </p>
+    <ul>
+      <li><code>jdbc:postgresql</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <td class="platformPropName">The database supports SQL comments</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports delimited identifiers</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database's maximum identifier length</td>
+        <td class="platformPropValue">31</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports default values for <code>LONG</code>
types</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils uses sequences for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-primary key columns
as identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database allows INSERT/UPDATE statements to
set values for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can read back the auto-generated value
of an identity column</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-unique indices</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can create a database via JDBC</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can drop a database via JDBC</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+    </table>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <th class="typeMappingJdbcType">JDBC Type</th>
+        <th class="typeMappingNativeType">Database Type</th>
+        <th class="typeMappingComments">Additional comments</th>
+      </tr>
+      <tr>
+        <td>ARRAY</td>
+        <td>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>&nbsp;</p>
+    <p>
+      Platform identifier:
+    </p>
+    <ul>
+      <li><code>MsSql</code></li>
+    </ul>
+    <p>&nbsp;</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>&nbsp;</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>&nbsp;</p>
+    <table>
+      <tr>
+        <td class="platformPropName">The database supports SQL comments</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports delimited identifiers</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database's maximum identifier length</td>
+        <td class="platformPropValue">128</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports default values for <code>LONG</code>
types</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils uses sequences for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-primary key columns
as identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database allows INSERT/UPDATE statements to
set values for identity columns</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can read back the auto-generated value
of an identity column</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports non-unique indices</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can create a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">DdlUtils can drop a database via JDBC</td>
+        <td class="platformPropValue">no</td>
+      </tr>
+    </table>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <th class="typeMappingJdbcType">JDBC Type</th>
+        <th class="typeMappingNativeType">Database Type</th>
+        <th class="typeMappingComments">Additional comments</th>
+      </tr>
+      <tr>
+        <td>ARRAY</td>
+        <td>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>&nbsp;</p>
+    <p>
+      Platform identifier:
+    </p>
+    <ul>
+      <li><code>Sybase</code></li>
+    </ul>
+    <p>&nbsp;</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>&nbsp;</p>
+    <p>
+      Recognized JDBC sub protocol:
+    </p>
+    <ul>
+      <li><code>jdbc:sybase:Tds</code></li>
+    </ul>
+    <p>&nbsp;</p>
+    <table>
+      <tr>
+        <td class="platformPropName">The database supports SQL comments</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database supports delimited identifiers</td>
+        <td class="platformPropValue">yes</td>
+      </tr>
+      <tr>
+        <td class="platformPropName">The database's maximum identifier length</td>
+        <td class="platformPropValue">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>&nbsp;</p>
+    <table>
+      <tr>
+        <th class="typeMappingJdbcType">JDBC Type</th>
+        <th class="typeMappingNativeType">Database Type</th>
+        <th class="typeMappingComments">Additional comments</th>
+      </tr>
+      <tr>
+        <td>ARRAY</td>
+        <td>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);



Mime
View raw message