soql limit exception

Question

I am getting a SOQL System.LimitException. I know there is a query within a for loop. But it's my work, it needs to be there. What i wanted to do is handle this exception in apex controller like

try{ 
  if exception; 
}catch(Exception e) {
  set massage here;
}

Can i achieve something like this?

thanks..

Answer 1

You cannot catch Limit exceptions.

The best you can do is use the Limits methods to test when you are approaching the limits and act accordingly (for example stop further processing and record an error).

https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_methods_system_limits.htm

For example

if (Limits.getLimitQueries() > 0) {
  //do your query
} else {
  //handle this error situation
}

Answer 2

No there is no such way to catch Limit exceptions in try catch. All other exception can be caught in try catch but not related to limit exceptions.