Ask Your Question
1

JDBC_02 Offset column issue in Transformer

asked 2020-01-18 01:36:36 -0600

Vss@2019 gravatar image

Hi,

Below issue which i am facing from Streamsets Transformer 3.12

I have a 'ID' column which is of NOT NULL with Number Datatype in Oracle . When we are fetching records via JDBC Origin with the offset column mentioned as ID we get an error like

Error Message : JDBC_02 - Only Scale of 0 is supported for Numeric Offset columns, But ID have a scale of -127.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2020-01-21 12:21:44 -0600

jeff gravatar image

There are some new features coming in the next major version that will help alleviate this issue. Specifically, there will be vendor specific origins, that will take care of these Oracle specific numeric types. Please stay tuned, and contact support if you want to get updates on future release dates as they become available.

edit flag offensive delete link more

Comments

Thank you Jeff

Vss@2019 gravatar imageVss@2019 ( 2020-01-22 10:00:58 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-01-18 01:36:36 -0600

Seen: 29 times

Last updated: Jan 21