OJB / Oracle XE sql debug-display problem

Posted by Jay on Stack Overflow See other posts from Stack Overflow or by Jay
Published on 2009-11-24T16:38:06Z Indexed on 2010/06/13 6:12 UTC
Read the original article Hit count: 291

Filed under:
|
|
|

Hello, I have a Java application, and use OJB as my ORM technology. I have an Oracle XE installation locally to develop against. The problem is when I need to debug a problem, I like looking at the SQL output. Here is an example of SQL I can view through the "Top SQL" interface in Oracle XE:

 select a_bunch_of_fields
 from KREW_DOC_TYP_T A0
 WHERE ((UPPER(A0.DOC_TYP_NM) LIKE :1) AND A0.ACTV_IND = :2) AND A0.CUR_IND = :3

The problem is I would like to see the real value instead of ":1". I can't seem to find how I can configure this. I know the real values are working, because the application is responding as expected, for the most part (hence the bugs I am working on).

Thanks, Jay

© Stack Overflow or respective owner

Related posts about java

Related posts about sql