I have the REVISON_DATE field defined in my metadata as a Date. When I do a join against the table the meta data describes, I am getting the following error:
Node DBJOIN4 finished with status: ERROR caused by: Invalid column type: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor with field REVISION_DATE
I have date fields defined in other meta data and I am not getting this error. The type in the database is DATE. Any ideas
Hello,
you probably don’t have format on your clover date field. To access it as DATE you have to set format without time symbols on your clover field.
For more information see following links:
http://forum.cloveretl.org/viewtopic.php?t=493
http://wiki.clovergui.net/doku.php?id=database_using_jdbc_how-to&s=timestamp#mapping_jdbc_data_types_onto_clover_types
http://wiki.clovergui.net/doku.php?id=graph_elements:metadata&s=timestamp#field_formats_and_other_goodies
I was using a time format. I changed the format to only use date and now I get the error:
Node DBJOIN4 finished with status: ERROR caused by: Invalid column type: getDate not implemented for class oracle.jdbc.driver.T4CNumberAccessor with field REVISION_DATE
Is this problem coming from my oracle driver or clover? And what is T4CNumberAccessor and is this the correct class that should be used to retrieve dates from the database?
T4CNumberAccessor is class from oracle driver package. This errors mean that the driver can’t read the value from database as date nor as timestamp.
From CloverETL.GUI you can browse database and check the column type. If you don’t have CloverETL.GUI you can use AnalyzeDB type for checking data types.
I recreated my metadata using the clover gui and then reran my load and it is now working. I checked the old and new meta data and I don’t see any differences. Oh well, at least it is working now.