I am new to TalendETL and am using Talend Open Studio for Big Data version 5.4.1. I developed a simple Talend ETL task that collects data from a csv file and inserts data into my local Oracle database. Below is what my package looks like:
The task returns an exception that is ArrayIndexOutOfBounds after the last record of the csv file. But I'm not sure why he should return it in the first place? I checked the solution given at this link: http://www.talendforge.org/forum/viewtopic.php?id=21644
But this does not seem to work at all. I have the latest driver for the oracle component, and increasing / decreasing the commit size does not affect it.
Can someone please help me with this? Please let me know if you need more information.
PS: Full error log below: -
Starting job Kaggle_Data_Load_Training at 09:31 25/06/2014. [statistics] connecting to socket on port 3957 [statistics] connected Exception in component tOracleOutput_1 java.lang.ArrayIndexOutOfBoundsException: -32203 at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2677) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9270) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:210) at test.kaggle_data_load_training_0_1.Kaggle_Data_Load_Training.tFileInputDelimited_1Process(Kaggle_Data_Load_Training.java:4360) at test.kaggle_data_load_training_0_1.Kaggle_Data_Load_Training.runJobInTOS(Kaggle_Data_Load_Training.java:4717) at test.kaggle_data_load_training_0_1.Kaggle_Data_Load_Training.main(Kaggle_Data_Load_Training.java:4582) [statistics] disconnected Job Kaggle_Data_Load_Training ended at 09:31 25/06/2014. [exit code=1]
source share