Home
 

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