在使用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 | |