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.
![]() |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |