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 %SQLANY16%\java\mlscript.jar.

Discuter à propos de cette page dans DocCommentXchange.