Not a date ?

oldforum

• July 16, 2007 00:00

• Answered

Follow

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

• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.