Session Bean中使用Resultset错误
Adnil 2003-08-21 10:02:09 Session bean中的代码如下
private static final String listSql = "SELECT * FROM DB2ADMIN.OPERATOR ORDER BY REG_DATE";
private Connection conn;
private ResultSet rs;
private CallableStatement stmt;
public void list() throws Exception
{
conn = DBManager.getConnection();
stmt = conn.prepareCall(listSql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery();
}
public boolean aaa() throws Exception
{
rs.next();
summary = rs.getString("SUMMARY");
return true;
}
客户端为jsp调用
xxxbean.list(); //正确,没有问题
然后调用xxxbean.aaa(); //出错,提示如下错误
[03-8-21 9:55:21:833 CST] 28a33abd WebGroup E SRVE0026E: [Servlet 错误]-[DSRA9110E: 关闭 ResultSet。]:com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: 关闭 ResultSet。
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.runtimeXIfNotClosed(WSJdbcResultSet.java:2653)
运行环境为Websphere 5.0
请高手帮我看看,ResultSet怎么会自己关闭的呢?