SQL Data Type to JDBC Data Type Mappings

webMethods Adapter for Apache Cassandra's maps CQL or column type to respective java type as shown in the below table. Adapter for Apache Cassandra expects inputs in its respective java type while inserting or updating values for collection or tuple data types. Also, use the below data types for IN operator of WHERE clause.

Column Type/CQL Type	Java Data Type
ASCII	java.lang.String
BIGINT	java.lang.Long
BLOB	byte [ ]
BOOLEAN	java.lang.Boolean
COUNTER	java.lang.Long
DATE	java.util.Date
DECIMAL	java.math.BigDecimal
DOUBLE	java.lang.Double
FLOAT	java.lang.Float
INET	java.net.InetAddress
INT	java.lang.Integer
LIST	java.util.List
MAP	java.util.Map
SET	java.util.Set
SMALLINT	java.lang.Short
TEXT	java.lang.Strings
TIME	java.lang.Long
TIMESTAMP	java.lang.Long
TIMEUUID	java.util.UUID
TINYINT	java.lang.Byte
TUPLE	Object[]
UDT	com.wm.data.IData
UUID	java.util.UUID
VARCHAR	java.lang.String
VARINT	java.math.BigInteger

Note:
Be sure to pass java.nio.ByteBuffer type values in Object array, only for the WHERE clause with IN operator in BLOB data type.