ObjectDB Database Search

.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

= JPA.em().createQuery(" SELECT m FROM MyClass m WHERE m.myDate LIKE :query OR m.myText LIKE :query ... ().createQuery(" SELECT m FROM MyClass m WHERE m.myText LIKE :query OR m.myDate LIKE :query"); q.setParameter

;    TypedQuery query = em.createQuery(" SELECT ord FROM OrderDat ord", OrderDat.class ... message: order.name: customer name Exception in thread "main" [ObjectDB 2.x] SELECT ord FROM  == OrderF

The error: Type User is not found (error 301) occurs when I query the db for a type before any instances of that type have been persisted, e.g.: return em.createQuery (" SELECT a FROM User ... ) is preferred. Regarding Extent in JPA, your " SELECT a FROM User a" query is the standard replacement

Hello, I have a class as follows: @Entity public class MyEntity {     boolean properties[]= new boolean[1024]; } I would like to query objects with feature '42': select me from ... ;       " SELECT me FROM MyEntity me WHERE me.isProperty(42)");  

= q.from(MyDateEntity.class);         q. select (root);    ... Query: SELECT $1 FROM MyDateEntity $1 WHERE $1.date=:$$cmlp1 Result Size: 1 The Predicate's toString

my entity class. " Select agsk From AgentSkill agsk Where agsk.Agent.Id=: agid  And agsk ... but in db data exist. " Select agsk.Skill.Queue From AgentSkill agsk Where agsk.Agent.Id=: agid

;  Query q = em.createQuery(" SELECT COUNT(r) FROM DateTime AS r");       ... ; q = em.createQuery(" SELECT COUNT(r) FROM DateTime AS r");        

this : SELECT s  FROM ReturnOrder r JOIN ( SELECT s FROM r.pickUpLabel LIMIT 1) ORDER BY s

(" SELECT bk FROM Signal_Interface bk", Signal_Interface.class); I got the following error.  I ... ; TypedQuery query =         em.createQuery(" SELECT bk

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

( name = "MyQuery.findByOid", query = " select m from MyClass m where m.oid = :oid" ) } ) @Indices

;      .getModelElementsByQuery(" select distinct m from " + PoolImpl.class

You are right. DELETE queries are implemented in ObjectDB differently for JDO and JPA: In JDO: a SELECT

.analyzer.advanced_ selection .RackCategorySelectorPanel$1'   eu.extech.quant.TC(624):567651 [2] Page

(         " SELECT e FROM Enumerations", Enumerations.class

baURI is a byte[]; JP QL select e.baURI.length from URI e where id=82778 JP QL [ObjectDB 2.2.9_04] javax.persistence.PersistenceException Navigation from 'byte[]' through 'length' is invalid (error 763) at com.objectdb.jpa.JpaQuery.getResultList(JpaQuery.java:636) at util.JPQLcmd.QureyCMD(JPQLcmd

Hi, I'm getting a NullPointerException thrown on using DISTINCT. The query works fine if I don't have distinct. However thats NOT a solution as the code generating the query is used for other queries, and some of them do need the distinct. Its only a simple query: QUERY: SELECT DISTINCT $1 FROM

Hi,  I've been using pattern matching with wildcards, and encountered an issue when dealing with the underscore character. The issue is that if it is placed at the end of the string, the "_" behaves like a "*". For example, if I have a query SELECT * FROM table1 WHERE (col1.name LIKE "ke

Getting following error when executing bellow query.   [2022-03-25 14:42:19 #1 query] Error during query execution: Select rt From RtDelete rt Where rt.EntityClass =: encls And rt.DeletedAt : lastcheck({encls-RtCall,lastcheck-Fri Mar 25 14:42:14 IST 2022}) [2022-03-25 14:42:19 #2 *] [ObjectDB

Hi Is there anyway to get the table view , rather than the tree view, when I'm running queries ?   Is there a more advanced version of the explorer anywhere ? Thanks Paul Newman pnewman Paul Newman You can run a query in the Explorer also by selecting [Window Open Table Window] from the menu

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 following (dynamically generated) query causes an NPE: SELECT e FROM Event e WHERE e.account=:account AND TRUE When I change it to a trivial term which evaluates to true, it works fine: SELECT e FROM Event e WHERE e.account=:account AND 1=1 Here is the stack trace: om.objectdb.o

This is the message I get for attached db and this query: SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 WHERE ((($1.qubletID=278) AND NOT (((com.lexware ... of this type in the explorer (by right clicking the type in the Schema tab and selecting Open Tree

= query.from(MomentPayload.class); query. select (fromMomentPayload); query.orderBy(cb.desc ... ; query. select (fromMomentPayload);            

hi, There seems to be an issue with full cross joins & maps. This query: SELECT   $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied  $1 LEFT JOIN $1.qubletFRAGMENTMAP $4,   ... db). The two "Mitglied" entries with id 273 and 274 don't get selected eventhough they do have valid

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();       

Changed merge behavior (following this forum thread ).  Fixed a TomEE - ObjectDB client-server integration issue ( issue #1407 ). Fixed a ClassCastException on selecting an embedded ID field in queries. Fixed an exception ( NullPointerException ) in update queries (since 2.5.5_12). Fixed

The following query: SELECT count(m) FROM Message m WHERE m.attachments.original=:template is generating this exception: [ObjectDB 2.5.1_05] Unexpected exception (Error 990)   Generated by Java HotSpot(TM) 64-Bit Server VM 1.6.0_32 (on Windows 7 6.1). Please report this error on http://www