Castor -- using GROUP BY to retrieve data from database

[Sree Potluri]

Hi,

I am trying to get the count of columns present in database. I have column1, column2, column3, table is tableName in database and class1 is the class which maps to database.
To get the count of number of records in database, I use the query:

   SELECT COUNT(*)  FROM class1 where class1.column1 = 'XX2' 

I want to use a query where I can directly use column and table name from database.

 SELECT column2, column3, DISTINCT(column1, column2, column3) , count(*) FROM table GROUP BY column2, column3  

When I am running this using castor, I am getting error as "org.exolab.castor.jdo.oql.OQLSyntaxException: An incorrect token of type was found near , (found COMMA, but expected RIGHT_PAREN)

[Paul Clapham]

I don't see anything about XML in this post. Looks like what Castor calls "Java-to-SQL persistence". So let's move this to the ORM forum.