This content has been marked as final. Show 6 replies
Surprisingly I can see no SQL in console with this key.
I'm running JDev 126.96.36.199 with standalone WLS 10.3.6 on the same machine added as Integrated Server - I can see all the server output in JDev console, but no SQL.
I added "-Djbo.debugoutput=console" as project run option and server start argument through WLS console as well.
Do I need to take some additional steps to see executed queries?
I've added "-Djbo.debugoutput=console" as project run option and server start argument through WLS console (I see this argument in IDE console when the server is starting), set adf, adf.internal and adf.jbo loggers to TRACE:32 in logging.xml, restarted the server dozen times, debug the page but still there is no SQL in IDE console - somebody tell me why???
Ok, I've found the query in server logs in file system. That I see is wonderful.
I have a query like:
I apply filter to KindContentName column and the resulting SQL with filter is:
SELECT KIND_CONTENT.NAME AS KIND_CONTENT_NAME, CONTENT.NAME, ...
ADF is applying WHERE clause to the wrong attribute!
SELECT * FROM (SELECT KIND_CONTENT.NAME AS KIND_CONTENT_NAME, CONTENT.NAME, ... ) QRSLT WHERE NAME LIKE ...
Even more fun here. In the View Object overview I notice that KindContentName attribute's Alias property = "NAME" and that seems to be the problem reason. I type "KIND_CONTENT_NAME" instead, Ctrl+S, close the VO, reopen it and see that KindContentName attribute's Alias property still = "NAME".
Changing Alias property from overview do not affect source code.
Changing ALIAS property in XML source solved this issue.
Edited by: ILya Cyclone on Nov 22, 2012 4:12 PM