Im trying to get lift to work with DB2 for two days now, but I still havent figured it out. I use com.ibm.db2.jcc.DB2Driver and can connect to a database now (user table is created), but whenever I try to register a new user (causing the app to write into the database) I get an exception:

com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][10271][10296] unrecognized JDBC-Type: 16.

I use the following DriverType:

object DB2DriverType extends DriverType("DB2/NT")
{
def binaryColumnType = "LONG VARCHAR FOR BIT DATA"
def booleanColumnType = "SMALLINT"
def clobColumnType = "LONG VARCHAR"
def dateTimeColumnType = "TIMESTAMP"
def dateColumnType = "DATE"
def timeColumnType = "TIME"
def integerColumnType = "INT"
def integerIndexColumnType = "INTEGER NOT NULL GENERATED BY DEFAULT AS IDENITY"
def enumColumnType = "INT"
def longForeignKeyColumnType = "INT"
def longIndexColumnType = "INT NOT NULL GENERATED BY DEFAULT AS IDENTITY"
def enumListColumnType = "INT"
def longColumnType = "INT"
def doubleColumnType = "DOUBLE"

override def brokenLimit_? : Boolean = true
override def pkDefinedByIndexColumn_? = true
override def defaultSchemaName : Box[String] = Full("DB2ADMIN")
}

Derek Chen-Becker wrote on the mailing list:

This is the DB2 JDBC driver not honoring a Boolean value when using setObject. You can see here that 16 is the value of java.sql.Types.BOOLEAN:

http://download.oracle.com/javase/6/docs/api/constant-values.html#java.sql.Types.BOOLEAN

And this IBM document states that DB2 doesn't have direct support for Boolean or Byte types:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.java.doc/doc/rjvjdata.htm

This will require a small change to Mapper code to get it working. Please open a ticket.

Derek