Technote (FAQ)
Question
This technote outlines the steps for enabling SQL logging for WebSphere® Portlet Factory, which can be helpful for debugging problems with database calls.
Answer
1. Edit the SQL calls you are using.
2. Expand the Events, Statistics and Logging section.
3. Place a checkmark in the boxes titled Log SQL Statements and Log SQL Warnings.
4. Save the builder call.
5. Save the model.
6. Open in edit mode the log4j.properties file under projectRoot\WEB-INF\config
7. Replace the word INFO with DEBUG for debugTracing so that the line looks like this:
log4j.logger.bowstreet.system.debugTracing=DEBUG,DebugTracing
8. Run the model and execute the action that results in the SQL call. The logs will be written to under the application's WEB-INF\logs directory in debugTracing.txt.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.