Implementation Guide for Oracle Self-Service E-Billing > Customizing Oracle Self-Service E-Billing > Debugging Oracle Self-Service E-Billing >

Displaying SQL Statements

One of the most useful debug features is to display the SQL statements issued to the Oracle Self-Service E-Billing database.

To view the Hibernate SQL statements

1. Open the persistence.xma.xml file for editing. This file is found in the EDX_HOME/xma/config/modules directory. In this directory, EDX_HOME is the directory where you installed Oracle Self-Service E-Billing.
2. Edit the hibernate.show.sql property, changing the value from false to true:

   <prop key=hibernate.show_sql>false</prop>

3. To be able to view the SQL binding values as well (the hibernate.show_sql property allows you to view the SQL statements only), edit the log4j files (log4j.xml, log4jcc.xml, and log4jccenter.xml) which are found in the EDX_HOME/config directory. Change the log level for these two loggers to debug:

   <logger name="org.hibernate.SQL" additivity="false">

   <level value="TRACE"/>

   <appender-ref ref="cba-log"/>

   </logger>

   <logger name="net.sf.hibernate.type" additivity="false">

   <level value="error"/>

   <appender-ref ref="cba-log"/>

   </logger>

4. These configurations apply to Hibernate-based DB access. One exception is reporting-related SQL statements, which are issued without using Hibernate. To view the report SQL statements and their binding values, add a Java -D option:

   java -Ddatasource.debug=true