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
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