db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From to...@apache.org
Subject svn commit: r1135031 [2/2] - in /db/ddlutils/trunk/src/site/sphinx: ./ databases/
Date Mon, 13 Jun 2011 06:19:55 GMT
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



Mime
View raw message