Thanks for the reply, but all the SQLTemplates on that page require a
class/table to refer to (all the examples are for Artist.class). The
MySQL command "show table status" doesn't apply to any particular class...
Jack
Michael Gentry wrote:
I would think you'd be able to use an SQLTemplate to perform that kind
of query:
http://cayenne.apache.org/doc20/sqltemplate-query.html
You'll want to call setFetchingDataRows(true) on your SQLTemplate
object, too, otherwise Cayenne will try to make CayenneDataObjects out
of it. Do this before you run performQuery().
/dev/mrg
On 7/19/07, Jack O'Connor <[EMAIL PROTECTED]> wrote:
Hi all, in my project I need to extract the total db size(kb). Im using
Cayenne 1.2.3 and MySQL and I found the SQL command "show table status
from <db name>" which displays a table of information about all of the
tables in a certain db. This table has columns like "Name"(of table),
"Data_length" and "Index_length", and apparently the best way to extract
the size(kb) of a db is to sum the Data_length and Index_length columns
of this table.
Does anyone know how I can get the results of this query into java?
Many Thanks
Jack
