JDBC Connector Guide

JDBC Connector Guide

JDBC and Transformation Data Types

JDBC and Transformation Data Types

Application 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
Application Integration
writes to a JDBC target, the Secure Agent converts the transformation data type to the corresponding JDBC data type.
The following table compares the JDBC data types that
Application Integration
supports to the transformation data types:
JDBC Data Type
Transformation Data Type
Range
BIGINT
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
BINARY
Binary
1 to 104,857,600 bytes
BIT
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
BLOB
Binary
1 to 104,857,600 bytes
BOOLEAN
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
CHAR
String
1 to 104,857,600 characters
CLOB
Text
1 to 104,857,600 characters
DATE
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
DECIMAL
Decimal
Precision 1 to 28, scale 0 to 28
DOUBLE
Double
Precision 15
FLOAT
Double
Precision 15
INTEGER
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
LONGVARBINARY
Binary
1 to 104,857,600 bytes
LONGVARCHAR
Text
1 to 104,857,600 characters
NUMERIC
Decimal
Precision 1 to 28, scale 0 to 28
REAL
Double
Precision 15
SMALLINT
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
TIME
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
TIMESTAMP
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
TINYINT
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
VARBINARY
Binary
1 to 104,857,600 bytes
VARCHAR
String
1 to 104,857,600 characters