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.
Appreciate any help.
Thanks.
