Need to see exact query execution in Oracle ADF

java sql oracle oracle-adf
Fr_nkenstien picture Fr_nkenstien · Jan 15, 2013 · Viewed 8.9k times · Source

I am using Oracle ADF in Oracle Jdeveloper 11g. In the application i have a search screen which will go through records as per the search values given.

The search screen uses a view object. My requirement is to check out which final query is being executed on the DB after all the dynamic creation. what all parameters do i need to change to get the same.

also My application logs are at FINEST Level.

Please help

Answer

User404 picture User404 · Jan 15, 2013

I used this one a few weeks back. Works like a charm. http://huysmansitt.blogspot.be/2012/09/adf-bc-logging.html

Related questions

Using setDate in PreparedStatement

In order to make our code more standard, we were asked to change all the places where we hardcoded our SQL variables to prepared statements and bind the variables instead. I am however facing a problem with the setDate(). Here …

Read More
Cleanest way to build an SQL string in Java

I want to build an SQL string to do database manipulation (updates, deletes, inserts, selects, that sort of thing) - instead of the awful string concat method using millions of "+"'s and quotes which is unreadable at best - there …

Read More
JDBC ResultSet: I need a getDateTime, but there is only getDate and getTimeStamp

I would like to get the DATETIME column from an Oracle DB Table with JDBC. Here is my code: int columnType = rsmd.getColumnType(i); if(columnType == Types.DATE) { Date aDate = rs.getDate(i); valueToInsert = aDate.toString(); } else if(columnType == Types.…

Read More