JPA Is there a way to do something like SELECT <field>, count(*) FROM <table> GROUP BY <field>

Posted by javydreamercsw on Stack Overflow See other posts from Stack Overflow or by javydreamercsw
Published on 2010-05-28T15:45:51Z Indexed on 2010/05/28 17:52 UTC
Read the original article Hit count: 233

Filed under:

jpa

|

jql

I've been looking in the web for examples on the aggregates like count but it seems all of them are using the aggregate alone.

SELECT field, count(*) FROM table GROUP BY field

Should have something like:

field.value1, x1
field.value2, x2
....

I'm looking for a pure JPA answer for this one. If not I guess I can then do further queries just for the count part but that seems unefficient.

Any ideas?

© Stack Overflow or respective owner

Related posts about jpa

Detach an entity from a JPA persistence context (JPA 2.0 / Hibernate / EJB 3 / J2EE 6)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I wrote a stateless EJB method allowing to get an entity in "read-only" mode. The way to do this is to get the entity with the EntityManager then detach it (using the JPA 2.0 EntityManager). My code is the following: @PersistenceContext private EntityManager entityManager; public T getEntity(int… >>> More
AndroMDA maven code generation and JPA Annotations

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using the AndroMDA plugin for maven to generate code from an uml diagram made in MagicDraw. When the code is generated, AndroMDA desings the JPA annotation for the persitence layer. I think that at the compilation process AndroMDA uses Naming Strategies to determine the Table and Column names… >>> More
How to populate Java (web) application with initial data using Spring/JPA/Hibernate

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to setup my database with initial data programmatically. I want to populate my database for development runs, not for testing runs (it's easy). The product is built on top of Spring and JPA/Hibernate. Developer checks out the project Developer runs command/script to setup database with initial… >>> More
Eclipselink problem in a javase project

as seen on Stack Overflow - Search for 'Stack Overflow'
I am getting this error when I am running my eclipselink project. [EL Warning]: 2008.12.05 11:47:08.056--java.lang.NoClassDefFoundError: org/jboss/resource/adapter/jdbc/ValidConnectionChecker was thrown on attempt of PersistenceLoadProcessor to load class com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker… >>> More
JPA thinks I'm deleting a detached object

as seen on Stack Overflow - Search for 'Stack Overflow'
So, I've got a DAO that I used to load and save my domain objects using JPA. I finally managed to get the transaction stuff working (with a bunch of help from the folks here...), now I've got another issue. In my test case, I call my DAO to load a domain object with a given id, check that it got… >>> More

Related posts about jql

JIRA JQL searching by date - is there a way of getting Today() (Date) instead of Now() (DateTime)

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to create some Issue Filters in JIRA based on CreateDate. The only date/time function I can find is Now() and searches relative to that, i.e. "-1d", "-4d" etc. The only problem with this is that Now() is time specific so there is no way of getting a particular day's created issues. i… >>> More
Webservice Jira gives: Error: No such operation 'getIssuesFromJqlSearch' from Jira 4.01

as seen on Stack Overflow - Search for 'Stack Overflow'
When I use the Webservice of Jira, I need to use the method getIssuesFromJqlSearch to describe a certain (JQL) Query. But it returns me "No such operation 'getIssuesFromJqlSearch'". Is this method in Jira 4.01 not implemented yet? BTW: I need a method to get all Issues from one specific project… >>> More
Parsing a JSON feed from YQL using jQuery

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using YQL's query.multi to grab multiple feeds so I can parse a single JSON feed with jQuery and reduce the number of connections I'm making. In order to parse a single feed, I need to be able to check the type of result (photo, item, entry, etc) so I can pull out items in specific ways. Because… >>> More
JPA Is there a way to do something like SELECT <field>, count(*) FROM <table> GROUP BY <field>

as seen on Stack Overflow - Search for 'Stack Overflow'
I've been looking in the web for examples on the aggregates like count but it seems all of them are using the aggregate alone. SELECT field, count(*) FROM table GROUP BY field Should have something like: field.value1, x1 field.value2, x2 .... I'm looking for a pure JPA answer for this one. If… >>> More
How to programmatically construct textual query

as seen on Programmers - Search for 'Programmers'
Here is a query language, more specifically, it's JQL, you can use it in Jira, to search for issues, it's something like SQL, but quite simpler. My case is that, I need to construct such queries programmatically, in my application. Something like: JQLMachine jqlMachine = new JQLMachine() jqlMachine… >>> More