Ask Your Question

Oracle JDBC Producer: Can't coerce '35' of type 'INTEGER' to column

asked 2018-07-04 03:44:29 -0500

pederpansen gravatar image

updated 2018-07-04 15:41:04 -0500

metadaddy gravatar image

After upgrading from Streamset to 3.3.0, we see a lot of the following errors in our pipelines:

com.streamsets.pipeline.api.base.OnRecordErrorException: JDBC_23 - Can't coerce '35' of type 'INTEGER' to column 'p.mycol'

The destination table contains only VARCHARcolumns, so an (implicit) conversion should always be possible. Is this error somehow related to and what are suggestions to fix it?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2018-07-04 15:44:09 -0500

metadaddy gravatar image

That may well be a manifestation of SDC-9132. It will be fixed in 3.3.1 and 3.4.0. In the meantime, you should be able to work around it by using a Field Type Converter to convert the field to a string.

edit flag offensive delete link more


thank you vary much,the Field Type Converter have already solved my question before data enters JDBC Producer,But another problem is my streamsets version is 3.4.1,it seams that the manifestation haven`t been fixed.

harley gravatar imageharley ( 2018-10-19 04:45:23 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-04 03:44:29 -0500

Seen: 954 times

Last updated: Jul 04 '18