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);
