ObjectDB Database Search

Why does this NamedQuery only work sometimes? @NamedQuery(name = "ItemDB.getPartial", query = " SELECT i FROM com.model.ItemDB i JOIN i.lstSupplier s WHERE s.strSupNumber LIKE ?1") I use ... (" SELECT i FROM com.model.ItemDB i LEFT JOIN i.lstSupplier s WHERE s.strSupNumber LIKE '%5785483

Hi I would know if this type of query is supported By JPA: select sum(nb1), sum(nb2), sum(nb3) from table If yes I have this methode that return a list of Long: public List sommeClassesRep(Choix choix) { Query listClassRepHost = em.createQuery(" SELECT SUM(h.nb1xx), SUM(h.nb2xx),SUM(h.nb3xx),SUM(h

get the documents through a query of this type: getEntityManager().createQuery(" select e from Document e ... of the document object is all there. It is as if ObjectDB was not executing the select statement

to the plugin runtime classpath. Fixing  " SELECT p FROM Point p" to  " SELECT p FROM Pilot p

] button after select the entity class and specify the number of objects in the dialog box,  ... select the entity class and specify the number of objects to construct. Click the Create and Persist

username) {         Query q = em.createQuery(" SELECT t FROM ... .NoResultException {         Query q = em.createQuery(" SELECT t FROM Unit

.createQuery(" SELECT t FROM Transfer t").getResultList();     System.out.println(t.size ... ;   List t = em1.createQuery(" SELECT t FROM Transfer t").getResultList();    

Hi, Query 1: SELECT DISTINCT $1, $2.lastName AS $O0 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.profile $2 ORDER BY UPPER($2.lastName) Correctly returns all the different lastName's for each $1 Now the same but with upper SELECT DISTINCT $1, UPPER($2.lastName) AS

For this query: select est from Estudiante est where est.identificacion = :identificacion Any help

My application is ready to support different JPA implementation - also ObjectDB. But the automated tests show one little difference. Following search statment will be created by one test case: select i from User i where i.status = :status and (UPPER(i.email) like :value) Now we assume

we are using this aggregate query to collect some data: select p3.doubleValue,c1.classIdentifier,c1.objectName,sum(p4.doubleValue),sum(p4.doubleValue*p5.doubleValue),0,p7.doubleValue,p3.name,count(o) from ObjectNode o INNER JOIN o.properties p1 INNER JOIN o.properties p2  INNER JOIN o

.from(Person.class); criteriaQuery. select (root); Predicate criteria = criteriaBuilder

= "findFinishedJobsBetweenTimeIntervals", query = " SELECT J FROM JobEntity J, IN(J.statuses) JS WHERE " +     "J

] select u from == User 0) {         throw new Exception(  

; If we try to ecexute a Query (in the second main method): TypedQuery q = em.createQuery(" SELECT c

Support Hi, Query I'm running is: SELECT DISTINCT $1 FROM CDI $1 JOIN $1.attributeList $2 JOIN $1

Hi, I'm working on some reporting stuff in our application. One of few different reports should include activity on last modified objects. The query for now looks like this: select date(insp.lastModificationDate), insp.modifiedBy, insp.description.length(), insp.products.size(), insp.picture from

Greetings ObjectDB team, Suppose I pass a List of persistent objects to some query as a parameter, can I navigate to those objects' fields ? E.g.: SELECT x FROM ClassX x WHERE x.a IS MEMBER OF :y.b Thank You ! geekox86 Mohannad AlAwad You cannot navigate from a collection of objects

(" SELECT t FROM TeamA t JOIN t.squad s where s.name='Mark Wahlberg'", TeamA.class); List q7results

a conversion program that: Retrieves all the entity objects from the ObjectDB database (e.g. by using " SELECT o

;   SELECT $1.id FROM Pa3DataKey $1 WHERE $1.timestamp

the target existence, if yes then accumulate, else insert a new record. String sQ2 = " select i from ItemList

", query=" SELECT c FROM Player c WHERE c.uid = :id") Any thoughts on how this error even make sense? :L

( "[a-zA-Z- ]+" ) && linie.get( 2 ).length()= 2 ) { lab_points = (Integer) em.createQuery( " select n.lab ... ) .executeUpdate() ; updateEm.getTransaction().commit() ; System. out .println(em.createQuery( " select n

Hello, I have 2 entity types, which I want to query, ParserJob and Tag. Unfortunately there seems to be a bug if I use the lower date select : SELECT j.jobId, SIZE(j.tags) FROM ParserJob j WHERE j.dateCreated = :date I get the correct result (1 Tag). You find a test case at  . Please start

the department object" ? How does one refresh an object? If the mappedby tag maps to: SELECT e from EMPLOYEE e ... If the mappedby tag maps to: SELECT e from EMPLOYEE e WHERE e.department=department then shouldn't

the syntax for selective update is unclear as the syntax in the documentation seems to be wrong. Query Update Action Set transferred = 0 where a.objectsInCharge.nodePath like "/(PR)W4455NS01%" and a.objectsInCharge.nodePath like "%MARAS%" results in Query Execution Error

I observed that on new ObjectDb v.2.6.4.b10 query below causes internal exception SELECT DISTINCT $1 FROM Pa3DictionaryItem $2 JOIN $2.values $1 WHERE ($2.namespace == 'com.anritsu.pa3.ttcn3' AND $2.key == 'TliEvent' AND $1 != '') Query above also worked fine on ObjectDb version 2.6.1.b06 Harman

Hello, we found another query bug: SELECT a FROM ArtifactImpl a LEFT OUTER JOIN a.tcSignal s  WHERE a.startStep.stepNumber = 0  AND (s.name IN ('In1') OR a.tcSignal IS NULL) With 2.7.6_b6 we get the expected three result objects. But with 2.8.0 we get only two result objects

(Unknown Source)   for that query: SELECT DISTINCT a from Action a WHERE a.objectsInCharge

driver, for SELECT queries with JPQL syntax (not SQL, except SQL queries that are also valid

; a = em.createQuery(" SELECT a FROM A a", A.class).getSingleResult();