using tDboutputbulkexec for oracle . Is there a fix for this ?
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)
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.
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
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.
