示例#1
0
 public static Object nvl(CompiledValue arg1, CompiledValue arg2, ExecutionContext context)
     throws FunctionDomainException, TypeMismatchException, NameResolutionException,
         QueryInvocationTargetException {
   Object value = arg1.evaluate(context);
   if (value == null) {
     return arg2.evaluate(context);
   }
   return value;
 }
示例#2
0
  public static Date to_date(CompiledValue cv1, CompiledValue cv2, ExecutionContext context)
      throws FunctionDomainException, TypeMismatchException, NameResolutionException,
          QueryInvocationTargetException {
    Object value1 = cv1.evaluate(context);
    Object value2 = cv2.evaluate(context);
    if (!(value1 instanceof String) || !(value2 instanceof String)) {
      throw new QueryInvalidException(
          LocalizedStrings
              .Functions_PARAMETERS_TO_THE_TO_DATE_FUNCTION_SHOULD_BE_STRICTLY_SIMPLE_STRINGS
              .toLocalizedString());
    }
    String dateStr = (String) value1;
    String format = (String) value2;
    Date dt = null;
    try {
      // Removed the following line so that to data format conforms to
      // SimpleDateFormat exactly (bug 39144)
      // format = ((format.replaceAll("Y", "y")).replaceAll("m", "M")).replaceAll("D", "d");

      /*if((format.indexOf("MM") == -1 && format.indexOf("M") == -1) || (format.
      indexOf("dd") == -1 && format.indexOf("d") == -1) || (format.indexOf("yyyy") ==
      -1 && format.indexOf("yy") == -1))
            {
              throw new QueryInvalidException("Malformed date format string");
            }
            if(format.indexOf("MMM") != -1 || format.indexOf("ddd") != -1 || format.in
      dexOf("yyyyy") != -1)
            {
              throw new QueryInvalidException("Malformed date format string");
            } */

      SimpleDateFormat sdf1 = new SimpleDateFormat(format);
      dt = sdf1.parse(dateStr);

    } catch (Exception ex) {
      throw new QueryInvalidException(
          LocalizedStrings.Functions_MALFORMED_DATE_FORMAT_STRING_AS_THE_FORMAT_IS_0
              .toLocalizedString(format),
          ex);
    }
    return dt;
  }