[resolved] tOracleInput_1-java.sql.SQLException: ORA-01002: fetch out of sequence

talendtester — Sat, 16 Nov 2024 10:06:42 GMT

I have a Talend job which runs a DELETE statement via tOracleInput_1 against Oracle version 12.
Every time the job runs I get this error but the delete is successful.
How do I get Talend to keep going and do the rest of the job?
Exception in component tOracleInput_1
java.sql.SQLException: ORA-01002: fetch out of sequence
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
    at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:1012)
    at oracle.jdbc.driver.OracleStatement.fetchMoreRows(OracleStatement.java:3590)
    at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows( InsensitiveScrollableResultSet.java:1008)
    at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:972)
    at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:572)
    at
Do I need a different driver installed? When I attempt to install ojdbc12.jar I get:java.lang.Exception: Download aws-java-sdk-1.7.4.jar failed!
    at org.talend.librariesmanager.utils.DownloadModuleRunnable.downLoad(DownloadModuleRunnable.java:117)
    at org.talend.librariesmanager.utils.DownloadModuleRunnable.run(DownloadModuleRunnable.java:68)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

Re: [resolved] tOracleInput_1-java.sql.SQLException: ORA-01002: fetch out of sequence

talendtester — Wed, 01 Feb 2017 17:42:48 GMT

I ended up changing to tOracleRow and then a tOracleCommit.
Apparently with Oracle you have to do the extra step of committing after you delete.

Re: [resolved] tOracleInput_1-java.sql.SQLException: ORA-01002: fetch out of sequence

calebthegeek — Wed, 08 Feb 2017 16:50:38 GMT

You can specify auto commit in your connection properties to remove this need, though depending on the volume of records you are working with, it might not be the best idea for performance.
This is fairly common in Oracle, MySQL, MsSQL and many others (though some libraries in some languages - mysql and php come to mind) - have auto commit on by default.

topic [resolved] tOracleInput_1-java.sql.SQLException: ORA-01002: fetch out of sequence in Talend Studio

[resolved] tOracleInput_1-java.sql.SQLException: ORA-01002: fetch out of sequence

Re: [resolved] tOracleInput_1-java.sql.SQLException: ORA-01002: fetch out of sequence

Re: [resolved] tOracleInput_1-java.sql.SQLException: ORA-01002: fetch out of sequence