# DBJoin Error

**URL:** <https://forum.cloverdx.com/t/dbjoin-error/668>\
**Category:** CloverDX Platform\
**Created:** [March 5, 2010, 12:00am UTC](https://forum.cloverdx.com/t/dbjoin-error/668 "2010-03-05T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![berniedurfee](https://avatars.discourse-cdn.com/v4/letter/b/59ef9b/32.png) [@berniedurfee](https://forum.cloverdx.com/u/berniedurfee)\
**Post date:** [March 5, 2010, 12:00am UTC](https://forum.cloverdx.com/t/dbjoin-error/668/1 "2010-03-05T00:00:00Z")

</div>

I’m getting the following error in a DBJoin node…

ERROR [WatchDog] - Node DBJOIN0 finished with status: ERROR caused by: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]  
ERROR [WatchDog] - Node DBJOIN0 error details:  
java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]  
at java.sql.Timestamp.valueOf(Timestamp.java:185)  
at oracle.jdbc.driver.CharCommonAccessor.getTimestamp(CharCommonAccessor.java:485)  
at oracle.jdbc.driver.T4CVarcharAccessor.getTimestamp(T4CVarcharAccessor.java:897)  
at oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetImpl.java:963)  
at org.jetel.connection.jdbc.CopySQLData$CopyTimestamp.setJetel(CopySQLData.java:1273)  
at org.jetel.connection.jdbc.CopySQLData.sql2jetel(CopySQLData.java:163)  
at org.jetel.lookup.DBLookup.fetch(DBLookupTable.java:652)  
at org.jetel.lookup.DBLookup.seekInCache(DBLookupTable.java:616)  
at org.jetel.lookup.DBLookup.seek(DBLookupTable.java:568)  
at org.jetel.component.DBJoin.execute(DBJoin.java:237)  
at org.jetel.graph.Node.run(Node.java:390)  
at java.lang.Thread.run(Thread.java:619)

…any ideas on where to start looking for the problem?

Thanks…

---

<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:** [March 8, 2010, 7:43am UTC](https://forum.cloverdx.com/t/dbjoin-error/668/2 "2010-03-08T07:43:48Z")

</div>

You probably trying to get time stamp from not-timestamp field. Check the data types in database and clover record.