The JDBC to DataSet type mapping is pretty much the same as the JDBC to Java type mapping:
|
|
java.sql.Types.LONGVARCHAR java.sql.Types.CHAR java.sql.Types.VARCHAR Oracle ROWID is a String: | Variant.STRING |
java.sql.Types.NUMERIC java.sql.Types.DECIMAL | Variant.BIGDECIMAL |
java.sql.Types.BIT | Variant.BOOLEAN |
java.sql.Types.TINYINT | Variant.BYTE |
java.sql.Types.SMALLINT | Variant.SHORT |
java.sql.Types.INTEGER | Variant.INT |
java.sql.Types.BIGINT | Variant.LONG |
java.sql.Types.REAL | Variant.FLOAT |
java.sql.Types.FLOAT java.sql.Types.DOUBLE | Variant.DOUBLE |
java.sql.Types.VARBINARY java.sql.Types.LONGVARBINARY java.sql.Types.BINARY | Variant.INPUTSTREAM |
java.sql.Types.DATE | Variant.DATE |
java.sql.Types.TIME | Variant.TIME |
java.sql.Types.TIMESTAMP | Variant.TIMESTAMP |
java.sql.Types.OTHER | Variant.OBJECT |