# getTimestamp error

**URL:** <https://forum.cloverdx.com/t/gettimestamp-error/443>\
**Category:** CloverDX Platform\
**Created:** [November 18, 2008, 12:00am UTC](https://forum.cloverdx.com/t/gettimestamp-error/443 "2008-11-18T00:00:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![texlnghorn](https://avatars.discourse-cdn.com/v4/letter/t/ecc23a/32.png) [@texlnghorn](https://forum.cloverdx.com/u/texlnghorn)\
**Post date:** [November 18, 2008, 12:00am UTC](https://forum.cloverdx.com/t/gettimestamp-error/443/1 "2008-11-18T00:00:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [November 19, 2008, 7:35am UTC](https://forum.cloverdx.com/t/gettimestamp-error/443/2 "2008-11-19T07:35:40Z")

</div>

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://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=database%5Fusing%5Fjdbc%5Fhow-to&s=timestamp#mapping%5Fjdbc%5Fdata%5Ftypes%5Fonto%5Fclover%5Ftypes)  
[http://wiki.clovergui.net/doku.php?id=graph\_elements:metadata&s=timestamp#field\_formats\_and\_other\_goodies](http://wiki.clovergui.net/doku.php?id=graph%5Felements:metadata&s=timestamp#field%5Fformats%5Fand%5Fother%5Fgoodies)

---

<div class="post-metadata">

**Author:** ![texlnghorn](https://avatars.discourse-cdn.com/v4/letter/t/ecc23a/32.png) [@texlnghorn](https://forum.cloverdx.com/u/texlnghorn)\
**Post date:** [November 19, 2008, 4:25pm UTC](https://forum.cloverdx.com/t/gettimestamp-error/443/3 "2008-11-19T16:25:34Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [November 20, 2008, 8:20am UTC](https://forum.cloverdx.com/t/gettimestamp-error/443/4 "2008-11-20T08:20:49Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![texlnghorn](https://avatars.discourse-cdn.com/v4/letter/t/ecc23a/32.png) [@texlnghorn](https://forum.cloverdx.com/u/texlnghorn)\
**Post date:** [November 20, 2008, 4:38pm UTC](https://forum.cloverdx.com/t/gettimestamp-error/443/5 "2008-11-20T16:38:37Z")

</div>

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.