Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Data Type Mapping | 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 Adapter for JDBC
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. Adapter for JDBC then maps each JDBC data type to one or more Java data types that are used as the input or output of the adapter service or notification.
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 adapter service or notification.
For a list of data types for which Integration Server has some constraints, see JDBC Data Type to Java Data Type Mapping Constraints.
Note:
Adapter for JDBC does not support the DATALINK DB2 data type when using the adapter with DB2 for AS/400 or DB2 for OS/390.
Note:
Adapter for JDBC does not support the TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE data types in Oracle 10g.
Note:
Adapter for JDBC does not support user-defined data types, Oracle PL/SQL collections, or Oracle PL/SQL records.
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