Ask Your Question

JDBC_02 Offset column issue in Transformer

asked 2020-01-18 01:36:36 -0500

Vss@2019 gravatar image


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

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

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


Thank you Jeff

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

Question Tools

1 follower


Asked: 2020-01-18 01:36:36 -0500

Seen: 40 times

Last updated: Jan 21