Manualshelf

NonStop Server for Java (NSJ) Programmer's Guide (NSJ 2.1+)

ManualsBrandsHP ManualsServerHP NonStop G-Series
51525354555657585960
Compatible Java and SQL/MP Data Types
The following table shows which Java data types can hold which SQL/MP data types. Use this table to determine which
get() method to call to read a particular type of data from a result set or which set() method to call to define the data
type of a prepared statement's input parameter. For example, if you select CHAR data from a database, use getString() to
retrieve the CHAR data from the result set.
Compatible Java and SQL/MP Data Types
SQL Data Types
S
M
A
L
L
I
N
T
I
N
T
E
G
E
R
B
I
G
I
N
T
R
E
A
L
F
L
O
A
T
D
O
U
B
L
E
D
E
C
I
M
A
L
N
U
M
E
R
I
C
C
H
A
R
V
A
R
C
H
A
R
D
A
T
E
T
I
M
E
T
I
M
E
S
T
A
M
P
J
a
v
a
D
a
t
a
T
y
p
e
s
Byte
R s s s s s s s s s n n n
Short
R s s s s s s s s s n n n
Int
s R s s s s s s s s n n n
Long
s s R s s s s s s s n n n
Float
s s s R s s s s s s n n n
Double
s s s s s R s s s s n n n
BigDecimal
s s s s s s R s s s n n n
BigInteger
s s s s s s s s R s n n n
Boolean
R s s s s s s s s s n n n
String
s s s s s s s s R R n n n
Bytes
n n n n n n n n n n n n n
Date
n n n n n n n n n n R n n
Time
n n n n n n n n n n n R n
Timestamp
n n n n n n n n n n n n R
AsciiStream
n n n n n n s n R R n n n
UnicodeStream
n n n n n n n n n n n n n
BinaryStream
n n n n n n n n n n n n n
Object
s s s s s s s s s s n n n
Legend
R
Recommended
s
Supported