Talend Open Studio V7.2.1 , job migrated from 6.4, issues when adding new DATE columns to the existing tOracleInput query
Hi
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:
Child job returns 1. It doesn't terminate normally.
Exception in component tOracleInput_13 (RO_Details_Daily3)
java.sql.SQLException: Invalid column type: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor
at oracle.jdbc.driver.GeneratedAccessor.getTimestamp(GeneratedAccessor.java:638)
at oracle.jdbc.driver.GeneratedStatement.getTimestamp(GeneratedStatement.java:314)
at oracle.jdbc.driver.GeneratedScrollableResultSet.getTimestamp(GeneratedScrollableResultSet.java:419)
at routines.system.JDBCUtil.getDate(JDBCUtil.java:61)
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.
