org.postgresql.util.PSQLException: No results were returned by the query
843859Aug 21 2007 — edited Aug 21 2007Hi all,
Generally this exception can come in two scenarios.
1. heap space (too many data in the db, unable to load that much to virtual memory)
2. Query is not up to Postgres but to Oracle sql.
Anyway, I'm getting this error for a very unusual reason.
This error comes when I want to show the logs.
In my logs table, when I do not have data, there's no errors and it's perfect.
When I have data around 20,000 , still I can show data. Pagination, Limit offset is set following normal rules.
So, can anyone please let me know why I'm getting this error?
And what that I can do in order to overcome this?
Thank you