Ask Your Question
0

Using Oracle Bulkload origin for initial data load throws an SQL Exception

asked 2019-10-21 14:15:16 -0600

atrivedi11 gravatar image

Hello, I'm trying to setup a simple pipeline with Oracle Bulkload origin and a Data Lake as the destination. However, when I execute the pipeline, I get following error:

com.streamsets.pipeline.api.StageException: ORACLE_03 - SQLException thrown while trying to retrieve table information from table: <schema_name>.<table_name>

I tried to look in the log files but there is not much more information other than the error message repeating.

I am using StreamSets Data Collector 3.10.1 and Oracle Bulkload Enterprise Stage library 1.1.0 along with Oracle JDBC driver ojdbc6.jar

Any pointers?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2019-10-28 08:57:49 -0600

dong1lkim gravatar image

use ojdbc8

edit flag offensive delete link more

Comments

I did add ojdbc8 external library but still getting the same error.

atrivedi11 gravatar imageatrivedi11 ( 2019-10-29 14:13:08 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-10-21 14:15:16 -0600

Seen: 27 times

Last updated: Oct 28