JDBC data type to Java data type mapping constraints

The database connector has some constraints mapping JDBC data types to Java™ data types. You can select one of the listed Java data types, the data type maps exactly to the Input/Output of operation

  • java.lang.String
  • java.lang.Byte
  • java.lang.Boolean
  • java.lang.Character
  • java.lang.Double
  • java.lang.Float
  • java.lang.Integer
  • java.lang.Long
  • java.lang.Short
  • java.util.Date
  • java.math.BigDecimal
  • java.math.BigInteger
  • java.lang.Object

The data types that are not included in this list are mapped to java.lang.Object. In these cases, if the JDBC data types you specify is for input, you need to pass in the object with the selected Java data type. If the JDBC type is for output, you can cast the object to the selected Java data type.