[#|2013-08-22T17:43:01.241+0400|INFO|glassfish3.1.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=179;_ThreadName=Thread-2;|2013-08-22 17:43:01,241 ERROR [http-thread-pool-8088(3)] (CommonCoreUtil.java:93) - Exception is caught:java.sql.SQLRecoverableException: Closed Statement
	at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:6289)
	at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:5757)
	at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:5662)
	at oracle.jdbc.driver.OracleResultSet.getLong(OracleResultSet.java:797)
	at com.sun.gjc.spi.base.ResultSetWrapper.getLong(ResultSetWrapper.java:496)

[#|2013-08-22T17:43:01.241+0400|INFO|glassfish3.1.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=179;_ThreadName=Thread-2;|2013-08-22 17:43:01,241 ERROR [http-thread-pool-8088(3)] (CommonCoreUtil.java:93) - Exception is caught:java.sql.SQLRecoverableException: Closed Statement
	at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:6289)
	at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:5757)
	at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:5662)
	at oracle.jdbc.driver.OracleResultSet.getLong(OracleResultSet.java:797)
	at com.sun.gjc.spi.base.ResultSetWrapper.getLong(ResultSetWrapper.java:496)
	at promo.dao.promolifecycle.AnswerDAOJdbc.extractAnswerGoods(AnswerDAOJdbc.java:1977)
	at promo.dao.promolifecycle.AnswerDAOJdbc.fetchAnswers(AnswerDAOJdbc.java:549)
	at promo.dao.promolifecycle.AnswerDAOJdbc.getAnswersForNeeds(AnswerDAOJdbc.java:230)


...
 rs = stm.executeQuery();
 answers = fetchAnswers(rs);   // 230 строка
...
private Collection<Answer> fetchAnswers(ResultSet rs) throws SQLException, DAOException {
...
AnswerGoods answerGoodsItem = extractAnswerGoods(rs); // 549 строка
...
private AnswerGoods extractAnswerGoods(ResultSet rs) throws SQLException, DAOException {
        AnswerGoods answerGoods = new AnswerGoods();
        answerGoods.setId(rs.getLong("ANSWER_GOODS.ID")); // 1977 строка
...

 
            rs = stm.executeQuery();
            answers = fetchAnswers(rs);   //   here we are
        } catch (SQLException e) {
            DBUtil.logAndThrowDAOException(LOG, e);
        } finally {
            releaseResources(conn, rs, stm);
        }
...
protected void releaseResources(Connection connection, ResultSet[] resultSets,
			Statement[] statements) {
		if (resultSets != null) {
			for (ResultSet resultSet : resultSets) {
				try {
					if (resultSet != null) {
						resultSet.close();
					}
				}
				catch (SQLException e) {
					logger.warn("Could not close result set: " + e);
				}
			}
		}

		if (statements != null) {
			for (Statement statement : statements) {
				try {
					if (statement != null) {
						statement.close();
					}
				}
				catch (SQLException e) {
					logger.warn("Could not close statement: " + e);
				}
			}
		}

		DataSourceUtils.releaseConnection(connection, dataSource);
	}

    
public AnswerCollection getAnswersForNeeds(Collection<? extends Identifiable> needIds, boolean isOperation) throws DAOException {
...
	Connection conn = getConnection();
        PreparedStatement stm = null;
        ResultSet rs = null;
        Collection<Answer> answers = null;
        ...
            rs = stm.executeQuery();
            answers = fetchAnswers(rs);   //   here we are
        } catch (SQLException e) {
            DBUtil.logAndThrowDAOException(LOG, e);
        } finally {
            releaseResources(conn, rs, stm);
        }