Re: show table status

[Andrus Adamchik]

Hi Jack,

I see this is on the right track now...
On Jul 21, 2007, at 1:15 AM, Jack O'Connor wrote:

java.lang.ClassCastException: org.objectstyle.cayenne.DataRow
	at com.statistics.ComputeStatistics.getcsDiskSpace 
(ComputeStatistics.java:838)
        at com.statistics.MainStatistics.main(MainStatistics.java:66)

So you are casting the result to something else. Cast it to map:


List results = context.performQuery(....);
Iterator it = results.iterator();
while(it.hasNext()) {
   Map result = (Map) it.next();

   /// do something...
}

It recieved the correct number of rows (34), but when I try to  
access them, I get errors. I've tried using an arbitrary class, and  
creating a model in cayenne especially for the "show table status"  
table, with attributes "Data_length" etc, so I have the correct  
getters and setters, but no luck...

Is there a way to extract generic data form an undefined "Map"?

Yes - keys in the map are the column names from the ResultSet  
returned from MySQL. The simplest way to see what keys are valid is  
this:

   System.out.println("Keys: " + result.keySet());

So you can form instance use (but consult the output of the statement  
above for the correct key values)

   Number x = (Number) result.get("Data_length");

Andrus