Databases
StackOverflow2013
Postsdbo
POSQL statement conversion to hibernate criteria (having count clause)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQL statement conversion to hibernate criteria (having count clause)
    primarykey
    data
    text
    <p>I have an SQL query that I would like to convert into a criteria (Hibernate 3.3.2) to use it into my persistancy layer. That's the query :</p> <pre><code>select last_name from member where member.end_date &gt; SYSDATE group by member.last_name having count(member.last_name) &gt;1; </code></pre> <p>I already try a lot a combinations, but there is no result that would be good for me ... This is my code :</p> <pre><code>Criteria criteria = getSession(false).createCriteria(Member.ENTITY_NAME); criteria.setProjection(Projections.projectionList() .add(Projections.groupProperty("lastName")) .add(Projections.count("lastName").as("cptLastName")) ); criteria.add(Restrictions.ge("endDate", now)) .add(Restrictions.le("startDate", now)) //.add(Restrictions.gt("cptLastName", new Integer(1))) .addOrder(Order.asc("lastName")) ; </code></pre> <p>With writing it with the comment line, I have an objects list that contains the name and the number of times that the name appears in the database. But when i would like to decomment it, this the error : java.sql.SQLException: ORA-00904: "Y1_": invalid identifier</p> <p>To develop this code, I am inspired by different post below:</p> <ul> <li><p><a href="https://stackoverflow.com/questions/3919445/hibernate-criteria-projecting-count-with-group-by-clause">Hibernate Criteria: Projecting Count with group by clause</a></p></li> <li><p><a href="https://stackoverflow.com/questions/8310516/hibernate-count-rows-with-some-criterias">Hibernate count rows with some criterias</a></p></li> <li><p><a href="https://stackoverflow.com/questions/1372317/how-do-we-count-rows-using-hibernate">How do we count rows using Hibernate?</a></p></li> <li><p><a href="https://stackoverflow.com/questions/8605708/how-to-use-having-count-with-hibernate">HOW to use HAVING COUNT(*) with hibernate</a></p></li> <li><p><a href="https://stackoverflow.com/questions/467172/hibernate-criteria-api-having-clause-work-arounds">Hibernate Criteria API - HAVING clause work arounds</a></p></li> </ul> <p>I think I'm not far of the solution but is there anybody to help me? If you have questions, don't hesitate to ask me it. And if you found another workaround for me to paste to this query, don't hesitate to propose it...</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USuser1645271
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSQL statement conversion to hibernate criteria (having count clause)
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POSQL statement conversion to hibernate criteria (having count clause)
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload