Hi,
Pls I need help on the below :
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
