solidDB Help : Programming : solidDB JDBC driver : solidDB JDBC driver type conversion matrix
  
solidDB JDBC driver type conversion matrix
The following conversion matrix shows how the Java data type to SQL data type conversion is supported by solidDB JDBC driver.
This matrix applies to both ResultSet.getXXX and ResultSet.setXXX methods for getting and setting data. An X indicates that the method is supported by solidDB JDBC driver.
 
Java data type
applies to getting and setting data
T
I
N
Y
I
N
T
S
M
A
L
L
I
N
T
I
N
T
E
G
E
R
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
L
O
N
G
V
A
R
C
H
A
R
W
C
H
A
R
W
V
A
R
C
H
A
R
L
O
N
G
W
V
A
R
C
H
A
R
B
I
N
A
R
Y
V
A
R
B
I
N
A
R
Y
R
L
O
N
G
V
A
R
B
I
N
A
R
Y
D
A
T
E
T
I
M
E
T
I
M
E
S
T
A
M
P
getArray/setArray
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
getBlob/setBlob
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
getByte/setByte
X
X
X
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
getCharacterStream/ setCharacterStream
 
 
 
 
 
 
 
 
X
X
X
X
X
X
X
X
X
X
X
X
getClob/setClob
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
getShort/setShort
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
 
 
 
getInt/setInt
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
 
 
 
getlong/setLong
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
 
 
 
getfloat/setfloat
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
 
 
 
getDouble/setDouble
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
 
 
 
getBigDecimal/setBigDecimal
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
 
 
 
getRef/setRef
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
getBoolean/setBoolean
X
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
 
 
getString/setString
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
getBytes/setBytes
 
 
 
 
 
 
 
 
X
X
X
X
X
X
X
X
 
 
 
 
getDate/setDate
 
 
 
 
 
 
 
 
X
X
X
X
X
X
 
 
 
X
 
X
getTime/setTime
 
 
 
 
 
 
 
 
X
X
X
X
X
X
 
 
 
 
X
X
getTimestamp/setTimestamp
 
 
 
 
 
 
 
 
X
X
X
X
X
X
 
 
 
X
 
X
getAsciiStream/setAsciiStream
 
 
 
 
 
 
 
 
X
X
X
X
X
X
X
X
X
 
 
 
getUnicodeStream/setUnicodeStream
 
 
 
 
 
 
 
 
X
X
X
X
X
X
X
X
X
 
 
 
getBinaryStream/setBinaryStream
 
 
 
 
 
 
 
 
X
X
X
X
X
X
X
X
X
 
 
 
getObject/setObject
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
Go up to
solidDB JDBC driver