topic Re: using tDboutputbulkexec for oracle . Is there a fix for this ? in Talend Studio

using tDboutputbulkexec for oracle . Is there a fix for this ?

gpinumalla — Sat, 16 Nov 2024 04:26:24 GMT

I was trying to push data 999 records using database bulk exec from source ( oracle ) into a csv and at 1000 record it fails and does not push any data to oracle ( target)

I get error :

Exception in component tDBOutputBulkExec_1_tOBE (ixxxxjob)
java.lang.NullPointerException
at local_project.xxxjob_0_1.iltestjob.tDBInput_1Process(xxxjob.java:13123)
at local_project.xxxxjob_0_1.iltestjob.runJobInTOS(xxxjob.java:13474)
at local_project.xxxjob_0_1.iltestjob.main(xxxjob.java:13323)

Re: using tDboutputbulkexec for oracle . Is there a fix for this ?

Anonymous — Thu, 10 Oct 2019 23:03:41 GMT

Hi,

Could you please show the basic and advanced properties you have set for this component? Also could you please verify why an empty record is coming from the source to the file?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: using tDboutputbulkexec for oracle . Is there a fix for this ?

gpinumalla — Tue, 15 Oct 2019 21:20:16 GMT

Nikhil,

this issue is resovled by installing oracle client specific to 12c and configuring the TNS_ADMIN, ORACLE_HOME and in PATH also. I did not see any difference between bulkoracleexec with direct load and toracleoutput. they were going within same time. it is really tough to handle any rejects with sql loader for rejected rows within each job.

So i choose to use the toracleoutput instead bulk insert operation.