JDBC V2 Connector

JDBC V2 Connector

Appendix A: JDBC V2 data type reference

Appendix A: JDBC V2 data type reference

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

0 COMMENTS

We’d like to hear from you!