derby支持的数据类型

论坛 期权论坛 脚本     
匿名技术用户   2021-1-5 10:15   31   0

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

分享到 :
0 人收藏
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

积分:7942463
帖子:1588486
精华:0
期权论坛 期权论坛
发布
内容

下载期权论坛手机APP