Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-2910

User Defined Java Expression (Janino) fails with return values as BigNumber (BigDecimal)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Fixed
    • Affects Version/s: 3.2.2
    • Fix Version/s: 3.2.3, 4.0.0 GA
    • Component/s: Step
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      I'm working with BigNumbers and I get an Input from Oracel DB with values between "1" and "999999999999999999999999999", or "null". I would like to check if this value is null and if its null I would like to set it to 1, so I tried:

      value == null ? new java.math.BigDecimal(1) : value

      but using this leads to the error:
      2009/11/17 14:01:38 - default.0 - ERROR (version 3.2.2-stable, build 10951 from 2009-09-15 15.34.19 by buildguy) : Please specify a Number type to parse [java.math.BigDecimal] for field [mod_start] as a result of formula [value == null ? new java.math.BigDecimal(1) : value]

        Attachments

          Activity

            People

            • Assignee:
              gdavid Golda Thomas
              Reporter:
              jbleuel Jens Bleuel
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: