Oracle JDBC_00 :IO Expception: Unknown host specified.

[Logan]

I am new to this group,  thanks for supporting our request.  I am able to validate the pipeline "JDBC Consumer to S3" as well as able to preview data.  When I execute the pipeline it fails with unknown host.  updated the log information.

Thanks

Logan.

2017-01-30 17:16:20,247	Read oracle data	WARN	No content length specified for stream data. Stream contents will be buffered in memory and could result in out of memory errors.	AmazonS3Client	*admin	pool-89-thread-1
2017-01-30 17:16:21,240	Read oracle data	WARN	Error while running: java.lang.AbstractMethodError: Method oracle/jdbc/driver/OracleResultSetImpl.isClosed()Z is abstract	ProductionPipeline	*admin	ProductionPipelineRunnable-Read oracle data
java.lang.AbstractMethodError: Method oracle/jdbc/driver/OracleResultSetImpl.isClosed()Z is abstract at oracle.jdbc.driver.OracleResultSetImpl.isClosed(OracleResultSetImpl.java) at com.zaxxer.hikari.proxy.HikariResultSetProxy.isClosed(HikariResultSetProxy.java) at com.streamsets.pipeline.stage.origin.jdbc.JdbcSource.produce(JdbcSource.java:254) at com.streamsets.pipeline.configurablestage.DSource.produce(DSource.java:42) at com.streamsets.datacollector.runner.StageRuntime$2.call(StageRuntime.java:167) at com.streamsets.datacollector.runner.StageRuntime$2.call(StageRuntime.java:161) at com.streamsets.pipeline.api.impl.CreateByRef.call(CreateByRef.java:44) at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:150) at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:189) at com.streamsets.datacollector.runner.StagePipe.process(StagePipe.java:233) at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunner.runBatch(ProductionPipelineRunner.java:484) at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunner.run(ProductionPipelineRunner.java:301) at com.streamsets.datacollector.runner.Pipeline.run(Pipeline.java:204) at com.streamsets.datacollector.execution.runner.common.ProductionPipeline.run(ProductionPipeline.java:109) at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunnable.run(ProductionPipelineRunnable.java:72) at com.streamsets.datacollector.execution.runner.standalone.StandaloneRunner.start(StandaloneRunner.java:761) at com.streamsets.datacollector.execution.runner.common.AsyncRunner$4.call(AsyncRunner.java:147) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:233) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745)
2017-01-30 17:16:21,241	Read oracle data	INFO	HikariPool-38 - is closing down.	HikariPool	*admin	ProductionPipelineRunnable-Read oracle data
2017-01-30 17:16:21,268	Read oracle data	ERROR	A JVM error occurred while running the pipeline, java.lang.AbstractMethodError: Method oracle/jdbc/driver/OracleResultSetImpl.isClosed()Z is abstract	ProductionPipelineRunnable	*admin	ProductionPipelineRunnable-Read oracle data
java.lang.AbstractMethodError: Method oracle/jdbc/driver/OracleResultSetImpl.isClosed()Z is abstract at oracle.jdbc.driver.OracleResultSetImpl.isClosed(OracleResultSetImpl.java) at com.zaxxer.hikari.proxy.HikariResultSetProxy.isClosed(HikariResultSetProxy.java) at com.streamsets.pipeline.stage.origin.jdbc.JdbcSource.produce(JdbcSource.java:254) at com.streamsets.pipeline.configurablestage.DSource.produce(DSource.java:42) at com.streamsets.datacollector.runner.StageRuntime$2.call(StageRuntime.java:167) at com.streamsets.datacollector.runner.StageRuntime$2.call(StageRuntime.java:161) at com.streamsets.pipeline.api.impl.CreateByRef.call(CreateByRef.java:44) at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:150) at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:189) at com.streamsets.datacollector.runner.StagePipe.process(StagePipe.java:233) at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunner.runBatch(ProductionPipelineRunner.java:484) at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunner.run(ProductionPipelineRunner.java:301) at com.streamsets.datacollector.runner.Pipeline.run(Pipeline.java:204) at com.streamsets.datacollector.execution.runner.common.ProductionPipeline.run(ProductionPipeline.java:109) at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunnable.run(ProductionPipelineRunnable.java:72) at com.streamsets.datacollector.execution.runner.standalone.StandaloneRunner.start(StandaloneRunner.java:761) at com.streamsets.datacollector.execution.runner.common.AsyncRunner$4.call(AsyncRunner.java:147) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:233) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745)

[Jarcec Cecho]

My guess is that the Oracle JDBC driver that you're using is too old and doesn't properly implement JDBC 4 that we require. What version of the driver are you using? Can you try most recent one?

Jarcec

--
You received this message because you are subscribed to the Google Groups "sdc-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdc-user+u...@streamsets.com.
Visit this group at https://groups.google.com/a/streamsets.com/group/sdc-user/.