Problem:

• Product Name: Borland AppServer
• Product Version: 6.0.x and 6.5
• Product Component: Logging in EJB Container
• OS/Platforms Version: all supported version
• JDK/Compiler Version: all supported version

BES 6.x How to view all SQL statements sent from the EJB Container to the Database?

Resolution:

In order to troubleshoot your application which interacts with a database, you will need to know the exact SQL statements that are fired to the database from the EJB container.

The following two ways will allow you to do so:

1. Modify partition_server.config (located at ${BES_ROOT}\\var\\domains\\base\\configurations\\\\mos\\\\adm\\properties) by adding -DDataSourceDebug=true as a VM property and add the following entries to logConfiguration.xml
   • <logger name="com.inprise.ejb.cmp" additivity="true">
         <level value="DEBUG"/>
     </logger>
   • <logger name="com.inprise.visitransact.jdbc" addivitity="true">
         <level value="DEBUG"/>
     </logger>
   • <logger name="com.inprise.visitransact.jdbc1w2" additivity="true">
         <level value="DEBUG"/>
     </logger>
2. In BES management console, right-click on Partition, select "Properties", in "Log Settings" tab change "EJB container trace level" to verbose.