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 2011/06/13 08:19:55 UTC
svn commit: r1135031 [2/2] - in /db/ddlutils/trunk/src/site/sphinx: ./
databases/
Added: db/ddlutils/trunk/src/site/sphinx/databases/oracle.rst
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/site/sphinx/databases/oracle.rst?rev=1135031&view=auto
==============================================================================
--- db/ddlutils/trunk/src/site/sphinx/databases/oracle.rst (added)
+++ db/ddlutils/trunk/src/site/sphinx/databases/oracle.rst Mon Jun 13 06:19:54 2011
@@ -0,0 +1,158 @@
+.. 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.
+
+.. _`Oracle database`: http://www.oracle.com/us/products/database/index.html
+.. _`Oracle database documentation`: http://www.oracle.com/technetwork/indexes/documentation/index.html#database
+
+Oracle
+======
+
+DdlUtils has support for the `Oracle database`_ for versions 8.1.7 and above.
+
+Info about the datatypes and SQL elements supported in the individual versions can be found in the
+Oracle SQL Reference which can be accessed via the `Oracle database documentation`_.
+
+DdlUtils provides different platforms for Oracle v8, v9, and v10. The v9 platform adds support for
+the native ``TIMESTAMP`` type, and the v10 platform handles the recycle bin that was introduced in
+version 10 of the Oracle database.
+
+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.
+
+Constraints
+-----------
+
+Platform identifier
+ | ``Oracle``
+ | ``Oracle9``
+ | ``Oracle10``
+
+Recognized JDBC drivers
+ | ``oracle.jdbc.driver.OracleDriver``
+ | ``oracle.jdbc.dnlddriver.OracleDriver``
+
+Recognized JDBC sub protocols
+ | ``jdbc:oracle:thin``
+ | ``jdbc:oracle:oci8``
+ | ``jdbc:oracle:dnldthin``
+
+Supports SQL comments
+ yes
+
+Supports delimited identifiers
+ yes
+
+Maximum identifier length
+ 30
+
+Supports default values for ``LONG`` types
+ yes
+
+Supports non-unique indices
+ yes
+
+Supports non-primary key columns as identity columns
+ yes
+
+Allows ``INSERT``/``UPDATE`` statements to set values for identity columns
+ yes
+
+DdlUtils uses sequences for identity columns
+ yes
+
+DdlUtils can read back the auto-generated value of an identity column
+ yes
+
+DdlUtils can create a database via JDBC
+ no
+
+DdlUtils can drop a database via JDBC
+ no
+
+Datatypes
+---------
+
++-----------------+--------------------------------+---------------------------------------------+
+|JDBC Type |Database Type |Additional comments |
++=================+================================+=============================================+
+|``ARRAY`` |``BLOB`` |Will be read back as ``BLOB`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``BIGINT`` |``NUMBER(38)`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``BINARY`` |``RAW`` |Oracle requires the specification of the size|
+| | |for ``RAW`` columns. If no size was |
+| | |specified, then 254 is used. Will be read |
+| | |back as ``VARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``BIT`` |``NUMBER(1)`` |Oracle has no native boolean type. |
++-----------------+--------------------------------+---------------------------------------------+
+|``BLOB`` |``BLOB`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``BOOLEAN`` |``NUMBER(1)`` |Oracle has no native boolean type. |
++-----------------+--------------------------------+---------------------------------------------+
+|``CHAR`` |``CHAR`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``CLOB`` |``CLOB`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``DATALINK`` |``BLOB`` |Will be read back as ``BLOB`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``DATE`` |``DATE`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``DECIMAL`` |``NUMBER`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``DISTINCT`` |``BLOB`` |Will be read back as ``BLOB`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``DOUBLE`` |``DOUBLE PRECISION`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``FLOAT`` |``FLOAT`` |Will be read back as ``DOUBLE`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``INTEGER`` |``INTEGER`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``JAVA_OBJECT`` |``BLOB`` |Will be read back as ``BLOB`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``LONGVARBINARY``|``BLOB`` |Will be read back as ``BLOB`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``LONGVARCHAR`` |``CLOB`` |Will be read back as ``CLOB`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``NULL`` |``BLOB`` |Will be read back as ``BLOB`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``NUMERIC`` |``NUMBER`` |Will be read back as ``DECIMAL`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``OTHER`` |``BLOB`` |Will be read back as ``BLOB`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``REAL`` |``REAL`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``REF`` |``BLOB`` |Will be read back as ``BLOB`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``SMALLINT`` |``NUMBER(5)`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``STRUCT`` |``BLOB`` |Will be read back as ``BLOB`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``TIME`` |``DATE`` |Will be read back as ``TIMESTAMP`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``TIMESTAMP`` |Oracle8: ``DATE`` |The TIMESTAMP native type is only supported |
+| |Oracle9/10: ``TIMESTAMP`` |in Oracle 9 and above. |
++-----------------+--------------------------------+---------------------------------------------+
+|``TINYINT`` |``NUMBER(3)`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``VARBINARY`` |``RAW`` |Oracle requires the specification of the size|
+| | |for ``RAW`` columns. If no size was |
+| | |specified, then 254 is used. |
++-----------------+--------------------------------+---------------------------------------------+
+|``VARCHAR`` |``VARCHAR2`` | |
++-----------------+--------------------------------+---------------------------------------------+
Added: db/ddlutils/trunk/src/site/sphinx/databases/postgresql.rst
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/site/sphinx/databases/postgresql.rst?rev=1135031&view=auto
==============================================================================
--- db/ddlutils/trunk/src/site/sphinx/databases/postgresql.rst (added)
+++ db/ddlutils/trunk/src/site/sphinx/databases/postgresql.rst Mon Jun 13 06:19:54 2011
@@ -0,0 +1,137 @@
+.. 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.
+
+.. _`PostgreSQL`: http://www.postgresql.org/
+.. _`Manual`: http://www.postgresql.org/docs/7.4/interactive/index.html
+
+PostgreSQL
+==========
+
+DdlUtils supports `PostgreSQL`_ version 7.2.8 and newer. SQL syntax details and supported
+datatypes are described in the `Manual`_.
+
+Constraints
+-----------
+
+Platform identifier
+ ``PostgreSql``
+
+Recognized JDBC drivers
+ ``org.postgresql.Driver``
+
+Recognized JDBC sub protocols
+ ``jdbc:oracle:postgresql``
+
+Supports SQL comments
+ yes
+
+Supports delimited identifiers
+ yes
+
+Maximum identifier length
+ 31
+
+Supports default values for ``LONG`` types
+ yes
+
+Supports non-unique indices
+ yes
+
+Supports non-primary key columns as identity columns
+ yes
+
+Allows ``INSERT``/``UPDATE`` statements to set values for identity columns
+ yes
+
+DdlUtils uses sequences for identity columns
+ yes
+
+DdlUtils can read back the auto-generated value of an identity column
+ yes
+
+DdlUtils can create a database via JDBC
+ yes
+
+DdlUtils can drop a database via JDBC
+ yes
+
+Datatypes
+---------
+
++-----------------+--------------------------------+---------------------------------------------+
+|JDBC Type |Database Type |Additional comments |
++=================+================================+=============================================+
+|``ARRAY`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``BIGINT`` |``BIGINT`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``BINARY`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``BIT`` |``BOOLEAN`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``BLOB`` |``BYTEA`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``BOOLEAN`` |``BOOLEAN`` |Will be read back as ``BIT`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``CHAR`` |``CHAR`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``CLOB`` |``TEXT`` |Will be read back as ``LONGVARCHAR`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``DATALINK`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``DATE`` |``DATE`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``DECIMAL`` |``NUMERIC`` |Will be read back as ``NUMERIC`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``DISTINCT`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``DOUBLE`` |``DOUBLE PRECISION`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``FLOAT`` |``DOUBLE PRECISION`` |Will be read back as ``DOUBLE`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``INTEGER`` |``INTEGER`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``JAVA_OBJECT`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``LONGVARBINARY``|``BYTEA`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``LONGVARCHAR`` |``TEXT`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``NULL`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``NUMERIC`` |``NUMERIC`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``OTHER`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``REAL`` |``REAL`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``REF`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``SMALLINT`` |``SMALLINT`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``STRUCT`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``TIME`` |``TIME`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``TIMESTAMP`` |``TIMESTAMP`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``TINYINT`` |``SMALLINT`` |Will be read back as ``SMALLINT`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``VARBINARY`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``VARCHAR`` |``VARCHAR`` | |
++-----------------+--------------------------------+---------------------------------------------+
Added: db/ddlutils/trunk/src/site/sphinx/databases/sqlserver.rst
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/site/sphinx/databases/sqlserver.rst?rev=1135031&view=auto
==============================================================================
--- db/ddlutils/trunk/src/site/sphinx/databases/sqlserver.rst (added)
+++ db/ddlutils/trunk/src/site/sphinx/databases/sqlserver.rst Mon Jun 13 06:19:54 2011
@@ -0,0 +1,152 @@
+.. 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.
+
+.. _`Microsoft SQL Server`: http://msdn2.microsoft.com/en-us/sql/default.aspx
+.. _`Transact-SQL manual`: http://msdn.microsoft.com/en-us/library/Aa260642
+
+SQL Server
+==========
+
+The `Microsoft SQL Server`_ is supported form version 6.5 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
+in the `Transact-SQL manual`_.
+
+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 newer SQL Server drivers (2005 and newer)
+are preferred and can also work with SQL Server 2000.
+
+Constraints
+-----------
+
+Platform identifier
+ ``MsSql``
+
+Recognized JDBC drivers
+ | ``com.microsoft.jdbc.sqlserver.SQLServerDriver``
+ | ``com.microsoft.sqlserver.jdbc.SQLServerDriver``
+
+Recognized JDBC sub protocols
+ | ``jdbc:microsoft:sqlserver``
+ | ``jdbc:sqlserver``
+ | ``jdbc:sqljdbc``
+
+Supports SQL comments
+ yes
+
+Supports delimited identifiers
+ yes
+
+Maximum identifier length
+ 128
+
+Supports default values for ``LONG`` types
+ yes
+
+Supports non-unique indices
+ yes
+
+Supports non-primary key columns as identity columns
+ yes
+
+Allows ``INSERT``/``UPDATE`` statements to set values for identity columns
+ yes
+
+DdlUtils uses sequences for identity columns
+ yes
+
+DdlUtils can read back the auto-generated value of an identity column
+ yes
+
+DdlUtils can create a database via JDBC
+ no
+
+DdlUtils can drop a database via JDBC
+ no
+
+Datatypes
+---------
+
++-----------------+--------------------------------+---------------------------------------------+
+|JDBC Type |Database Type |Additional comments |
++=================+================================+=============================================+
+|``ARRAY`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``BIGINT`` |``DECIMAL(19,0)`` |A native BIGINT type is supported only since |
+| | |SQL Server 2000 |
++-----------------+--------------------------------+---------------------------------------------+
+|``BINARY`` |``BINARY`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``BIT`` |``BIT`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``BLOB`` |``IMAGE`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``BOOLEAN`` |``BIT`` |Will be read back as ``BIT`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``CHAR`` |``CHAR`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``CLOB`` |``TEXT`` |Will be read back as ``LONGVARCHAR`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``DATALINK`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``DATE`` |``DATETIME`` |Will be read back as ``TIMESTAMP`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``DECIMAL`` |``DECIMAL`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``DISTINCT`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``DOUBLE`` |``FLOAT`` |Will be read back as ``FLOAT`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``FLOAT`` |``FLOAT`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``INTEGER`` |``INT`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``JAVA_OBJECT`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``LONGVARBINARY``|``IMAGE`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``LONGVARCHAR`` |``TEXT`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``NULL`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``NUMERIC`` |``NUMERIC`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``OTHER`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``REAL`` |``REAL`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``REF`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``SMALLINT`` |``SMALLINT`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``STRUCT`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``TIME`` |``DATETIME`` |Will be read back as ``TIMESTAMP`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``TIMESTAMP`` |``DATETIME`` |The native ``TIMESTAMP`` type of SQL Server |
+| | |serves a different purpose: it provides a |
+| | |counter that automatically increments upon |
+| | |each insertion or update of the table. |
++-----------------+--------------------------------+---------------------------------------------+
+|``TINYINT`` |``SMALLINT`` |The native ``TINYINT`` type only supports |
+| | |values between 0 and 255. Will be read back |
+| | |as ``SMALLINT`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``VARBINARY`` |``VARBINARY`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``VARCHAR`` |``VARCHAR`` | |
++-----------------+--------------------------------+---------------------------------------------+
Added: db/ddlutils/trunk/src/site/sphinx/databases/sybase.rst
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/site/sphinx/databases/sybase.rst?rev=1135031&view=auto
==============================================================================
--- db/ddlutils/trunk/src/site/sphinx/databases/sybase.rst (added)
+++ db/ddlutils/trunk/src/site/sphinx/databases/sybase.rst Mon Jun 13 06:19:54 2011
@@ -0,0 +1,150 @@
+.. 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.
+
+.. _`SQL Server`: http://www.sybase.com/products/archivedproducts/sqlserver
+.. _`Adaptive Server Enterprise`: http://www.sybase.com/products/databasemanagement/adaptiveserverenterprise
+.. _`Documentation search`: http://sybooks.sybase.com/nav/base.do
+.. _`Documentation archive`: http://sybooks.sybase.com/nav/base.do?archive=1
+
+Sybase
+======
+
+DdlUtils supports the Sybase products `SQL Server`_ from version 10.0 on, and
+`Adaptive Server Enterprise`_ from version 11.5 on. The Sybase documentation for old versions
+can be found in the `Documentation archive`_. The manuals for the current versions can be
+found via the `Documentation search`_.
+
+Constraints
+-----------
+
+Platform identifier
+ ``Sybase``
+
+Recognized JDBC drivers
+ | ``com.sybase.jdbc2.jdbc.SybDriver``
+ | ``com.sybase.jdbc.SybDriver``
+
+Recognized JDBC sub protocols
+ ``jdbc:sybase:Tds``
+
+Supports SQL comments
+ yes
+
+Supports delimited identifiers
+ yes
+
+Maximum identifier length
+ 28
+
+Supports default values for ``LONG`` types
+ yes
+
+Supports non-unique indices
+ yes
+
+Supports non-primary key columns as identity columns
+ yes
+
+Allows ``INSERT``/``UPDATE`` statements to set values for identity columns
+ yes
+
+DdlUtils uses sequences for identity columns
+ no
+
+DdlUtils can read back the auto-generated value of an identity column
+ yes
+
+DdlUtils can create a database via JDBC
+ no
+
+DdlUtils can drop a database via JDBC
+ no
+
+Datatypes
+---------
+
++-----------------+--------------------------------+---------------------------------------------+
+|JDBC Type |Database Type |Additional comments |
++=================+================================+=============================================+
+|``ARRAY`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``BIGINT`` |``DECIMAL(19,0)`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``BINARY`` |``BINARY`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``BIT`` |``SMALLINT`` |The native ``BIT`` type is rather limited |
+| | |(cannot be NULL, cannot be indexed), hence |
+| | |DdlUtils uses ``SMALLINT`` instead. Will be |
+| | |read back as ``SMALLINT`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``BLOB`` |``IMAGE`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``BOOLEAN`` |``SMALLINT`` |The native ``BIT`` type is rather limited |
+| | |(cannot be NULL, cannot be indexed), hence |
+| | |DdlUtils uses ``SMALLINT`` instead. Will be |
+| | |read back as ``SMALLINT`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``CHAR`` |``CHAR`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``CLOB`` |``TEXT`` |Will be read back as ``LONGVARCHAR`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``DATALINK`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``DATE`` |``DATETIME`` |Will be read back as ``TIMESTAMP`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``DECIMAL`` |``DECIMAL`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``DISTINCT`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``DOUBLE`` |``DOUBLE PRECISION`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``FLOAT`` |``DOUBLE PRECISION`` |Will be read back as ``FLOAT`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``INTEGER`` |``INT`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``JAVA_OBJECT`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``LONGVARBINARY``|``IMAGE`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``LONGVARCHAR`` |``TEXT`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``NULL`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``NUMERIC`` |``NUMERIC`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``OTHER`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``REAL`` |``REAL`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``REF`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``SMALLINT`` |``SMALLINT`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``STRUCT`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``TIME`` |``DATETIME`` |Will be read back as ``TIMESTAMP`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``TIMESTAMP`` |``DATETIME`` |Will be read back as ``TIMESTAMP`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``TINYINT`` |``SMALLINT`` |The native ``TINYINT`` type only supports |
+| | |values between 0 and 255. Will be read back |
+| | |as ``SMALLINT`` |
++-----------------+--------------------------------+---------------------------------------------+
+|``VARBINARY`` |``VARBINARY`` | |
++-----------------+--------------------------------+---------------------------------------------+
+|``VARCHAR`` |``VARCHAR`` | |
++-----------------+--------------------------------+---------------------------------------------+
Modified: db/ddlutils/trunk/src/site/sphinx/index.rst
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/site/sphinx/index.rst?rev=1135031&r1=1135030&r2=1135031&view=diff
==============================================================================
--- db/ddlutils/trunk/src/site/sphinx/index.rst (original)
+++ db/ddlutils/trunk/src/site/sphinx/index.rst Mon Jun 13 06:19:54 2011
@@ -26,4 +26,5 @@ DdlUtils documentation
api-usage
ant-tasks
database-support
+ databases/index
schema
\ No newline at end of file