Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB polling : query with subquery

843007Jan 17 2013
Hi,

We are upgrading the 10g code to 11g, where one process has the DB polling with custom SQQL. This SQL has a subquery like,

Select Name, ID, CID from tabl1 where lastdate + (select num_value from table2 where column2 = "xxx") <= sysdate

We want the similar functionality in 11g. The upgraded code generated few artifiacts like toplink. We have bulilt that and deployed to server. But it is not polling the data eventhough the matching records are present in the tables.

Please let us know how to fix this issue.

Thanks,
Vinoth

Comments

alwu-Oracle
Hi,

I loaded the data you mentioned in another thread and run the query using Jena API. I got one answer for the query without seeing any problem.
I also checked the output you uploaded. It is unclear why the original query failed. There was no exception printed out.

Could you please run the query using Jena API (instead of Joseki) and then send the stack trace?

Thanks,

Zhe Wu
784525
Zhe,
This query is returning, the problem is that it takes a remarkably long time. It's taking nearly 4.5 seconds when most finish in tens or hundreds of milliseconds. When I looked into the logs to investigate the possible problems, I discovered that this query is responsible for over 8000 SELECT statements being sent to the database.

Making this query via the Jena API causes the same behavior.

The code I'm using to submit the query along with the output that is printed to standard out are bundled here
alwu-Oracle
In my test, I only see one query. Please email me your contact information so that I can give you a call.

Thanks,

Zhe Wu
784525
Awesome, your offline help fixed it. Turns out I had the wrong sdordf.jar. The rest of the patch was applied properly, but I had missed that step apparently. This query is executing very quickly now, no flood of SELECTS. Thank you.

Edited by: nyoung on Aug 19, 2010 2:29 PM
alwu-Oracle
Cool. Is the other problem still there?

1115984

Zhe
784525
yes. still truncating results.
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 14 2013
Added on Jan 17 2013
#soa-process-management, #soa-suite-discusssions
0 comments
80 views