JDBC Database Type to BOM Data Type Mapping

The following table shows mappings between:

  • JDBC database types and
  • TIBCO Business Studio Business Object Model (BOM) types.

See TIBCO Business Studio Modeling User's Guide for more detail.

JDBC Database Type BOM Type
BIT Boolean
TINYINT Integer (signed)
SMALLINT Integer (signed)
INTEGER Integer (signed)
BIGINT Integer (fixed - BigInteger)
FLOAT Decimal (floating point - double)
REAL Decimal (floating point - double)
DOUBLE Decimal (floating point - double)
NUMERIC Decimal (fixed point - BigDecimal)
DECIMAL Decimal (fixed point - BigDecimal)
CHAR Text
VARCHAR Text
LONGVARCHAR Text
DATE Date
TIME Time
TIMESTAMP Datetime
BINARY Attachment(1)
VARBINARY Attachment(1)
LONGVARBINARY Attachment(1)
NULL Text
OTHER Text
JAVA_OBJECT Attachment(1)
DISTINCT Text
STRUCT Text
ARRAY Text
BLOB Attachment(1)
CLOB Text
REF URL
DATALINK URL
BOOLEAN Boolean
ROWID Text
NCHAR Text
NVARCHAR Text
LONGNVARCHAR Text
NCLOB Text
SQLXML Text
(1) Not currently supported.