• 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: Christoph Zimmermann <email@hidden>
  • Date: Fri, 23 Feb 2007 23:12:24 +0100

NOW EVERYTHING WORKS in Eclipse:

I had to remove a blank line at the end of the WOD and HTML File of the Excel Component.

Am 23.02.2007 um 20:08 schrieb Chuck Hill:


On Feb 23, 2007, at 10:46 AM, Christoph Zimmermann wrote:

Hello!

I also have the problem to enable SQL debugging with Xcode. No matter witch attribute i use (-DEOAdaptorDebugEnabled=true or EOAdaptorDebugEnabled YES) I can,t see any SQL syntax. I don,t have errors now, but I will need it. It worked a while ago. Interestingly the same Code transferred to WoLips shows SQL Log.

Can you see the Console window in Xcode? Perhaps you just have it dragged up/down to where it is invisible.



On the otther hand the Code in xcode produces perfectly XSL Files using Project Wonders ERExtensions and ExcelGenerator. This doesn:t work in Eclipse. It also worked here a while ago.

What does not work. Is there an exception?

Chuck


I reinstalled the projects in both IDEs, set the encoding of every file to UTF-8 (this enabled SQL logging in Eclipse), but no luck.


Can anybody help me?

My Config: MacBookPro, MacOs X 10.4.8, Wonder 3.0, Xcode 2.4.1 all Java and Webobjects Updates.

Thanks

Christoph

Am 22.02.2007 um 00:08 schrieb Chuck Hill:

Just a guess from long years of bitter experience: it probably changed the time zone.

Chuck

On Feb 21, 2007, at 3:07 PM, James Cicenia wrote:

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:
40global-village.net


This email sent to email@hidden


--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects






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


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:
40global-village.net


This email sent to email@hidden


--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects







_______________________________________________ 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: 
 >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>)
 >Re: What is the trick to debug SQL? (From: James Cicenia <email@hidden>)
 >Re: What is the trick to debug SQL? (From: Chuck Hill <email@hidden>)
 >Re: What is the trick to debug SQL? (From: Christoph Zimmermann <email@hidden>)
 >Re: What is the trick to debug SQL? (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: How-tos: Eclipse + WO
  • Next by Date: Re: Exception in saveChanges(): rowDiffsForAttributes - snapshot does not contain value
  • 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