DBJoin Error

berniedurfee

• March 05, 2010 00:00

• Answered

Follow

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

• 

  avackova

  • March 08, 2010 07:43

  0

  Comment actions Permalink

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

Please sign in to leave a comment.