My source table is in oracle and it has one column of type date. I created a tDBinput control to fetch data from it. Also I defined in talend schema the same column with date type and the default format but Whenever i run the job i get the below error,
Exception in component tDBInput_4 (Ora_to_Pg) java.sql.SQLException: Invalid conversion requested at oracle.jdbc.driver.CharCommonAccessor.getTimestamp(CharCommonAccessor.java:422) at oracle.jdbc.driver.T4CVarcharAccessor.getTimestamp(T4CVarcharAccessor.java:639) at oracle.jdbc.driver.GeneratedStatement.getTimestamp(GeneratedStatement.java:316) at oracle.jdbc.driver.GeneratedScrollableResultSet.getTimestamp(GeneratedScrollableResultSet.java:421) at routines.system.JDBCUtil.getDate(JDBCUtil.java:61) at model_bank.ora_to_pg_0_1.Ora_to_Pg.tDBInput_4Process(Ora_to_Pg.java:7666) at model_bank.ora_to_pg_0_1.Ora_to_Pg.tDBInput_2Process(Ora_to_Pg.java:6741) at model_bank.ora_to_pg_0_1.Ora_to_Pg.tDBInput_3Process(Ora_to_Pg.java:5161) at model_bank.ora_to_pg_0_1.Ora_to_Pg.tDBInput_1Process(Ora_to_Pg.java:3837) at model_bank.ora_to_pg_0_1.Ora_to_Pg.runJobInTOS(Ora_to_Pg.java:8289) at model_bank.ora_to_pg_0_1.Ora_to_Pg.main(Ora_to_Pg.java:8114) Caused by: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff] at java.sql.Timestamp.valueOf(Unknown Source) at oracle.jdbc.driver.CharCommonAccessor.getJavaSqlTimestamp(CharCommonAccessor.java:455) at oracle.jdbc.driver.CharCommonAccessor.getTimestamp(CharCommonAccessor.java:416) ... 10 more
