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…