This API documentation is for Ballerina 1.2.0. View API documentation for the latest release.

Types - java.jdbc

  • Direction DIRECTION_IN | DIRECTION_OUT | DIRECTION_INOUT
  • The direction of the parameter. IN - IN parameters are used to send values to stored procedures OUT - OUT parameters are used to get values from stored procedures INOUT - INOUT parameters are used to send values and get values from stored procedures

  • Param string | int | boolean | float | decimal | byte[] | Parameter
  • The parameter passed into the operations.

  • SQLType TYPE_VARCHAR | TYPE_CHAR | TYPE_LONGVARCHAR | TYPE_NCHAR | TYPE_LONGNVARCHAR | TYPE_NVARCHAR | TYPE_BIT | TYPE_BOOLEAN | TYPE_TINYINT | TYPE_SMALLINT | TYPE_INTEGER | TYPE_BIGINT | TYPE_NUMERIC | TYPE_DECIMAL | TYPE_REAL | TYPE_FLOAT | TYPE_DOUBLE | TYPE_BINARY | TYPE_BLOB | TYPE_LONGVARBINARY | TYPE_VARBINARY | TYPE_CLOB | TYPE_NCLOB | TYPE_DATE | TYPE_TIME | TYPE_DATETIME | TYPE_TIMESTAMP | TYPE_ARRAY | TYPE_STRUCT | TYPE_REFCURSOR
  • The SQL Datatype of the parameter.

    VARCHAR - Small, variable-length character string CHAR - Small, fixed-length character string LONGVARCHAR - Large, variable-length character string NCHAR - Small, fixed-length character string with unicode support LONGNVARCHAR - Large, variable-length character string with Unicode support

    BIT - Single bit value that can be zero or one, or nil BOOLEAN - Boolean value either True or false TINYINT - 8-bit integer value which may be unsigned or signed SMALLINT - 16-bit signed integer value which may be unsigned or signed INTEGER - 32-bit signed integer value which may be unsigned or signed BIGINT - 64-bit signed integer value which may be unsigned or signed

    NUMERIC - Fixed-precision and scaled decimal values DECIMAL - Fixed-precision and scaled decimal values REAL - Single precision floating point number FLOAT - Double precision floating point number DOUBLE - Double precision floating point number

    BINARY - Small, fixed-length binary value BLOB - Binary Large Object LONGVARBINARY - Large, variable-length binary value VARBINARY - Small, variable-length binary value

    CLOB - Character Large Object. NCLOB - Character large objects in multibyte national character set

    DATE - Date consisting of day, month, and year TIME - Time consisting of hours, minutes, and seconds DATETIME - Both DATE and TIME with additional a nanosecond field TIMESTAMP - Both DATE and TIME with additional a nanosecond field

    ARRAY - Composite data value that consists of zero or more elements of a specified data type STRUCT - User-defined structured type, consists of one or more attributes REFCURSOR - Cursor value