Consultor Eletrônico



Kbase P115337: "ResultSet is closed" exception when closing a prepared statement in WebSphere Application Server 5.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   4/19/2006
Status: Unverified

FACT(s) (Environment):

Progress 9.1D
Progress 9.1E

SYMPTOM(s):

"ResultSet is closed" exception when closing a PreparedStatement object in WebSphere Application Server

java.sql.SQLException: ResultSet is closed

The ResultSet object is closed before closing the PreparedStatement object

Using WebSphere Application Server (WAS) version 5.1.1

CAUSE:

WebSphere was also calling the close() method for the ResultSet object in the background when you make a call to the close() method of the PreparedStatement object. The ResultSet object was already closed, hence the exception.

FIX:

This issue does not occur in WAS version 5.1.1.8. Please contact WebSphere technical support for further help with this issue.