3 Replies Latest reply on Mar 26, 2004 5:24 AM by datadate

    JBoss output displaying ejb ql parameters instead of questio

    datadate Newbie

      Hello,

      we are trying to debug our application and we have the feeling the the genereted sql query from the eqjb ql is incorrect.

      We are using JBoss 3.2.3 and Oracle9i with JDBC driver: classes12.zip.
      JBoss and oracle are running under RedHat AS.
      We are using ejbs with container managed persistence, generated from the database by JDeveloper.

      We have managed to output the query information by adding the following block to the log4j.xml file:

      <category name="org.jboss.ejb">
       <priority value="TRACE" />
      </category>
      


      Query now looks like this:
      DEBUG [PLS_RELATIES#findByPrimaryKey] Executing SQL: SELECT id FROM PLS_RELATIES WHERE id=?
      


      We would like to configure jboss to also display the parameters in the sql query instead of question marks.

      Can anybody help us to achieve this?

      Thanks!