I am converting UTC to CET with this groovy / java coding:
import com.sap.gateway.ip.core.customdev.util.Message;
import java.util.HashMap;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.TimeZone;
import org.joda.time.*;
import org.joda.time.format.*;
def Message processData(Message message) {
def messageLog = messageLogFactory.getMessageLog(message);
def map = message.getHeaders();
def value = map.get("dateOfBirth");
if (value != null) {
String pattern = "yyyy-MM-dd'T'HH:mm:ssZ";
DateTimeFormatter dtf = DateTimeFormat.forPattern(pattern);
DateTime dateTime = dtf.parseDateTime(value.toString());
TimeZone tz = TimeZone.getTimeZone("CET");
def result = dateTime.withZone( DateTimeZone.forTimeZone(tz) ).toString();
message.setHeader("dateOfBirth", result);
return message;
}
}
this code works, UTC is getting converted to CET.
But I am receiving an error message anyway and I don't know why. Could anybody help me to get rid of this error?
Error:
javax.script.ScriptException: java.lang.Exception:
java.lang.IllegalArgumentException: Invalid format: ""@ line 20 in script8.groovy,
cause: java.lang.IllegalArgumentException: Invalid format: ""
Thanks in advance
Solution:
import com.sap.gateway.ip.core.customdev.util.Message;
import java.util.HashMap;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.TimeZone;
import org.joda.time.*;
import org.joda.time.format.*;
def Message processData(Message message) {
def messageLog = messageLogFactory.getMessageLog(message);
def map = message.getHeaders();
def value = map.get("dateOfBirth");
if (value?.trim() != "") {
String pattern = "yyyy-MM-dd'T'HH:mm:ssZ";
DateTimeFormatter dtf = DateTimeFormat.forPattern(pattern);
DateTime dateTime = dtf.parseDateTime(value.toString());
TimeZone tz = TimeZone.getTimeZone("CET");
def result = dateTime.withZone( DateTimeZone.forTimeZone(tz) ).toString();
message.setHeader("dateOfBirth", result);
}
return message;
}
your code works fine when the value
variable contains correct datetime value.
if I change value = ""
(empty string) then I have the same exception:
java.lang.IllegalArgumentException: Invalid format: ""
@Grab(group='joda-time', module='joda-time', version='2.0')
import org.joda.time.format.DateTimeFormat;
import org.joda.time.format.DateTimeFormatter;
import org.joda.time.DateTime;
import org.joda.time.DateTimeZone;
import java.util.TimeZone;
def value = '2016-12-31T13:14:15+02';
String pattern = "yyyy-MM-dd'T'HH:mm:ssZ";
DateTimeFormatter dtf = DateTimeFormat.forPattern(pattern);
DateTime dateTime = dtf.parseDateTime(value);
TimeZone tz = TimeZone.getTimeZone("CET");
def result = dateTime.withZone( DateTimeZone.forTimeZone(tz) ).toString();