This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes Other Application Frameworks and the fly likes Castor -- using GROUP BY to retrieve data from database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Frameworks » Other Application Frameworks
Reply locked New topic

Castor -- using GROUP BY to retrieve data from database

Sree Potluri
Ranch Hand

Joined: Aug 12, 2009
Posts: 62

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:

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

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)
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63874

Please do not cross-post the same question in multiple forums. It wastes people's time when multiple redundant conversations take place. Please click this link ⇒ CarefullyChooseOneForum ⇐ for more information.

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: Castor -- using GROUP BY to retrieve data from database
It's not a secret anymore!