UNEXPECTED_EXCEPTION - While trying to retive data from Oracle tdbinput ?

Bluemoon — Sat, 10 Nov 2018 06:11:27 GMT

Usecase:

Use a JDBC tdbinput component to get the data using dynamic schema to console.

Thanks in Advance!!

Error Message:

[FATAL]: talend7_poc.generic_job_0_1.generic_job - tDBInput_3 UNEXPECTED_EXCEPTION:{message=Index: 0, Size: 0}
org.talend.components.api.exception.ComponentException: UNEXPECTED_EXCEPTION:{message=Index: 0, Size: 0}
   at org.talend.components.jdbc.CommonUtils.newComponentException(CommonUtils.java:546)
   at org.talend.components.jdbc.runtime.reader.JDBCInputReader.start(JDBCInputReader.java:204)
   at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)
   at talend7_poc.generic_job_0_1.generic_job.tDBInput_3Process(generic_job.java:787)
   at talend7_poc.generic_job_0_1.generic_job.runJobInTOS(generic_job.java:1444)
   at talend7_poc.generic_job_0_1.generic_job.main(generic_job.java:1270)
Caused by: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
   at java.util.ArrayList.rangeCheck(ArrayList.java:657)
   at java.util.ArrayList.get(ArrayList.java:433)
   at org.talend.components.jdbc.runtime.reader.JDBCInputReader.getSchema(JDBCInputReader.java:119)
   at org.talend.components.jdbc.runtime.reader.JDBCInputReader.getConverter(JDBCInputReader.java:153)
   at org.talend.components.jdbc.runtime.reader.JDBCInputReader.haveNext(JDBCInputReader.java:213)
   at org.talend.components.jdbc.runtime.reader.JDBCInputReader.start(JDBCInputReader.java:200)
   ... 4 more
Exception in component tDBInput_3 (generic_job)
org.talend.components.api.exception.ComponentException: UNEXPECTED_EXCEPTION:{message=Index: 0, Size: 0}
   at org.talend.components.jdbc.CommonUtils.newComponentException(CommonUtils.java:546)
   at org.talend.components.jdbc.runtime.reader.JDBCInputReader.start(JDBCInputReader.java:204)
   at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)
   at talend7_poc.generic_job_0_1.generic_job.tDBInput_3Process(generic_job.java:787)
   at talend7_poc.generic_job_0_1.generic_job.runJobInTOS(generic_job.java:1444)
   at talend7_poc.generic_job_0_1.generic_job.main(generic_job.java:1270)
Caused by: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
   at java.util.ArrayList.rangeCheck(ArrayList.java:657)
   at java.util.ArrayList.get(ArrayList.java:433)
   at org.talend.components.jdbc.runtime.reader.JDBCInputReader.getSchema(JDBCInputReader.java:119)
   at org.talend.components.jdbc.runtime.reader.JDBCInputReader.getConverter(JDBCInputReader.java:153)
   at org.talend.components.jdbc.runtime.reader.JDBCInputReader.haveNext(JDBCInputReader.java:213)
   at org.talend.components.jdbc.runtime.reader.JDBCInputReader.start(JDBCInputReader.java:200)
   ... 4 more

Re: UNEXPECTED_EXCEPTION - While trying to retive data from Oracle tdbinput ?

Anonymous — Sun, 11 Nov 2018 08:01:37 GMT

Hi,

The second screenshot (schema details) seems to have Date format added to it. Could you please expand the data type of schema once again and share the screen shot again for the component schema? I have a doubt whether the data type is accidentally selected as date.

Warm Regards,

Nikhil Thampi

topic UNEXPECTED_EXCEPTION - While trying to retive data from Oracle tdbinput ? in Talend Studio

UNEXPECTED_EXCEPTION - While trying to retive data from Oracle tdbinput ?

Re: UNEXPECTED_EXCEPTION - While trying to retive data from Oracle tdbinput ?