Re: DbQueryManager bug?

Hi Geert,

Thanks for responding.

Here is the code snippet:

definitions: dbm is DbQueryManager object
                 p is a Product object which needs to be set with its "dynamic" properties
                 ds is the Datasource object


Select select = new Select(ds).field("*").from("productpropertydata as ppd, propertytype as pt")
                                .where("ppd.productID","=",productID)
                                .whereAnd("ppd.propertyID = pt.id");
                                   
           
 PropertyRowProcessor rp = new PropertyRowProcessor();
           
 if (dbm.executeFetchAll(select,rp)){                    
         for (Property prop: rp.properties){
                p.setProperty(prop);
          }
  }


// definition of PropertyRowProcessor
class PropertyRowProcessor extends DbRowProcessor {
    public ArrayList<Property> properties = new ArrayList<Property>();
   
    public boolean processRow(ResultSet rs) throws SQLException {
        try {
            while (rs.next()){                      
                PropertyType pType = new PropertyType();
                ....


                Property property = new Property(pType);
                property.setName(name);
                property.setValue(rs.getString("value"));

                properties.add(property);
            }
            return true;
        } catch (SQLException e){
            return false;
        }      
    }     
}


I pasted the sql query string of the Select object select into phpmyadmin tool and it returned 2 rows which is what I expect. When I debugged the code above and stepped line by line inside the while(rs.next()) loop of PropertyRowProcessor it only looped once. I looked
into the resultset object and I don't pretty much understand its internals.

After many failed trials I tried to do the "traditional" way of querying the database and used the following code:

    Select select = new Select(ds).field("*").from("productpropertydata as ppd, propertytype as pt")
                                    .where("ppd.productID","=",productID)
                                   .whereAnd("ppd.propertyID = pt.id");
                                   
           
     PropertyRowProcessor rp = new PropertyRowProcessor();        

      DbStatement dbst = ds.getConnection().createStatement();           
      dbst.executeQuery(select);
      rp.processRow(dbst.getResultSet());
      for (Property prop: rp.properties){
             p.setProperty(prop);
      }           

Alas this code worked! the resultset object passed to the processRow function looped twice!

Thanks, I hope that you could clarify on this matter.

Kerwin




--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "rife-users" group.
To post to this group, send email to rife-users@...
To unsubscribe from this group, send email to rife-users-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rife-users?hl=en
-~----------~----~----~----~------~----~------~--~---