Oracle8i JDBC Developer's Guide and Reference Release 8.1.5 A64685-01 |
|
Table 3-1 and Table 3-2 in Chapter 3 describe the default mappings between Java classes and SQL datatypes that are supported by the Oracle JDBC drivers. Compare the contents of the Standard JDBC Datatypes, Java Native Datatypes and Oracle SQL Datatypes columns in Table 3-1 and Table 3-2 with the contents of Table 8-1 below.
Table 8-1 lists all of the possible Java classes to which a given SQL datatype can be validly mapped. The Oracle JDBC drivers will support these "non-default" mappings. For example, to materialize SQL CHAR
data as an oracle.sql.CHAR
, use getCHAR()
. To materialize it as a java.math.BigDecimal
, use getBigDecimal()
.