Quick answer
'Unable to retrieve JDBC result set' means the query reached the database but failed to return rows — usually a wrong or unqualified table name, missing permissions, an invalid SQL syntax, or a closed connection or statement. Verify the table name and schema qualification, check the account's SELECT privilege, test the raw SQL directly against the database, and confirm the connection is open.
There are a few potential causes for this issue. Here are a few things you can try:
=> Make sure that the table name you're using is spelled correctly, and that you have the necessary permissions to read from it.
=> Verify that your JDBC connection is established correctly and that you can connect to the database.
=> Check that your query is valid. It's possible that you have a syntax error in your query that's causing the error.
=> Make sure that the table exists in the database.
=> Check your JDBC driver version, it might be out of date or incompatible with the version of the database you are using.
=> Check your query log and see if any other error information is provided which can help you troubleshoot the issue.