java - Evaluation Errors in Eclipse:Can't Perform Nested Evaluation? -

i getting message:

can't perform nested evaluation

in dialouge when querying db fetch records. execution seems stop there / program not moving next breakpoint , hung in eclipse. how solve error?

the code:

public int findcount(string countquery, object[] params) {     try {         bigdecimal count = (bigdecimal) jpahelper             .findbynativequery(countquery, params);          return count.intvalueexact();     } catch (exception e) {         return 0;     }  } 

the query:

first of all, may unwise put production code on publicly available website. if have signed nda, may in real trouble employee doing that.

second, query complex. joins total of 11 tables, uses subqueries, function calls , full-text search. depending on size of tables, query may take lot of time (think: hours). that's why debuggers stops @ executing , waits database finish , return results.

if want see what's going on on database, i'd suggest:

1. see execution plan query. should doable explain keyword, or better use graphical tools visualize that.
2. verify (or ask db admin) see if there indexes / partitions / statistics in place.