• 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: Logging SQL statements
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Logging SQL statements


  • Subject: Re: Logging SQL statements
  • From: Art Isbell <email@hidden>
  • Date: Sun, 18 Dec 2005 10:52:47 -1000

On Dec 18, 2005, at 10:01 AM, Stirling Olson wrote:

Notice the difference in digits on the timestamp values. This causes WO to think that the row has been updated outside the application so the update fails.

I've experienced similar problems with timestamp values on other databases as well. My only solution has been to eliminate float/ double/decimal and timestamp types as attributes used for locking in my eomodels.


Another workaround might be to limit the precision in which timestamp values are stored in a database. I.e., instead of storing the current timestamp which can be to milliseconds or even microseconds, use the current timestamp to create a new timestamp to the precision of seconds only, and store the new timestamp instead. Of course, this won't work for existing timestamp values or those stored by non-WO processes unless they also limit the precision to seconds.

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:
This email sent to email@hidden


References: 
 >Logging SQL statements (From: Stirling Olson <email@hidden>)
 >Re: Logging SQL statements (From: "Jerry W. Walker" <email@hidden>)
 >Re: Logging SQL statements (From: Stirling Olson <email@hidden>)
 >Re: Logging SQL statements (From: Alex Finkel <email@hidden>)
 >Re: Logging SQL statements (From: Stirling Olson <email@hidden>)
 >Re: Logging SQL statements (From: Mike Schrag <email@hidden>)
 >Re: Logging SQL statements (From: Stirling Olson <email@hidden>)

  • Prev by Date: RE: ovverriding methods
  • Next by Date: HotSpot not at correct virtual address. Sharing disabled.
  • Previous by thread: Re: Logging SQL statements
  • Next by thread: Re: Logging SQL statements
  • Index(es):
    • Date
    • Thread