NullPointerException in tOracleBulkExec

[yoxler]

Hi,

We are about to move a lot of data from a oracle database into a new oracle db and also a MSSQL db. For MSSQL the bulk exec runs just fine but when we use tOracleBulkExec we always get a null pointer exception.

I've tried different settings in the component but no luck. I have installed sqlldr.

The row that causes the error is:

lr_tDBBulkExec_2.close();

Any ideas?

Thanks

Andreas

[manodwhb]

@yoxler,Did you use tOracleConnection component in your work flow? If so, is there any connector(onsubjobok or oncomponentOk) between tOracleConnection and tOracleBulkExec?

since it could be connection or Bulk file path issue. since check the below link

https://help.talend.com/reader/NNO~fmVQU4rlkF9Depfdxw/kjYl_YFAdMYvz4O4QFyT_A

[yoxler]

I have a connection to the database and use it in the component. The connection is connected to a Prejob. I've tried to just do normal inserts using tDBOutput and that works so conneciton to the DB and table is OK

[manodwhb]

@yoxler , where are you creating bulk file and can you show job design?

[yoxler]

I've tried both with a csv file and db output bulk files, with the same results.

The disabled flow for MSSQL works fine with the csv file. The java stuff only prints time. 

[manodwhb]

@yoxler ,can you show configuration of "bulk exec" component,the one which is failing?

[yoxler]

The basic settings is the one I posted before. this is the advanced. Only thing I changed is the field terminator

[manodwhb]

@yoxler ,can you verify the schema of bulk file and tDBBulkExec

[yoxler]

Perhaps it has something todo with the SQLLDR installation. I will try to reeinstall it

[manodwhb]

@yoxler ,yes when you try to use Bulk component you need to make sure all the required jars installed and DB side setting also need to be done.