This driver implements slick.driver.JdbcProfilewithout the following capabilities:
slick.profile.RelationalProfile.capabilities.reverse:
This String function is not available in DB2.
slick.driver.JdbcProfile.capabilities.insertOrUpdate:
InsertOrUpdate operations are emulated on the client side if generated
keys should be returned. Otherwise the operation is performmed
natively on the server side.
slick.driver.JdbcProfile.capabilities.booleanMetaData:
DB2 doesn't have booleans, so Slick maps to SMALLINT instead.
Other jdbc drivers like MySQL map TINYINT(1) back to a Scala
Boolean. DB2 maps SMALLINT to an Integer and that's how it shows
up in the jdbc meta data, thus the original type is lost.
slick.driver.JdbcProfile.capabilities.supportsByte:
DB2 does not have a BYTE type.
Note: The DB2 JDBC driver has problems with quoted identifiers. Columns
which are returned from inserts must not require quoted names (in
particular, they must not contain lower-case characters or be equal to a
reserved word), otherwise a bug in the DB2 JDBC driver triggers a SQL
Error -206 (SQLState 42703).
Slick driver for IBM DB2 UDB.
This driver implements
slick.driver.JdbcProfilewithout the following capabilities:Note: The DB2 JDBC driver has problems with quoted identifiers. Columns which are returned from inserts must not require quoted names (in particular, they must not contain lower-case characters or be equal to a reserved word), otherwise a bug in the DB2 JDBC driver triggers a SQL Error -206 (SQLState 42703).