In the datbase when one of the columns in a table is mapped to java.sql.Types.REAL and on this column when a ResultSet.getFloat() is called it returns a float value.
This causes a SyncProviderException while synchronizing the data in the rowset back to the datbase when one of the keyColumns is the above mentioned column. This happens because while fetching the data a double value (the data in the already stored in the DB) is compared with a float value (got by doing a ResultSet.getFloat()/ResultSet.getObject() call) and hence the row to be updated is not retrieved.
This causes a SyncProviderException while synchronizing the data in the rowset back to the datbase when one of the keyColumns is the above mentioned column. This happens because while fetching the data a double value (the data in the already stored in the DB) is compared with a float value (got by doing a ResultSet.getFloat()/ResultSet.getObject() call) and hence the row to be updated is not retrieved.