Problem with RowSetDynaClass
I'm using the RowSetDynaClass as I need to close my resultset and return the connection to the connection pool quickly.
Resultset rs = stmt.executeQuery("something");
RowSetDynaClass rowset =new RowSetDynaClass(rs);
I iterate through it by the following:
Iterator iter = biomartSNPsByRegion.getRows().iterator();
while(iter.hasNext()){
DynaBean row = (DynaBean) iter.next();
The instance of DynaBean holds all the row information held in the RowSetDynaClass. Retrieving a property can be done easily, i.e. row2.get("Somecolumnname");
However, for some reason, when I try and return the data from the DynaBean it throws an invalid property exception i.e. I have passed the wrong column name to it. However, I've used MySQL and returned the metadata from the original resultset to confirm that I am passing it the correct column name, however I still get this error. Help! Please!
