I am getting an error:Caused by: com.webobjects.eoaccess.EOGeneralAdaptorException: updateValuesInRowDescribedByQualifier -- er.extensions.jdbc.ERXJDBCAdaptor$Channel method failed to update row in database
Here is the SQL being generated:
UPDATE Device SET lastReportedLatitude = ?, lastReportedLongitude = ?, dateModified = ? WHERE (id = ? AND badge is NULL AND hwid = ? AND lastReportedLatitude = ? AND lastReportedLongitude = ? AND osGatewayID = ? AND ppAppKey = ? AND token = ? AND zoneID is NULL)" withBindings: 1:41.85897038322115(lastReportedLatitude), 2:-87.66461452477394(lastReportedLongitude), 3:2013-06-19T08:52:51.734-05:00(dateModified), 4:2(id), 5:"6C219B57-8184-4537-85CE-B4A33F78F91E"(hwid), 6:41.8588996399584(lastReportedLatitude), 7:-87.6646017842811(lastReportedLongitude), 8:0(osGatewayID), 9:"679DB-17774"(ppAppKey), 10:"63080abb26010101ee4c...34a91d9a62bdaf20440a"(token)>
Here is it converted to run :
This Fails:
UPDATE Device SET lastReportedLatitude = 41.85897038322115, lastReportedLongitude = -87.66461452477394, dateModified = 2013-06-19T08:52:51.734-05:00 WHERE (id = 2 AND badge is NULL AND hwid = "6C219B57-8184-4537-85CE-B4A33F78F91E" AND lastReportedLatitude = 41.8588996399584 AND lastReportedLongitude = -87.6646017842811 AND osGatewayID = 0 AND ppAppKey = "679DB-17774" AND token = "63080abb26010101ee4c...34a91d9a62bdaf20440a" AND zoneID is NULL);
However if I put quotes around dateModified it does update.
Am I missing a setting? |