Precision, scale and type have default values if they are not explicitly. Precision and scale default to -1. Type defaults to Variant.STRING. The sqlType is based on the value returned from the JDBC driver.
For information on data mapping of SQL server physical types to JBDC data types, check your driver documentation.
JDBC type | Maps to JBCL data type |
java.sql.Types.BIGINT | Variant.LONG |
java.sql.Types.BINARY | Variant.BINARY with precision |
java.sql.Types.BIT | Variant.BOOLEAN |
java.sql.Types.CHAR | Variant.STRING with precision |
java.sql.Types.DATE | Variant.DATE |
java.sql.Types.DECIMAL | Variant.BIGDECIMAL with scale and precision |
java.sql.Types.DOUBLE | Variant.DOUBLE |
java.sql.Types.FLOAT | Variant.DOUBLE |
java.sql.Types.INTEGER | Variant.INT |
java.sql.Types.LONGVARBINARY | Variant.BINARY without precision |
java.sql.Types.LONGVARCHAR | Variant.STRING without precision (BLOB columns typically have an open-ended length) |
java.sql.Types.NUMERIC | Variant.BIGDECIMAL with scale and precision |
java.sql.Types.OTHER | Variant.OBJECT |
java.sql.Types.REAL | Variant.DOUBLE |
java.sql.Types.SMALLINT | Variant.SHORT |
java.sql.Types.TIME | Variant.TIME |
java.sql.Types.TIMESTAMP | Variant.TIMESTAMP |
java.sql.Types.TINYINT | Variant.BYTE |
java.sql.Types.VARBINARY | Variant.BINARY without precision |
java.sql.Types.VARCHAR | Variant.STRING with precision |