One Star

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

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.
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

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

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.
2 REPLIES
One Star

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

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.
One Star

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

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