Integration Cloud 7.0.0 | Applications | Predefined Applications | Database | JDBC Data Type to Java Data Type Mappings
 
JDBC Data Type to Java Data Type Mappings
 
Important Considerations When Using BLOB and CLOB Data Types
Important Considerations When Using the Array and Struct Database Specific Data Types
Using the SetAsString Data Type in Database Application
JDBC Data Type to Java Data Type Mapping Constraints
Each column in the database table is assigned a SQL type. The JDBC driver maps each SQL data type to a JDBC data type. Database Application then maps each JDBC data type to one or more Java data types that are used as the input or output of the database operation.
The following table shows the JDBC data type to Java data type mappings. You can map each JDBC data type to a set of Java data types by choosing one from the set. The JDBC data type you select during configuration will then map to the input or output of the database operation.
For a list of data types for which Database Application has some constraints, see JDBC Data Type to Java Data Type Mapping Constraints.
Note:
Database Application does not support the TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE data types in Oracle 10g.
Note:
Database Application does not support user-defined data types, Oracle PL/SQL collections, or Oracle PL/SQL records.
Note:
UROWID data type is not supported for Oracle database.
Note:
If the DATE JDBC type contains String as Java type, then the date format which Database Application accepts is YYYY-MM-DD.
JDBC Data Type
Java Data Type
ARRAY
java.sql.Array
java.lang.Object
BIT
java.lang.Boolean
java.lang.String
java.lang.Object
TINYINT
java.lang.Byte
java.lang.Integer
java.lang.String
java.lang.Object
SetAsString
SMALLINT
java.lang.Short
java.lang.Integer
java.lang.String
java.lang.Object
INTEGER
java.lang.Integer
java.lang.String
java.lang.Object
BIGINT
java.lang.Long
java.lang.String
java.lang.Object
FLOAT
java.lang.Double
java.lang.String
java.lang.Object
java.math.BigDecimal
SetAsString
REAL
java.lang.Float
java.lang.String
java.lang.Object
java.math.BigDecimal
BOOLEAN
java.lang.Boolean
java.lang.String
java.lang.Object
DOUBLE
java.lang.Double
java.lang.String
java.lang.Object
java.math.BigDecimal
SetAsString
NUMERIC
java.math.BigDecimal
java.lang.String
java.lang.Object
DECIMAL
java.math.BigDecimal
java.lang.String
java.lang.Object
CHAR
java.lang.String
java.lang.Character
java.lang.Object
VARCHAR
java.lang.String
java.lang.Object
LONGVARCHAR
java.lang.String
java.lang.Object
DATE
java.sql.Date
java.util.Date
java.lang.String
java.lang.Object
*SetAsString
TIME
java.sql.Time
java.util.Date
java.lang.String
java.lang.Object
SetAsString
TIMESTAMP
java.sql.Timestamp
java.util.Date
java.lang.String
java.lang.Object
SetAsString
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
BINARY
byte array (byte [])
java.lang.Object
VARBINARY
byte array (byte[])
java.lang.Object
LONGVARBINARY
byte array (byte[])
java.lang.Object
LONGNVARCHAR
java.lang.String
java.lang.Object
NCHAR
java.lang.String
java.lang.Object
NULL
java.lang.String
java.lang.Object
NVARCHAR
java.lang.String
java.lang.Object
CLOB
java.sql.Clob
java.lang.String
java.io.Reader
java.lang.Object
BLOB
java.sql.Blob
byte array
java.io.InputStream
java.lang.Object
ORACLECURSOR
java.lang.Object
ORACLEFIXED_CHAR
java.lang.String
STRUCT
java.sql.Struct
java.lang.Object
OTHER
java.lang.Object
java.lang.String
java.sql.Struct
java.sql.Array