Apache DB | DdlUtils | for

Home

Section |
apache.org > db > ddlutils | PDF
## MaxDB/SapDB The SapDB database was open-sourced and rebranded MaxDB beginning with version 7.4. DdlUtils supports SapDB version 7.2 and MaxDB version 7.5, and newer. Documentation of the SQL supported by SapDB is found in the Reference manual. Likewise, documentation for MaxDB is contained in the MaxDB documentation. Platform identifiers: MaxDB SapDB Recognized JDBC driver: com.sap.dbtech.jdbc.DriverSapDB Recognized JDBC sub protocol: jdbc:sapdb
The database supports SQL comments | yes
The database supports delimited identifiers | yes
The database's maximum identifier length | 32
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 | no
DdlUtils can drop a database via JDBC | no
JDBC Type | Database Type | Additional comments
--- | --- | ---
ARRAY | LONG BYTE | Will be read back as LONGVARBINARY
BIGINT | FIXED(38,0) |
BINARY | CHAR(n) BYTE |
BIT | BOOLEAN |
BLOB | LONG BYTE | Will be read back as LONGVARBINARY
BOOLEAN | BOOLEAN | Will be read back as BIT
CHAR | CHAR |
CLOB | LONG | Will be read back as LONGVARCHAR
DATALINK | LONG BYTE | Will be read back as LONGVARBINARY
DATE | DATE |
DECIMAL | FIXED |
DISTINCT | LONG BYTE | Will be read back as LONGVARBINARY
DOUBLE | FLOAT(38) | Will be read back as FLOAT
FLOAT | FLOAT(38) |
INTEGER | INTEGER |
JAVA_OBJECT | LONG BYTE | Will be read back as LONGVARBINARY
LONGVARBINARY | LONG BYTE |
LONGVARCHAR | LONG |
NULL | LONG BYTE | Will be read back as LONGVARBINARY
NUMERIC | FIXED | Will be read back as DECIMAL
OTHER | LONG BYTE | Will be read back as LONGVARBINARY
REAL | FLOAT(16) | Will be read back as FLOAT
REF | LONG BYTE | Will be read back as LONGVARBINARY
SMALLINT | SMALLINT |
STRUCT | LONG BYTE | Will be read back as LONGVARBINARY
TIME | TIME |
TIMESTAMP | TIMESTAMP |
TINYINT | SMALLINT | Will be read back as SMALLINT
VARBINARY | VARCHAR(n) BYTE |
VARCHAR | VARCHAR |