Internal Website Search

51-60 of 111 resultsRefresh

Order in WHERE Clause affects behaviour on DATE/DATETIME columns

.myText LIKE :query"); q.setParameter("query", "%myQuery%"); I would get an  ... .setParameter("query", "%myQuery%"); I don't get any error! The order of the WHERE clauses

Get multiple entities by Id

;    query1.setParameter("id",idsToRequest);        ... .setParameter("id",idsToRequest);         List resultList2

Calendar in Criteria Querys

;           .setParameter(p, Calendar.getInstance ... "> results = em.createQuery(query)     .setParameter(p, Calendar.getInstance

Sorting problem

;icQuery = em.createQuery(q, Branch.class);     icQuery.setParameter(1, "br.id ... (":query");     query.setParameter("query", "SELECT b FROM Branch b");

Not able to update records

; int updateCount = query.setParameter("value", userCredential.getRegisteredEmailD()).executeUpdate ... )); int updateCount = query.setParameter("value", userCredential.getRegisteredEmailD()).executeUpdate

possible index required for improving query performance

.relationshipType=RelationshipType."+type.toString(), BaseObject.class); query.setParameter("otherParty_id", otherParty); query.setParameter("pclass", partyClass); We have noticed

Getting sales quantity per country with a query, an idea anyone?

; + "GROUP BY ord.getCountry() ");         q2.setParameter("fromD", from.getTime());         q2.setParameter("toD

Criteria Query results in a NoResultException instead of returning object

(queryStr) .setParameter("identityObjectName", obj.getName ... = :identityObjectName"; Object val = em.createQuery(queryStr) .setParameter

Object as parameter results in exception

> q = getEntityManager().createQuery(c);   q.setParameter(idParam, primaryKey);   q.setParameter(companyParam, company);     List<T> resultList = q.getResultList

java 8 LocalDateTime is not working in query

ORDER BY t.date"); query.setParameter("startDate", LocalDateTime.now()); query.setParameter