JDBC V2 Connector > JDBC V2 data type reference > JDBC V2 and transformation data types
  

JDBC V2 and transformation data types

Data Integration uses the JDBC type 4 driver to read data. The Secure Agent converts the JDBC data type to the transformation data type, and uses the transformation data type to move data across platforms.
When Data Integration writes to a JDBC V2 target, the Secure Agent converts the transformation data type to the corresponding JDBC V2 data type.
The following table compares the JDBC V2 data types that Data Integration supports to the transformation data types:
Aurora PostgreSQL Data Type
Transformation Data Type
Description
integer
integer
-2147483648 to 2147483647, precision 10, scale 0
smallint
integer
-32768 to 32767, precision 10, scale 0
bigint
bigint
-9223372036854775808 to 9223372036854775807, precision 19, scale 0
real
double
Precision 15
float
double
Precision 15
double_precision
double
Precision 15
decimal
decimal
Precision 1 to 38, scale 0 to 38
numeric
decimal
Precision 1 to 38, scale 0 to 38
boolean
string
Precision 6
char
string
1 to 10485760 characters
varchar
string
1 to 10485760 characters
date
date/time
January 1, 0001, through December 31, 9999
time
date/time
00:00:00.000 through 23:59:59.999
timestamp
date/time
Date range: January 1, 0001, through December 31, 9999 time range: 00:00:00 through 23:59:59.997
nchar
string
1 to 10485760 characters