[#|2016-05-05T09:34:52.263+0600|SEVERE|glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=28;_ThreadName=Thread-2;|org.firebirdsql.jdbc.FBSQLException: Result set is already closed.
        at org.firebirdsql.jdbc.FBStatementFetcher.checkClosed(FBStatementFetcher.java:232)
        at org.firebirdsql.jdbc.FBStatementFetcher.fetch(FBStatementFetcher.java:187)
        at org.firebirdsql.jdbc.FBStatementFetcher.next(FBStatementFetcher.java:137)
        at org.firebirdsql.jdbc.AbstractResultSet.next(AbstractResultSet.java:250)
        at org.apache.jsp.ИМЯ-СТРАНИЦЫ-С-ОШИБКОЙ_jsp._jspService(ИМЯ-СТРАНИЦЫ-С-ОШИБКОЙ_jsp.java from :77)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:770)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:411)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:473)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:377)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:770)
        at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1550)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)
        at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:331)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231)
        at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317)
        at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)
        at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)
        at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)
        at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)
        at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)
        at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
        at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
        at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
        at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
        at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
        at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
        at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
        at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
        at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
        at java.lang.Thread.run(Thread.java:662)
|#]

[#|2016-05-05T09:34:52.278+0600|SEVERE|glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=19;_ThreadName=Thread-2;|org.firebirdsql.jdbc.FBSQLException: The result set is closed
        at org.firebirdsql.jdbc.AbstractResultSet.checkCursorMove(AbstractResultSet.java:217)
        at org.firebirdsql.jdbc.AbstractResultSet.next(AbstractResultSet.java:249)
        at org.apache.jsp.ИМЯ-СТРАНИЦЫ-С-ОШИБКОЙ_jsp._jspService(ИМЯ-СТРАНИЦЫ-С-ОШИБКОЙ_jsp.java from :77)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:770)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:411)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:473)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:377)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:770)
        at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1550)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)
        at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:331)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231)
        at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317)
        at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)
        at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)
        at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)
        at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)
        at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)
        at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
        at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
        at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
        at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
        at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
        at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
        at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
        at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
        at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
        at java.lang.Thread.run(Thread.java:662)

                DataSetD dsd = (DataSetD)session.getAttribute("dataset");
                if (dsd.getDolgDetail(l_schet, dBeg, dEnd)) {
                    float summa = 0, summa_opl = 0, sum = 0, sum_opl = 0;
                    GregorianCalendar data = new GregorianCalendar();
                    int year = data.get(GregorianCalendar.YEAR);
                    int year_old = year;
                    int year_first = year;
                    SimpleDateFormat sdf = new SimpleDateFormat("dd.MM.yyyy");

                    try {
                        while (dsd.rs.next()) {
                            data.setTime(dsd.rs.getDate("datedoc"));
                            year = data.get(GregorianCalendar.YEAR);
                            if (year != year_old) {
                                %><tr align="center">
                                    <td><B>Итого</B></td>
                                    <td></td>
                                    <td><B><%= sum %></B></td>
                                    <td><B><%= sum_opl %></B></td>
                                </tr><%
                                sum = 0;
                                sum_opl = 0;
                                year_old = year;
                            }
                            sum += dsd.rs.getFloat("summa");
                            %><tr>
                                <td><%= dsd.rs.getString("tarif_group") %></td>
                                <td align="center"><%= sdf.format(dsd.rs.getDate("datedoc")) %></td>
                                <%--<td align="right"><%if(rs.getString("summa") != null) %><%=rs.getFloat("summa")%></td>
-------------------НОМЕР СТРОКИ ПОЧЕМУ ТО ВОТ ЗДЕСЬ^^^^^^^^^^^^^^^^^-------------------
                                <td align="right"><%if(rs.getString("summa_opl") != null) %><%=rs.getFloat("summa_opl")%></td>--%>
                                <td align="right"><%= dsd.rs.getFloat("summa") %></td>
                                <td align="right"><%= dsd.rs.getFloat("summa_opl") %></td>
                            </tr><%
                        }
                        //dds.rs.close();
                        if (year != year_first) {
                            %><tr align="center">
                                <td><B>Итого</B></td>
                                <td></td>
                                <td><B><%= sum %></B></td>
                                <td><B><%= sum_opl %></B></td>
                            </tr> <%
                        }
                        %><tr align="center">
                            <td><B>Всего</B></td>
                            <td></td>
                            <td><B><%= summa %></B></td>
                            <td><B><%= summa_opl %></B></td>
                        </tr><%
                        //session.setAttribute("AccessId", 3);
                    } catch (Exception e) {
                        e.printStackTrace();
                        %><p>Ошибка операции</p><%
                    }
                }
                else { %><p>Соединение не установлено</p><% }
                dsd.Disconnect();

    public void Disconnect() {
        try {
            if (rs != null) {
                if (!rs.isClosed()) rs.close();
                rs = null;
            }
        }
        catch (SQLException e) {
            e.printStackTrace();
        }

        try {
            if (s != null) {
                if (!s.isClosed()) s.close();
                s = null;
            }
        }
        catch (SQLException e) {
            e.printStackTrace();
        }

        try {
            if (c != null) {
                //c.rollback();
                if (!AutoCommit) c.commit();
                if (!c.isClosed()) c.close();
                c = null;
            }
        }
        catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public boolean getDolgDetail(String l_schet, String dBeg, String dEnd) {

        return getOpen("select ");
    }


    public boolean getOpen(String sql) {

        boolean res = false;

        if (rs == null) {
            if (Connect())
                res = Open(sql) != null;
        }
        else res = Open(sql) != null;

        return res;
    }


    public ResultSet Open(String sql) {

        try {
            if (rs != null)
                if (!rs.isClosed()) rs.close();
        }
        catch (SQLException e) {
            e.printStackTrace();
        }
        finally {
            rs = null;
        }

        try {
            if (s != null) rs = s.executeQuery(sql);
        }
        catch (SQLException e) {
            e.printStackTrace();
        }

        return rs;
    }

    public boolean Connect(){

        try {
            Class.forName("org.firebirdsql.jdbc.FBDriver");
        }
        catch (ClassNotFoundException e) {
            e.printStackTrace();
            //System.out.println("Firebird JCA-JDBC driver not found in class path");
            return false;
        }

        Driver d = null;
        try {
            d = DriverManager.getDriver(database);
        }
        catch (SQLException e) {
            e.printStackTrace();
            //System.out.println ("Unable to find Firebird JCA-JDBC driver among the registered drivers.");
            return false;
        }

        c = null;
        try {
            Properties prop = new Properties ();
            prop.put("user", user);
            prop.put("password", password);
            prop.put("lc_ctype", "WIN1251");

            c = d.connect(database, prop);
            c.setAutoCommit(AutoCommit);
        }
        catch (SQLException e) {
            e.printStackTrace();
            return false;
        }

        try {
            s = c.createStatement(resultSetType, resultSetConcurrency);
        }
        catch (SQLException e) {
            e.printStackTrace();
            return false;
        }

        return true;
    }