My Oracle Support Banner

WebLogic Server 10.3.x: Getting "java.sql.SQLException: Result set already closed" Exception When Calling (Doc ID 1338615.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Weblogic Server - Version 10.3 and later
Information in this document applies to any platform.


In WebLogic Server version 10.3 and above, an issue of getting "java.sql.SQLException: Result set already closed" exception was reported when calling Below is snippet of the exception trace at the time of the issue:

java.sql.SQLException: Result set already closed
at weblogic.jdbc.wrapper.ResultSet.checkResultSet(
at weblogic.jdbc.wrapper.ResultSet.preInvocationHandler(
at Source)
at ....customer code...

Below is snippet of code which was calling was causing the above exception.

ResultSet rs1=stmt.execute("select count(*) from customer table");
  stmt.execute(...);//this call will close the current resultset, just rs1


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.