[qirana]

hi everybody i need ur help to solve this error.i think it cause by my looping. but i dont know how to solve it. hope somebody will help me.

below is my code:

public Vector getForwardPlan()
{
    Vector vPage = new Vector();
    try
    {   
        
        DBConnection dbconn = new DBConnection ();
        stmt = dbconn.getConnection().createStatement();
        
        sql = "SELECT  count (f.plandate) ";
        sql = sql + " FROM forwardplan f, audittypecode a, openfile o, company c ";
        sql = sql + " WHERE f.fileid = o.fileid and ";
        sql = sql + " f.type = a.code and ";
        sql = sql + " o.companyid = c.companyid";
        
        rs = stmt.executeQuery(sql);
        while (rs.next())
        {
            Record = rs.getInt(1);
        }
        rs.close();
        stmt.close();
        
        if (Record > 0)
        {
            stmt = dbconn.getConnection().createStatement();
            sql = "SELECT  f.fileid,f.plandate, a.desc, c.name, c.roc ";
            sql = sql + " FROM forwardplan f, audittypecode a, openfile o, company c ";
            sql = sql + " WHERE f.fileid = o.fileid and ";
            sql = sql + " f.type = a.code and ";
            sql = sql + " o.companyid = c.companyid ";
            
            rs = stmt.executeQuery(sql);
            
            int j = 0;
            int page = 0;
            
            for (int i=1;i<=Record;i++)
            {
                while (rs.next())
                {
                    ForwardPlan forwardplan = new ForwardPlan();
                    
                    j++;
                    
                                        forwardplan.setPlandate(rs.getString("plandate"));
                
        String sthn = rs.getString("plandate").substring(0,4);
        String sbln = rs.getString("plandate").substring(5,7);
        String shr = rs.getString("plandate").substring(8,10);
                    
                    
                   int thn = Integer.parseInt(sthn);
                   int bln = Integer.parseInt(sbln);
                   int hr = Integer.parseInt(shr);
                    
        String emeldate = calculateDate(hr, bln, thn);
                    
                    
        String Cdate = forwardplan.getDateToday();
                    
                    
                    
        if (emeldate == Cdate);
        {
           j++;
                        
        forwardplan.setFileid(rs.getString("fileid"));
                        forwardplan.setPlandate(rs.getString("plandate"));
    forwardplan.setDesc(rs.getString("desc"));
    forwardplan.setName(rs.getString("name"));
    forwardplan.setRoc(rs.getString("roc"));
                        
                
    vPage.add(forwardplan);
                        
    if(( j%recordLimit==0))
    {
            vData.add(vPage);
            page = page+1;
                            j=0;
                            vPage= new Vector();
                                                    }
                        
                        if(((Record/recordLimit)==page) && ((j%recordLimit)>0))
                        {
                            page = page + 1;
                            vData.add(vPage);
                            
                            
                        }
                                                            
                    }
                
                }
                
                rs.close();
                stmt.close();
            }
    
            
        }
        
        
    }
    
    catch (SQLException ee)
    {
            System.out.println(ee);
    }
    
    return vData;
 
} 

the code is OKuntill at the code : if (emeldate == Cdate);
please help me...thank you in advance

[ajs5mz2]

Can you run this and post the stacktrace?

[UnrealEd]

looking at the title of your topic, i'd say your database isn't executing the query. Have a look at the autocommit setting of your database. It might be that you have to send a command to your database that it execute all entered queries.

I don't think your code works fine until "if (emeldate == Cdate);", as the error clearly says that there's a problem with the ResultSet, which are located above the if.

Replace this:

System.out.println(ee); 

with:

ee.printBackTrace(); 

and post the output, it will tell us a lot more

I assume you're using some class fields, as you don't set the type for certain variables? could you tell us which ones, that would make it easier as well

cheers,
UnrealEd