Mapping information for ESP to Java datatypes and Java to ESP datatypes.
| ESP Datatype | Java Datatype |
|---|---|
| string | java.lang.String |
| boolean | java.lang.Boolean |
| integer | java.lang.Integer |
| long or interval | java.lang.Long |
| double | java.lang.Double |
| timestamp | java.util.Date or java.sql.Timestamp (if OutputAsSQLDatetimeFormat is set to true) |
| date | java.util.Date or java.sql.Timestamp (if OutputAsSQLDatetimeFormat is set to true) |
| bigdatetime |
java.lang.String (the output format is yyy-MM-ddTHH:mm:ss:UUUUUU where U stands for microseconds and the timezone is in UTC) or java.sqlTimestamp (if OutputAsSQLDatetimeFormat is set to true) |
| money, money01 - money15 | java.math.BigDecimal (it has the same precision as corresponding money(xx) object |
| binary | byte[] |
| Java Datatype | ESP Datatype |
|---|---|
| Java.util.Date (including its child classes) |
bigdatetime |
| byte[] | binary |
| Java.lang.Object (including its child classes) | string |
|
Any Java classes with the toString() method, and the result string is [true,false] |
boolean |
|
Any Java classes with the toString() method, and the result string can be used in integer.valueOf(result) |
integer |
|
Any Java classes with the toString() method, and the result string can be used in Long.valueOf(result) |
long or interval |
|
Any Java classes with the toString() method, and the result string can be used in Double.valueOf(result) |
double |
|
Any Java classes with the toString() method. The result string consists of the decimal digits except that the first character may be an ASCII minus sign '-' ('\u002D') to indicate a negative value, or an ASCII plus sign '+' ('\u002B') to indicate a positive value, or the period may occur in the middle of the string. The part after the period is the implied precision and the precision matches with the ESP datatype. |
money, money01 - money15 |