Debugging generated SQL statements
smilie Apr 17, 2003 3:21 AM
Hi!
I am using JBoss-3.0.4 with CMP Entity Beans. Something goes wrong with the generated sql statement of my finder methods, but I dont know what to do to see the generated sql statements! I have changed the log4.xml and standardjaws.xml but nothing happend... here my actual log4j.xml:
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/" debug="false">
<!-- ================================= -->
<!-- Preserve messages in a local file -->
<!-- ================================= -->
<!-- A time/date based rolling appender -->
<!-- Rollover at midnight each day -->
<param name="DatePattern" value="'.'yyyy-MM-dd"/>
<!-- Rollover at the top of each hour
<param name="DatePattern" value="'.'yyyy-MM-dd-HH"/>
-->
<!-- The default pattern: Date Priority [Category] Message\n -->
<!-- The full pattern: Date MS Priority [Category] (Thread:NDC) Message\n
-->
<!-- A size based file rolling appender
-->
<!-- ============================== -->
<!-- Append messages to the console -->
<!-- ============================== -->
<!-- The default pattern: Date Priority [Category] Message\n -->
<!-- ====================== -->
<!-- More Appender examples -->
<!-- ====================== -->
<!-- Buffer events and log them asynchronously
<appender-ref ref="FILE"/>
<appender-ref ref="CONSOLE"/>
<appender-ref ref="SMTP"/>
-->
<!-- EMail events to an administrator
-->
<!-- Syslog events
-->
<!-- Log events to JMS (requires a topic to be created)
-->
<!-- ================ -->
<!-- Limit categories -->
<!-- ================ -->
<!-- Decrease the priority threshold for the org.jboss.varia category
-->
<!--
| An example of enabling the custom TRACE level priority that is used
| by the JBoss internals to diagnose low level details. This example
| turns on TRACE level msgs for the org.jboss.ejb.plugins package and its
| subpackages. This will produce A LOT of logging output.
If you use replace the log4j 1.2 jar with a 1.1.3 jar you will need to
change this from XLevel to XPriority.
-->
<!-- ======================= -->
<!-- Setup the Root category -->
<!-- ======================= -->
<appender-ref ref="CONSOLE"/>
<appender-ref ref="FILE"/>
<!-- Clustering logging -->
<!-- Uncomment the following to redirect the org.javagroups and
org.jboss.ha categories to a cluster.log file.
<appender-ref ref="CLUSTER"/>
<appender-ref ref="CLUSTER"/>
-->
</log4j:configuration>
Could someone help me?
Regards,
Thilko