tDBInput error in Date format column Oracle

Anonymous — Sat, 16 Nov 2024 02:09:24 GMT

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

Re: tDBInput error in Date format column Oracle

manodwhb — Mon, 15 Jun 2020 07:46:59 GMT

@waoufan ,can you share sample data form the data base for that column and try to use yyyy-mm-dd hh:mm:ss.

topic Re: tDBInput error in Date format column Oracle in Talend Studio

tDBInput error in Date format column Oracle

Re: tDBInput error in Date format column Oracle