To Next Page

To Previous Page

Table 26. Mappings of database server data types to Java data types for retrieving data from database server tables

SQL data type

Recommended Java data type or

Java object type Other supported Java data types

SMALLINT short byte, int, long, float, double,

java.math.BigDecimal, boolean,

java.lang.String

INTEGER int short, byte, long, float, double,

java.math.BigDecimal, boolean,

java.lang.String

BIGINT

long int, short, byte, float, double,

java.math.BigDecimal, boolean,

java.lang.String

DECIMAL(p,s) or NUMERIC(p,s) java.math.BigDecimal long, int, short, byte, float, double,

boolean, java.lang.String

DECFLOAT(n)

1,2

java.math.BigDecimal long, int, short, byte, float, double,

java.math.BigDecimal, boolean,

java.lang.String

REAL float long, int, short, byte, double,

java.math.BigDecimal, boolean,

java.lang.String

DOUBLE double long, int, short, byte, float,

java.math.BigDecimal, boolean,

java.lang.String

CHAR(n) java.lang.String long, int, short, byte, float, double,

java.math.BigDecimal, boolean,

java.sql.Date, java.sql.Time,

java.sql.Timestamp,

java.io.InputStream, java.io.Reader

VARCHAR(n) java.lang.String long, int, short, byte, float, double,

java.math.BigDecimal, boolean,

java.sql.Date, java.sql.Time,

java.sql.Timestamp,

java.io.InputStream, java.io.Reader

CHAR(n) FOR BIT DATA byte[] java.lang.String,

java.io.InputStream, java.io.Reader

VARCHAR(n) FOR BIT DATA byte[] java.lang.String,

java.io.InputStream, java.io.Reader

BINARY(n)

byte[] None

VARBINARY(n)

byte[] None

GRAPHIC(m) java.lang.String long, int, short, byte, float, double,

java.math.BigDecimal, boolean,

java.sql.Date, java.sql.Time,

java.sql.Timestamp,

java.io.InputStream, java.io.Reader

VARGRAPHIC(m) java.lang.String long, int, short, byte, float, double,

java.math.BigDecimal, boolean,

java.sql.Date, java.sql.Time,

java.sql.Timestamp,

java.io.InputStream, java.io.Reader

CLOB(n) java.sql.Clob java.lang.String

BLOB(n) java.sql.Blob byte[]

Chapter 7. JDBC and SQLJ reference information 195

Developer

IBM

Initial Release

1983

License

Proprietary

Written in

C, C++

Developer	IBM
Initial Release	1983
License	Proprietary
Written in	C, C++
Category	Database Management System (RDBMS)
Operating System	Linux, Windows
Programming Languages	C, C++
Data Models	Relational
Editions	Community, Standard, Advanced
Key Features	high availability, scalability

IBM DB2 User Manual

Table of Contents

Questions and Answers:

IBM DB2 Specifications