Menu
Simba Technologies
Simba Technologies

SimbaEngine X SDK 10.1.3
Developing Drivers for Data Stores Without SQL

SimbaEngine X SDK Documentation > SQL Data Types > SQL Data Types in the Java SDK

SQL DataTypes in the Java SDK

This section explains the mapping between SQL types and the SimbaEngine X SDK data types for JDBC.

Note:

Because Java does not support unsigned types, SQL types that have both unsigned and signed variations are mapped to the next largest data type.

SQL Type Data Type

SQL_BIGINT (signed)

java.math.BigInteger

SQL_BIGINT (unsigned)

java.math.BigInteger

SQL_BINARY

byte[]

SQL_BIT

java.lang.Boolean

SQL_CHAR

java.lang.String

SQL_DECIMAL

java.math.BigDecimal

SQL_DOUBLE

java.lang.Double

SQL_FLOAT

java.lang.Double

SQL_INTEGER (signed)

java.lang.Long

SQL_INTEGER (unsigned)

java.lang.Long

SQL_INTERVAL_DAY

com.simba.dsi.dataengine.utilities.DSITimeSpan

SQL_INTERVAL_DAY_TO_HOUR

com.simba.dsi.dataengine.utilities.DSITimeSpan

SQL_INTERVAL_DAY_TO_MINUTE

com.simba.dsi.dataengine.utilities.DSITimeSpan

SQL_INTERVAL_DAY_TO_SECOND

com.simba.dsi.dataengine.utilities.DSITimeSpan

SQL_INTERVAL_HOUR

com.simba.dsi.dataengine.utilities.DSITimeSpan

SQL_INTERVAL_HOUR_TO_MINUTE

com.simba.dsi.dataengine.utilities.DSITimeSpan

SQL_INTERVAL_HOUR_TO_SECOND

com.simba.dsi.dataengine.utilities.DSITimeSpan

SQL_INTERVAL_MINUTE

com.simba.dsi.dataengine.utilities.DSITimeSpan

SQL_INTERVAL_MINUTE_SECOND

com.simba.dsi.dataengine.utilities.DSITimeSpan

SQL_INTERVAL_MONTH

com.simba.dsi.dataengine.utilities.DSIMonthSpan

SQL_INTERVAL_SECOND

com.simba.dsi.dataengine.utilities.DSITimeSpan

SQL_INTERVAL_YEAR

com.simba.dsi.dataengine.utilities.DSIMonthSpan

SQL_INTERVAL_YEAR_TO_MONTH

com.simba.dsi.dataengine.utilities.DSIMonthSpan

SQL_LONGVARBINARY

byte[]

SQL_LONGVARCHAR

java.lang.String

SQL_NUMERIC

java.math.BigDecimal

SQL_REAL

java.lang.Float

SQL_SMALLINT (signed)

java.lang.Integer

SQL_SMALLINT (unsigned)

java.lang.Integer

SQL_TINYINT (signed)

java.lang.Short

SQL_TINYINT (unsigned)

java.lang.Short

SQL_TYPE_DATE

java.sql.Date

SQL_TYPE_TIME

java.sql.Time or
com.simba.dsi.dataengine.utilities.TimeTz

SQL_TYPE_TIMESTAMP

java.sql.Timestamp or
com.simba.dsi.dataengine.utilities.TimestampTz

SQL_VARBINARY

byte[]

SQL_VARCHAR

java.lang.String

SQL_WCHAR

java.lang.String

SQL_WLONGVARCHAR

java.lang.String

SQL_WVARCHAR

java.lang.String