rs.next() returning false for second row..

[Ajit Kanada]

Hi
I am using jdk1.4 SQL200 to retrive data from miltiple tables..
I have following code..
I get problem in rsForQuery2.next() ie for second dynamic query it shows rsForQuery2.next() is false so its unable to enter while ..
what can be the problem?
Ajit

 
public static void getXML(String workerid,String exedate) {
        
        try {
            
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("jdbc :-o	 dbc :mrgreen: snApps5","name","pwd");
            //Document            
            Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
            String queryStr = "SELECT WORKORDERID "+
            "FROM WORKORDER where WORKERID='"+ workerid+"'"+
            "AND EXECUTEDATE='"+exedate +"'";
            
            ResultSet rs=stmt.executeQuery(queryStr);
            ResultSetMetaData rsmd = rs.getMetaData();
            
            int i=1;
            while(rs.next()) {
                
                int wid=rs.getInt("WORKORDERID");
                String dynamicQuery =" select basket_row.itemtype, basket_row.product_id,basket_row.price,basket_row.entitytype,basket_row.order_no,basket_row.entity_id from basket_row "+
                "where basket_row.entity_id ='"+wid+"'";
                
                System.out.println("DQUERY\n\n"+dynamicQuery);
                
                Statement stmtForQuery2 = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
                ResultSet rsForQuery2 = stmtForQuery2.executeQuery(dynamicQuery);
                int j=1;
                ResultSetMetaData rsmd1 = rsForQuery2.getMetaData();
                int noOfCols  = rsmd1.getColumnCount();
                System.out.println("numcolumns  "+noOfCols);
               // System.out.println(rsForQuery2.next());
                
                while(rsForQuery2.next()) {
                    System.out.println("Inside while****");                   
                    for(int count=1;count<noOfCols;count++) {
                        if(rsmd1.isSearchable(count)) {
                            System.out.println("column.."+rsmd1.getColumnName(count));
                           //System.out.println("value......."+rsForQuery2.getObject(count));
                        }
                    }//for 
                }
                
                i++;
            }//while
            
            con.close();
        }
        catch(Exception sqe) {
            
            sqe.printStackTrace();
        }
    }
    

[Jamie Robertson]

most likely, your query returns no matches. Did you check your query ( cut and pasted for your System.out.println() ) in your SQL editor to verify that indeed the query returns results?
Jamie

[Ajit Kanada]

Hi
Yes u are correct .
Its because i had only one row..
Thanx for the reply
Ajit