Unwired Platform to Enterprise Information System Datatype Mappings

These tables provide mapping information for various EIS types into Unwired Platform data types.

JDBC types
MBO datatype Generic JDBC type Java type
BINARY java.sql.Types.BINARY

java.sql.Types.VARBINARY

java.sql.Types.LONGVARBINARY

java.sql.Types.BLOB

java.lang.Byte[]
BIGBINARY java.sql.Types.LONGVARBINARY java.lang.Byte[]
BIGSTRING java.sql.Types.LONGVARCHAR java.lang.String
BOOLEAN java.sql.Types.BOOLEAN

java.sql.Types.BIT

java.lang.Boolean
BYTE java.sql.Types.Byte, byte java.lang.Byte
CHAR java.sql.Types.Char, char java.lang.Character
DATE java.sql.Types.DATE java.sql.timestamp
DATETIME java.sql.Types.TIMESTAMP java.sql.timestamp
DECIMAL java.sql.Types.DECIMAL

java.sql.Types.NUMERIC

java.math.BigDecimal
DOUBLE java.sql.Types.DOUBLE java.lang.Double
FLOAT java.sql.Types.FLOAT

java.sql.Types.REAL

java.lang.Float
INT java.sql.Types.INTEGER java.math.BigInteger
INTEGER java.sql.Types.INTEGER java.math.BigInteger
LONG java.sql.Types.BIGINT java.lang.Long
SHORT java.sql.Types.BIGINT java.lang.Short
STRING java.sql.Types.CHAR

java.sql.Types.NCHAR

java.sql.Types.VARCHAR

java.sql.Types.NVARCHAR

java.sql.Types.LONGVARCHAR

java.sql.Types.LONGNVARCHAR

java.lang.String
TIME java.sql.Types.TIME java.lang.String
Web service types
MBO datatype XSD type Java type
BOOLEAN xs:Boolean java.lang.Boolean
BYTE xs:Byte java.lang.Byte
BINARY xs:Base64Binary

xs:HexBinary

java.lang.Byte[]
BIGBINARY xs:Base64Binary java.lang.Byte[]
DOUBLE xs:Double java.lang.Double
FLOAT xs:Float

xs:Int

java.lang.Float
CHAR xs:UnsignedShort java.lang.Character
LONG xs:Long

xs:UnsignedInt

java.lang.Long
SHORT xs:Short

xs:UnsignedByte

java.lang.Short
STRING xs:String

xs:Duration

xs:GYearMonth

xs:GYear

xs:GMonthDay

xs:GDay

xs:GMonth

xs:NOTATION

xs:Token

xs:NormalizedString

xs:Language

xs:Name

xs:NMToken

xs:NCName

xs:ID

xs:IDREF

xs:ENTITY

xs:NMTokens

xs:IDREFS

xs:ENTITIES

java.lang.String
DECIMAL xs:Decimal java.math.BigDecimal
INT xs:Integer

xs:NonPositiveInteger

xs:NonNegativeInteger

xs:NegativeInteger

xs:UnsignedLong

xs:PositiveInteger

xs:AnyURI (java.net.URI.class)

java.math.BigInteger
INTEGER xs:Integer

xs:NonPositiveInteger

xs:NonNegativeInteger

xs:NegativeInteger

xs:UnsignedLong

xs:PositiveInteger

xs:AnyURI (java.net.URI.class)

java.math.BigInteger
DATETIME xs:DateTime java.sql.timestamp
TIME xs:Time java.lang.String
DATE xs:Date

xs:QName

java.sql.timestamp
SAP RFC types
MBO datatype JCo version 3 type code ABAP type Java type
BINARY JCoMetaData.TYPE_BYTE

JCoMetaData.TYPE_XSTRING

X

Y

java.lang.Byte[]
BOOLEAN JCoMetaData.TYPE_BYTE JCoMetaData.TYPE_XSTRING X

Y

java.lang.Boolean
BYTE JCoMetaData.TYPE_INT1 b java.lang.Byte
CHAR JCoMetaData.TYPE_CHAR C java.lang.Character
DATE JCoMetaData.TYPE_DATE D java.sql.timestamp
DATETIME JCoMetaData.TYPE_DATE D java.sql.timestamp
DECIMAL JCoMetaData.TYPE_BCD P java.math.BigDecimal
DOUBLE JCoMetaData.TYPE_FLOAT F java.lang.Double
FLOAT JCoMetaData.TYPE_FLOAT F java.lang.Float
INT JCoMetaData.TYPE_INT I r java.lang.Integer
INTEGER JCoMetaData.TYPE_INT I java.math.BigInteger
LONG JCoMetaData.TYPE_INT I java.lang.Long
SHORT JCoMetaData.TYPE_INT2 s java.lang.Short
STRING JCoMetaData.TYPE_STRING

TYPE_NUM

TYPE_FLOAT

TYPE_DECF34

TYPE_DECF16

g

N

F

e

a

java.lang.String
TIME JCoMetaData.TYPE_TIME T java.sql.time