Show TOC

Datatype Mapping for FormattersLocate this document in the navigation structure

Mapping information for ESP to Java datatypes and Java to ESP datatypes.

Table 1: ESP to Java Objects Datatype Mappings
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
msdate java.util.Date or java.sql.Timestamp (if OutputAsSQLDatetimeFormat is set to true)
seconddate 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)

time

java.lang.String (the output format is HH:mm:ss)

java.sql.Time (if OutputAsSQLDatetimeFormat is set to true)

fixeddecimal java.math.BigDecimal
money, money01 - money15 java.math.BigDecimal (it has the same precision as corresponding money(xx) object
binary byte[]
Table 2: Java Objects to ESP Datatype Mappings
Java Datatype ESP Datatype
Java.util.Date (including its child classes)

bigdatetime or time

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 the ESP datatype.

money, money01 - money15

Any Java classes with the toString() method, and the result string represents a fixed decimal in the standard ESP format.

fixeddecimal