I’ve found a similar question linked [here](https://community.denodo.com/answers/question/details?questionId=906Du00000000tXIAQ&title=java.sql.SQLException%3A+Internal+error+executing+query.+No+results+returned).
The answer says that it seems like there’s a connection issue between your Denodo Virtual DataPort Server and your client application Weblogic. The “No results error” is usually a secondary error thrown as a result of a primary error like connection issue or credentials issue. I recommend taking note of the primary error first.
First, you can go to **Denodo Designer Studio** or **Virtual DataPort Administration Tool**, and try to query the table if it’s returning any result or if it is throwing an exception. This will eliminate the underlying data source and the Denodo server as the issue.
Second, if you’re using the JDBC driver for **Denodo 8.0 update 20220815**, check if your Denodo Virtual DataPort server is the same version or higher. It is recommended to use the version of Denodo JDBC driver that is the same as your Denodo server.
Lastly, you can change the parameter **connectTimeout**, which by default, waits 120 seconds to establish a connection, to something higher. This can resolve the closed connection issue you’re getting. I recommend checking out this [User Guide](https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/access_through_jdbc/parameters_of_the_jdbc_connection_url/parameters_of_the_jdbc_connection_url) about the different JDBC connection parameters to know more.
Hope this helps!