Not a date?

CloverDX Platform
1

Hi,

I have run into this exception, on a DBInputTable component :

java.lang.RuntimeException: not a Date : 2007-04-18 08:00:00+02 in record # 0 in field # 0 when parsing record #98 field ddt_arr_anest_room
at org.jetel.connection.SQLDataParser.populateField(SQLDataParser.java:188)
at org.jetel.connection.SQLDataParser.parseNext(SQLDataParser.java:163)
at org.jetel.connection.SQLDataParser.getNext(SQLDataParser.java:94)
at org.jetel.component.DBInputTable.execute(DBInputTable.java:171)
at org.jetel.graph.Node.run(Node.java:364)
at java.lang.Thread.run(Thread.java:619)

Well, 2007-04-18 08:00:00+02 obviously IS a date (a timestamp with time zone to be exact).
Any idea what this exception means ?

Franck

2

Hmm, strange.

I assume the field is defined as DATE/DATETIME on DB side. It might be a problem with TIMESTAMP type.

You might temporarily solve it by specifying the corresponding field on Clover side as string and then in some reformat component convert it to date.

Could you let us know more details about the problem - db version, clover version, the graph - ideally through http://bug.clovergui.net/

David.