ObjectDB ObjectDB

Internal Website Search

51-60 of 111 resultsRefresh

Order in WHERE Clause affects behaviour on DATE/DATETIME columns

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

Get multiple entities by Id

= em.createQuery("SELECT e FROM MyEntity e WHERE e.id IN :id");         query1.setParameter("id ... ");         query2.setParameter("id",idsToRequest);         List resultList2 = query2.getResultList

Calendar in Criteria Querys

));         results = em.createQuery(query)             .setParameter(p, Calendar.getInstance ... .createQuery(query)     .setParameter(p, Calendar.getInstance().getTime()).getResultList(); Automatic

Sorting problem

BY ?1 DESC";     icQuery = em.createQuery(q, Branch.class);     icQuery.setParameter(1, "br.id ... ");     query.setParameter("query", "SELECT b FROM Branch b"); This is because parameters are not parsed as

Not able to update records

= query.setParameter("value", userCredential.getRegisteredEmailD()).executeUpdate(); And called method ... (userCredential, sessionID)); int updateCount = query.setParameter("value", userCredential

possible index required for improving query performance

=RelationshipType."+type.toString(), BaseObject.class); query.setParameter("otherParty_id", otherParty); query.setParameter("pclass", partyClass); We have noticed that this query slows down in

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

.getPaidTimeD() " + "BETWEEN :fromD AND :toD " + "GROUP BY ord.getCountry() "); q2.setParameter("fromD", from.getTime()); q2.setParameter("toD", to.getTime()); List<Object[]> res = q2.getResultList

Criteria Query results in a NoResultException instead of returning object

() + " = :identityObjectName"; Object val = em.createQuery(queryStr) .setParameter ... .createQuery(queryStr) .setParameter("identityObjectName", "demo

Object as parameter results in exception

= getEntityManager().createQuery(c);   q.setParameter(idParam, primaryKey);   q.setParameter

java 8 LocalDateTime is not working in query

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

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support