JBoss output displaying ejb ql parameters instead of questio

[datadate]

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!

[datadate]

Hi.

we really need a solution badly for this problem.

Hopefully anyone will post an answer soon.

Greets.

[triathlon98]

You have not enabled trace logging properly. Look at the (commented) examples in log4j.xml file.

The question marks are really question marks. That is what the PreparedStatements look like. The actual values are set later (and these values are logged using trace logging).

Joachim

[datadate]

Thanks, looking into it right now.