在使用hibernate的访问derby的时候,遇到了一个问题,就是如何映射boolean类型的数据呢?
搜索版体半天无果。
原来derby不支持boolean,
来源http://db.apache.org/ddlutils/databases/derby.html
JDBC Type | Database Type |
---|
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 | |