using criteria instead of native queries

Question

I have the below hibernate native query as shown below the idea is not to use the native query and switch to hibernate criteria api

 <![CDATA[select count(iilnmp.INV_LINE_NOTE_ID) from IOA_INV_LINE_NOTE_MAP iilnmp , 
                                                    IOA_INVOICE_LINE_NOTES iiln , IOA_INVOICE_LINE iil
                                                   where   iilnmp.INV_LINE_NOTE_ID = iiln.ID and iiln.INLI_ID =iil.id and iil.ID = ?]]>

which i am calling from a method as shown below now my query is that instead of having native query can i use criteria also to achieve the same result

 public int findAttachementsCount(long id)
    {   
        Query query = session.getNamedQuery("attachmentQuery");
        query.setParameter(0, id);
        int attachCount = query.list().size(); 
        return attachCount;
    }

Folks please advise for this. Can somebody please look this into priority..!!

score 0 · Answer 1 · edited May 23 '17 at 12:16

0

public int findAttachementsCount(long id)
    Criteria c = session.createCriteria(YourClass.class, "alias");
    c.createAlias("fieldOfyoursecondClass.role", "role"); // inner join by default
    c.setProjection(Projections.rowCount())
    c.add(Restrictions.eq("alias.id", id));
return ((Long)c.uniqueResult()).getIntValue();

Original question - Joins | Original question - Source - Count

edited May 23 '17 at 12:16

Community

1
1

answered May 19 '16 at 17:17

pedroct92

404
1
4
18

Thanks but i guess there must be two create alias statement since the join is between 3 tables – dgfd hgfhg May 19 '16 at 18:11
Yes, just add it to the query then you are fine. – pedroct92 May 19 '16 at 18:16

score 0 · Answer 2 · answered May 19 '16 at 20:30

Criteria c = session.createCriteria(IOA_INV_LINE_NOTE_MAP.class, "iilnmp");
c.createAlias("iilnmp.INV_LINE_NOTE_ID", "iiln");
c.createAlias("iiln.INLI_ID", "iil");

// restrictions
c.add(Restrictions.eq("iil.ID", id));

// projections
c.setProjections(Projections.count("iilnmp.INV_LINE_NOTE_ID"));

// run query
c.uniqueResult();

using criteria instead of native queries

2 Answers2