Rép : JodaDateTime and mySQL update.

[Raymond NANEON]

Hi James,

Unlock date of your entity description in your model (i.e : dateModified)  and retry.

Ray

Envoyé depuis iCloud

Le 19 jun 2013 à 07:02, James Cicenia <ja...@jimijon.com> a écrit :

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?

 

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/rnaneon%40me.com

This email sent to rnan...@me.com

 

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com