This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes Other Open Source Projects 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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Reply locked New topic
Author

Castor -- using GROUP BY to retrieve data from database

Sree Potluri
Ranch Hand

Joined: Aug 12, 2009
Posts: 62
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:

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
Marshal

Joined: Jan 10, 2002
Posts: 61092
    
  66

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] [Bear's FrontMan] [About Bear] [Books by Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Castor -- using GROUP BY to retrieve data from database