Getting Incompatible Clover & JDBC field types

anthonyinoz

• April 07, 2012 00:00

• Answered

Follow

Caused by: java.sql.SQLException: Incompatible Clover & JDBC field types - field 'RM_COMMS_DATE'; Clover type: date; SQL type: NUMERIC
at org.jetel.connection.jdbc.CopySQLData.sql2jetel(CopySQLData.java:168)
at org.jetel.connection.jdbc.SQLDataParser.populateField(SQLDataParser.java:225)

This is using Version: 3.3.0.063M1.

Error is occurring in DBInputTable with SQL
SELECT RM_ID, RM_COMMS_DATE, RM_RAW_DATA
FROM RM_MESSAGE
RM_COMMS_DATE BETWEEN TIMESTAMP'2012-04-03 16:10:00' AND TIMESTAMP'2012-04-03 16:20:00'

Thanks

• 

  dpavlis

  • April 09, 2012 16:41

  0

  Comment actions Permalink

  Check the Clover metdata used in DBInputTable - are they in the same order as you have them in the SQL query - RM_ID, RM_COMMS_DATE, RM_RAW_DATA with the respective data types ?
  
  The error message suggests that Clover tries to populate data field RM_COMMS_DATE (defined as date) but the database returns the value from query as NUMERIC.
• 

  anthonyinoz

  • April 09, 2012 23:29

  0

  Comment actions Permalink

  Check the Clover metdata used in DBInputTable - are they in the same order as you have them in the SQL query - RM_ID, RM_COMMS_DATE, RM_RAW_DATA with the respective data types ?
  
  The error message suggests that Clover tries to populate data field RM_COMMS_DATE (defined as date) but the database returns the value from query as NUMERIC.

  
  
  
  YES!
  The order was wrong for a couple of fields.
  
  All working now.
  
  THANK YOU
  Tony

Please sign in to leave a comment.