Home
 

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