JDBC_405 - Error while generating records: java.lang.NullPointerException

asked 2019-11-13 00:46:38 -0600

evan3china gravatar image

Hello, Guys,

I encountered an issue when I use Oracle CDC Client to catch the change data in the Pipelines. There are some CLOB type columns in the listed tables in Oracle CDC configuration tab.

The error message is like below: java.lang.NullPointerException at com.streamsets.pipeline.lib.jdbc.parser.sql.SQLListener.format(SQLListener.java:169) at com.streamsets.pipeline.lib.jdbc.parser.sql.SQLListener.extractTableAndSchema(SQLListener.java:61) at com.streamsets.pipeline.lib.jdbc.parser.sql.SQLListener.enterUpdate_statement(SQLListener.java:69) at plsql.plsqlParser$Update_statementContext.enterRule(plsqlParser.java:22866) at org.antlr.v4.runtime.tree.ParseTreeWalker.enterRule(ParseTreeWalker.java:66) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:49) at com.streamsets.pipeline.stage.origin.jdbc.cdc.oracle.OracleCDCSource.generateRecord(OracleCDCSource.java:848) at com.streamsets.pipeline.stage.origin.jdbc.cdc.oracle.OracleCDCSource.lambda$addRecordsToQueue$10(OracleCDCSource.java:968) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)

Is that caused by the CLOB columns? Can you advise how to resolve this issue?

Data Collecter Version: Version: StreamSets Data Collector 3.11.0 ( built by ubuntu on 2019-10-07T23:10Z git: 5a899e4a98406719a531c2fa93062d27ba8dc91d)

Thanks, Evan

edit retag flag offensive close merge delete