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?