[jboss-user] [EJB 3.0] - Re: Stateless Session bean throwing error

[vishnu1980]

Hi Wolfgang

I am attaching the code of only the method which has the error(i.e line number 1244)

------------------------------------------------------------

    public void load(int report_id, String roleName, SimpleDateFormat udf) throws ReportException {
        reportId = report_id;
        if (Report.RPT_EXCEL.equals(type)) {
            Connection con = null;
            PreparedStatement pstmt = null;
            try{
                con = ds.getConnection();
                pstmt = con.prepareStatement("select TITLE, DESCRIPTION, PROP_FILE, CATEGORY_ID from REPORT_" + cid + " WHERE ID = ?");
                pstmt.setInt(1, report_id);
                ResultSet rs = pstmt.executeQuery();
                if ((rs != null) && rs.next()) {
                    title       = rs.getString(1);
                    description = rs.getString(2);
                    filename    = rs.getString(3);
                    catId       = rs.getInt(4);
                }
                if (rs != null) rs.close();
            }
            catch (Exception e) {
                logger.error(e);
                throw new ReportException(e.getMessage());
            }
            finally {
                try {
                    if (pstmt != null) pstmt.close();
                    if (con != null) con.close();
                }
                catch (Exception ignore) {}
            }
        } else {
            pkeys = new Vector(16, 16); /* restored reports need pkeys too */
            this.load("report" + report_id + ".prop", roleName, udf);
        }
    }

-------------------------------------------------------------

line 1244 is : this.load("report" + report_id + ".prop", roleName, udf); 

Please please help

Vishnu

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4005172#4005172

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4005172