I am doing an evaluation and am having real problems with the dbjoin joiner.
I have a input stream and wish to join to a table to get some more values.
I can do this with a reader and a hash join but wanted to try out the dbjoin.
I have 2 columns too join on ref_date and rating_tariff_id. I select these as the join criteria and set up the transform.
I assume the input field names for the join have to be identical to the field names in the oracle table for the join to work?
the error I get when I run the graph is as follows
Node DBJOIN0 finished with status: ERROR caused by: java.sql.SQLException: Invalid column index with field ‘RATING_TARIFF_ID’
ERROR [WatchDog] - Node DBJOIN0 error details:
If I change the join to use ref_date then the error is repeated but showing ref_date rather than rating tariff_id.
Any help apprieciated.