topic [resolved] SQLException: Invalid column type: getTimestamp not implemented in Talend Studio

[resolved] SQLException: Invalid column type: getTimestamp not implemented

Anonymous — Sat, 16 Nov 2024 13:08:49 GMT

Hi,
I am trying to transfer a table from one oracle database to other oracle database. I am using tOraclInput and tOracleOutput components.
When i run the job the following exception occurs:
Exception in component tOracleInput_2
java.sql.SQLException: Invalid column type: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.Accessor.unimpl(Accessor.java:358)
at oracle.jdbc.driver.Accessor.getTimestamp(Accessor.java:763)
at oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetImpl.java:796)
at amdwh.loaddata_0_1.LoadData.tOracleInput_2Process(LoadData.java:753)
at amdwh.loaddata_0_1.LoadData.runJobInTOS(LoadData.java:1175)
at amdwh.loaddata_0_1.LoadData.main(LoadData.java:1045)
Please assist. For more details about the job please see the uploaded pictures.
Regards,
Babu.

Re: [resolved] SQLException: Invalid column type: getTimestamp not implemented

Anonymous — Tue, 18 Jan 2011 06:56:01 GMT

Hi,
Error got resolved. Steps followed:
1. As shown in Picture2, select the "Edit Schema" option.
2. In the new window, go to the date fields and change the date pattern according to the source table as shown in Picture3.
3. Later in the tOracleOutput component, choose edit schema option as shown in Picture4.
4. In the new window, change the date field pattern according to the source table as shown in Picture5.
Regards,
Babu.

Re: [resolved] SQLException: Invalid column type: getTimestamp not implemented

_AnonymousUser — Thu, 05 May 2011 05:25:52 GMT

hi
im trying to migrate data from oracle to sql server even im getting this error its something like this...

statistics] connecting to socket on port 3603
connected
Exception in component tOracleInput_1
java.sql.SQLException: Invalid column type: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.Accessor.unimpl(Accessor.java:358)
at oracle.jdbc.driver.Accessor.getTimestamp(Accessor.java:763)
at oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetImpl.java:796)
disconnected
at oraclesqlserver.ex_0_1.ex.tOracleInput_1Process(ex.java:1585)
at oraclesqlserver.ex_0_1.ex.runJobInTOS(ex.java:2288)
at oraclesqlserver.ex_0_1.ex.main(ex.java:2159)
Job ex ended at 09:51 05/05/2011.

the following is my job