SQL-Java data types

The following table shows SQL data types and the corresponding Java data types.

SQL data type Corresponding Java data type

VARCHAR

java.lang.String

CHAR

java.lang.String

INTEGER

int or Integer

BINARY

byte[ ]

BIGINT

long

TIMESTAMP

java.sql.Timestamp

INOUT INTEGER

ianywhere.ml.script.InOutInteger

INOUT VARCHAR

ianywhere.ml.script.InOutString

INOUT CHAR

ianywhere.ml.script.InOutString

INOUT BYTEARRAY

ianywhere.ml.script.InOutByteArray

INOUT TIMESTAMP

java.sql.Timestamp

The MobiLink server automatically adds the ianywhere.ml.script package to your classpath if it is not already present. However, when you compile your class you need to add the path of %SQLANY12%\java\mlscript.jar.