topic Talend Open Studio V7.2.1 , job migrated from 6.4, issues when adding new DATE columns to the existing tOracleInput query in Talend Studio https://community.qlik.com/t5/Talend-Studio/Talend-Open-Studio-V7-2-1-job-migrated-from-6-4-issues-when/m-p/2294298#M67194 <P>Hi</P><P>Recently migrated Talend Open Studio jobs from V6.4 to V7.2.1. While trying to add two date columns to the existing tOracleInput query, getting the below given run time exceptions:</P><P>Child job returns 1. It doesn't terminate normally.</P><P>Exception in component tOracleInput_13 (RO_Details_Daily3)</P><P>java.sql.SQLException: Invalid column type: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor</P><P> at oracle.jdbc.driver.GeneratedAccessor.getTimestamp(GeneratedAccessor.java:638)</P><P> at oracle.jdbc.driver.GeneratedStatement.getTimestamp(GeneratedStatement.java:314)</P><P> at oracle.jdbc.driver.GeneratedScrollableResultSet.getTimestamp(GeneratedScrollableResultSet.java:419)</P><P> at routines.system.JDBCUtil.getDate(JDBCUtil.java:61)</P><P></P><P></P><P>Tried to read the source DATE columns as DATE in the tOracleInput schema, TMAP and tOracleOutput, didn't help to get rid of the run time error. </P><P></P><P></P><P>Appreciate any help.</P><P>Thanks.</P> Tue, 22 Sep 2020 23:32:17 GMT aprn 2020-09-22T23:32:17Z Talend Open Studio V7.2.1 , job migrated from 6.4, issues when adding new DATE columns to the existing tOracleInput query https://community.qlik.com/t5/Talend-Studio/Talend-Open-Studio-V7-2-1-job-migrated-from-6-4-issues-when/m-p/2294298#M67194 <P>Hi</P><P>Recently migrated Talend Open Studio jobs from V6.4 to V7.2.1. While trying to add two date columns to the existing tOracleInput query, getting the below given run time exceptions:</P><P>Child job returns 1. It doesn't terminate normally.</P><P>Exception in component tOracleInput_13 (RO_Details_Daily3)</P><P>java.sql.SQLException: Invalid column type: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor</P><P> at oracle.jdbc.driver.GeneratedAccessor.getTimestamp(GeneratedAccessor.java:638)</P><P> at oracle.jdbc.driver.GeneratedStatement.getTimestamp(GeneratedStatement.java:314)</P><P> at oracle.jdbc.driver.GeneratedScrollableResultSet.getTimestamp(GeneratedScrollableResultSet.java:419)</P><P> at routines.system.JDBCUtil.getDate(JDBCUtil.java:61)</P><P></P><P></P><P>Tried to read the source DATE columns as DATE in the tOracleInput schema, TMAP and tOracleOutput, didn't help to get rid of the run time error. </P><P></P><P></P><P>Appreciate any help.</P><P>Thanks.</P> Tue, 22 Sep 2020 23:32:17 GMT https://community.qlik.com/t5/Talend-Studio/Talend-Open-Studio-V7-2-1-job-migrated-from-6-4-issues-when/m-p/2294298#M67194 aprn 2020-09-22T23:32:17Z