ResultSet Close

Hi friends !!!

i am facing some problems Continuously , Log entry of that error is as

follows and after that server gets stop .

java.sql.SQLException: ResultSet is closed

at sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcResultSet.clearWarnings(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcResultSet.close(Unknown Source)

Jul 8, 2007 12:34:07 PM org.apache.jasper.runtime.PageContextImpl release

WARNING: Internal error flushing the buffer in release()

Jul 8, 2007 12:34:07 PM org.apache.catalina.core.StandardWrapperValve invoke

WARNING: Servlet.service() for servlet jsp threw exception

WARNING: Servlet.service() for servlet jsp threw exception

java.io.IOException: Stream closed

[793 byte] By [SwapnaliDashratha] at [2007-11-27 10:01:46]
# 1

This error message generally means that you're trying to access the ResultSet while it is closed.

I.e....

resultSet.close();

while (resultSet.next()) { // Throws SQLException: ResultSet is closed.

...

}

I have a silent guess that you're passing the ResultSet around as parameter or return value. Don't do that. Rather map it to Collection<DTO> before closing, then pass it around.

BalusCa at 2007-7-13 0:35:34 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...