Getting Incompatible Clover & JDBC field types

CloverDX Platform
1

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

2

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.

3

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.

“dpavlis”

YES!
The order was wrong for a couple of fields.

All working now.

THANK YOU
Tony