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:
Solved! Go to Solution.
@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
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
@yoxler , where are you creating bulk file and can you show job design?
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.
@yoxler ,can you show configuration of "bulk exec" component,the one which is failing?
@yoxler ,can you verify the schema of bulk file and tDBBulkExec
@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.
@yoxler ,great,please mark the solution and also provide Kudos.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables