Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: ClassCastException: java.lang.Long

  1. #1

    Default ClassCastException: java.lang.Long

    Hi guys,

    I am using Pentaho as a databridge between two Oracle databases. When I try to update a row (inserts work fine), I get the following error:

     Unexpected error : 
     java.lang.ClassCastException: java.lang.Long at org.pentaho.di.core.row.ValueMeta.getNumber(
        at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(
        at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(
    The primary key (ID) is a Decimal(22) in Oracle, and a BigNumber in Pentaho. ID is either obtained from an Xref table (in the case of an update) or from an oracle sequence (Insert).

    In the case of an insert, the sequence returns as type Integer, so I use a Select Values to map the metadata to a BigNumber.

    Lazy conversion is Off in all steps.

    Hopefully there is something simple I have missed, but I can supply more details as required.

    Thanks in advance.
    Attached Files Attached Files

  2. #2


    If anyone else has this error, upgrading to 3.0.4 solved the problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.