UNEXPECTED_EXCEPTION - While trying to retive data from Oracle tdbinput ?

[Bluemoon]

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

[Anonymous]

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