Skip to Main Content

Java Development Tools

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!

Execute Query causing stuck thread wait.

2750374Aug 24 2017 — edited Oct 4 2017

Im using JDeveloper 12.1.2.0.0. I have a view object with a view criteria. This view object is selecting from a fairly large table and on occasion i get a an alert of a stuck thread and about every 2 weeks or so it gets to the point my server locks up. The stuck thread occurs after setting the parameter in my criteria and then doing an execute. 99% of the time its fine though and executes very quickly as its only returning one row as the parameter is the primary key.

The code is as followed and the stuck thread trace says its from line calling masterVO.executeQuery(); Note: i added the outReq > 0 to try and catch any cases where that may be null and trying to return all rows in my table.

          //outReq is an int.

            if(outReq > 0){

                ViewObjectImpl masterVO = this.getLotStepRequestsView1();

                masterVO.setNamedWhereClauseParam("inrequestid",outReq);       

                masterVO.executeQuery();

            }

Am i missing something obvious with this execute? Is there a way to put a timeout on the execute query?

This post has been answered by 2750374 on Oct 3 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2017
Added on Aug 24 2017
7 comments
1,274 views