Supported Data Types
The Progress SQL-92 JDBC Driver supports standard JDBC mapping of JDBC data types to corresponding Java data types.
In the JDBC methods CallableStatement.getXXX and PreparedStatement.setXXX methods, XXX is a Java type:
- For setXXX methods, the driver converts the Java data type to the JDBC data type shown in Table 3–1 before sending it to the database.
Table 3–1: Mapping Between Java and JDBC Data Types
Java Data Type
|
JDBC Data Type
|
String
|
VARCHAR
|
java.math.BigDecimal
|
NUMERIC
|
Boolean
|
BIT
|
Byte
|
TINYINT
|
Short
|
SMALLINT
|
Int
|
INTEGER
|
float
|
REAL
|
double
|
DOUBLE
|
byte [ ]
|
VARBINARY
|
byte [ ]
|
LONGVARBINARY
|
java.sql.Date
|
DATE
|
java.sql.Time
|
TIME
|
java.sql.Timestamp
|
TIMESTAMP
|
- For getXXX methods, the driver converts the JDBC data type returned by the database to the Java data type shown in Table 3–2 before returning it to the getXXX method.
Table 3–2: Mapping Between JDBC and Java Data Types
JDBC Data Type
|
Java Data Type
|
CHAR
|
String
|
VARCHAR
|
String
|
NUMERIC
|
java.math.BigDecimal
|
DECIMAL
|
java.math.BigDecimal
|
BIT
|
boolean
|
TINYINT
|
byte
|
SMALLINT
|
short
|
INTEGER
|
int
|
Table 3–3: Mapping Between SQL-92 and Java Data Types
SQL-92 Data Type
|
Java Data Type
|
CHAR, VARCHAR
|
String
|
NUMERIC
|
java.math.BigDecimal
|
DECIMAL
|
java.math.BigDecimal
|
BIT
|
boolean
|
TINYINT
|
byte[ ]
|
SMALLINT
|
Integer
|
INTEGER
|
Integer
|
REAL
|
Float
|
FLOAT
|
Float
|
DOUBLE PRECISION
|
Double
|
BINARY
|
byte[ ]
|
VARBINARY
|
byte[ ]
|
LONGVARBINARY
|
byte[ ]
|
DATE
|
java.sql.Date
|
TIME
|
java.sql.Time
|
TIMESTAMP
|
java.sql.Timestamp
|