Enabling SQL Logging From the Command Line

To enable SQL logging for an application, set the default EOAdaptorDebugEnabled to YES . This can be done from a UNIX shell (a Bourne Shell under Windows NT) using the defaults command.

 
defaults write 
MyApp
 EOAdaptorDebugEnabled YES

When you launch your application, the SQL prints to standard error.n the launch window. You can also enable SQL logging for all applications using the defaults command.

 
defaults write NSGlobalDomain EOAdaptorDebugEnabled YES

For more information abouts the defaults system, see the NSUserDefaults class specification in the Foundation Framework Reference and the defaults man page.

Enabling SQL Logging From Project Builder

You can also use the launcher to enable SQL logging by clicking the launcher preferences button (looks like a check mark), clicking the Arguments tab and entering

 
-EOAdaptorDebugEnabled YES

This sets the EOAdaptorDebugEnabled command line argument to YES every time Project Builder's launcher starts your application.

Some developers find it convenient to enable SQL logging globally and selectively disable it for individual applications with the launcher ( -EOAdaptorDebugEnabled NO ).

Enabling SQL Logging Programmatically

The EOAdaptorContext class actually uses the EOAdaptorDebugEnabled flag. In order to turn on SQL logging for all EOAdaptorContexts that get created, you use the EOAdaptorContext static method (class method in Objective-C) setDebugEnabledDefault .

 
EOAdaptorContext.setDebugEnabledDefault(true);

The best place to put this code is in the application's constructor so that all EOAdaptorContexts that get created will log their SQL. Be sure to import com.apple.yellow.eoaccess.* .

You can also enable debugging for individual adaptor contexts by sending them a setDebugEnabled message. This is also useful when you need to turn the logging on and off while the application is running. To find out how to access your application's adaptor contexts, see the programming topic Accessing Adaptor Sublayer Objects .