Apache DB | DdlUtils | for

Home

Section |
apache.org > db > ddlutils | PDF
## Derby/Cloudscape DdlUtils supports Cloudscape version 10.0. Information about the SQL elements and datatypes of Cloudscape is found in the IBM Cloudscape Reference Manual. The Apache Derby project is based upon Cloudscape version 10, which IBM contributed to Apache in 2004. The SQL syntax and datatypes supported by Derby are described in the Datatypes section in the Reference Manual. Note Because development and support of Cloudscape has ended in favor of Derby, the DdlUtils support for Cloudscape is legacy and will likely be removed in future versions. If you use Cloudscape we strongly suggest that you update to Derby. Platform identifiers: Derby for the Derby platform Cloudscape for the Cloudscape platform Recognized JDBC drivers: org.apache.derby.jdbc.ClientDriver (Derby) org.apache.derby.jdbc.EmbeddedDriver (Derby) Recognized JDBC sub protocols: jdbc:derby (Derby) jdbc:db2j:net (Cloudscape) jdbc:cloudscape:net (Cloudscape)
The database supports SQL comments | yes
The database supports delimited identifiers | yes
The database's maximum identifier length | 128
The database supports default values for LONG types | yes
DdlUtils uses sequences for identity columns | no
The database supports non-primary key columns as identity columns | yes
The database allows INSERT/UPDATE statements to set values for identity columns | yes
DdlUtils can read back the auto-generated value of an identity column | yes
The database supports non-unique indices | yes
DdlUtils can create a database via JDBC | yes
DdlUtils can drop a database via JDBC | no
JDBC Type | Database Type | Additional comments
--- | --- | ---
ARRAY | BLOB | Will be read back as BLOB
BIGINT | BIGINT |
BINARY | CHAR(n) FOR BIT DATA |
BIT | SMALLINT | Cloudscape/Derby have no native boolean type Will be read back as SMALLINT
BLOB | BLOB |
BOOLEAN | SMALLINT | Cloudscape/Derby have no native boolean type Will be read back as BOOLEAN
CHAR | CHAR |
CLOB | CLOB |
DATALINK | LONG VARCHAR FOR BIT DATA | Will be read back as LONGVARBINARY
DATE | DATE |
DECIMAL | DECIMAL |
DISTINCT | BLOB | Will be read back as BLOB
DOUBLE | Cloudscape: DOUBLE PRECISION Derby: DOUBLE |
FLOAT | Cloudscape: DOUBLE PRECISION Derby: DOUBLE | Will be read back as DOUBLE
INTEGER | INTEGER |
JAVA_OBJECT | BLOB | Will be read back as BLOB
LONGVARBINARY | LONG VARCHAR FOR BIT DATA |
LONGVARCHAR | LONG VARCHAR |
NULL | LONG VARCHAR FOR BIT DATA | Will be read back as LONGVARBINARY
NUMERIC | NUMERIC |
OTHER | BLOB | Will be read back as BLOB
REAL | REAL |
REF | LONG VARCHAR FOR BIT DATA | Will be read back as LONGVARBINARY
SMALLINT | SMALLINT |
STRUCT | BLOB | Will be read back as BLOB
TIME | TIME |
TIMESTAMP | TIMESTAMP |
TINYINT | SMALLINT | Will be read back as SMALLINT
VARBINARY | VARCHAR(n) FOR BIT DATA |
VARCHAR | VARCHAR |