• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: What is the trick to debug SQL?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: What is the trick to debug SQL?


  • Subject: Re: What is the trick to debug SQL?
  • From: James Cicenia <email@hidden>
  • Date: Wed, 21 Feb 2007 17:07:18 -0600

It was my DATETIME column.

Evidently a user with Navicat exported and re-imported the data. This somehow affected the datetime column
and from that point onward it would not update. Even after rebooting etc.


Have no clue why that caused it but it did.

- James

On Feb 21, 2007, at 12:35 PM, Art Isbell wrote:

On Feb 21, 2007, at 8:02 AM, James Cicenia wrote:

This is me testing and it happens? I don't have anyone else in the system to
lock the record....

If any of the attributes that you are using for locking is a floating point or timestamp data type, rounding errors could result in the fetched value not matching the local value. Also, if any of the string attributes used for locking might have trailing space characters, these could be stripped somewhere along the line which would also cause a mismatch. You might need to eliminate floating point and timestamp locking attributes or you might need to explicitly strip trailing space characters from all string attribute values.


Aloha,
Art

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40jimijon.com


This email sent to email@hidden

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: What is the trick to debug SQL?
      • From: Chuck Hill <email@hidden>
References: 
 >What is the trick to debug SQL? (From: James Cicenia <email@hidden>)
 >Re: What is the trick to debug SQL? (From: "John Huss" <email@hidden>)
 >Re: What is the trick to debug SQL? (From: James Cicenia <email@hidden>)
 >Re: What is the trick to debug SQL? (From: Art Isbell <email@hidden>)

  • Prev by Date: Exception in saveChanges(): rowDiffsForAttributes - snapshot does not contain value
  • Next by Date: Re: What is the trick to debug SQL?
  • Previous by thread: Re: What is the trick to debug SQL?
  • Next by thread: Re: What is the trick to debug SQL?
  • Index(es):
    • Date
    • Thread