derby支持的数据类型

在使用hibernate的访问derby的时候,遇到了一个问题,就是如何映射boolean类型的数据呢?

搜索版体半天无果。

原来derby不支持boolean,

来源http://db.apache.org/ddlutils/databases/derby.html

JDBC TypeDatabase TypeAdditional comments
ARRAYBLOBWill be read back as BLOB
BIGINTBIGINT 
BINARYCHAR(n) FOR BIT DATA 
BITSMALLINTCloudscape/Derby have no native boolean type
Will be read back as SMALLINT
BLOBBLOB 
BOOLEANSMALLINTCloudscape/Derby have no native boolean type
Will be read back as BOOLEAN
CHARCHAR 
CLOBCLOB 
DATALINKLONG VARCHAR FOR BIT DATAWill be read back as LONGVARBINARY
DATEDATE 
DECIMALDECIMAL 
DISTINCTBLOBWill be read back as BLOB
DOUBLECloudscape: DOUBLE PRECISION
Derby: DOUBLE
 
FLOATCloudscape: DOUBLE PRECISION
Derby: DOUBLE
Will be read back as DOUBLE
INTEGERINTEGER 
JAVA_OBJECTBLOBWill be read back as BLOB
LONGVARBINARYLONG VARCHAR FOR BIT DATA 
LONGVARCHARLONG VARCHAR 
NULLLONG VARCHAR FOR BIT DATAWill be read back as LONGVARBINARY
NUMERICNUMERIC 
OTHERBLOBWill be read back as BLOB
REALREAL 
REFLONG VARCHAR FOR BIT DATAWill be read back as LONGVARBINARY
SMALLINTSMALLINT 
STRUCTBLOBWill be read back as BLOB
TIMETIME 
TIMESTAMPTIMESTAMP 
TINYINTSMALLINTWill be read back as SMALLINT
VARBINARYVARCHAR(n) FOR BIT DATA 
VARCHARVARCHAR 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值