47 | Is named-query supported in orm.xmlI prefer to keep custom JPQL named queries in an external file, e.g. orm.xml, rather than in the entity classes, for example: <named-query name= "DataValue.deleteByCapabilityAndCreationtime"> <query>delete from DataValue d where d.capabilityId = :capabilityId |
47 | Debuging query before executionHi, Is is possible in any way to get string representation of a query right before execution, after setting parameters? Of course it's easy to print out query string when we build it by concatenating ... implementation. What exactly do you suggest? The query string with parameter values embedded, replacing |
47 | Java FX tableview fill with an aggregated queryDear ObjectDB, Can someone give me a tip, to make the aggregated query work. I am filling a tableview with a normal query "SELECT p From Recept p, with no problem. But when I trying to fill a tableview with an aggregated query : "SELECT SUM(getValue()) AS value ,getUnit() AS unit,getName() AS name |
47 | Query in JPA2 with LEFT JOIN on INNER JOINHow write a query in JPA2 with LEFT JOIN on INNER JOIN? select a.description, a.id, p1 ... your query may indicate that you model is not optimized for JPA. Instead of connecting objects using ids ... Support Hi, this is my critera query: CriteriaBuilder cb = entityManager.getCriteriaBuilder |
47 | Query Method NullPointerException on List iterationHello, i'm new to ObjectDB and want to create a query which sums up the product categories ... categoryName Expected query outcome: SupplierName Category1_Count Category2_Count Supplier1 5 13 Supplier2 3 7 I tried to do this with a query method: select s.supplierName, s.countCategory("category1 |
47 | Efficient query on EmbeddedId understand that making a query just on entity.id.field1 is efficient. Of course, making a query ... is: what about making a query just on entity.id.field2? I suppose it will not be an efficient query ... can be part of user defined indexed. Accordingly queries on field1 (and on both fields) will be fast |
47 | Several parallel threads to speed up query on one DB is the producer from DB (based on a query) and I would like to speed it up. I have tried using several entity ... . each query in a thread is running simultaneously - but it looks sometimes the "query threads ... it is coming from some ObjectDB low level I/O settings? Any help on how to speed up query by doing |
47 | how explorer queries worki'm curious as to how the explorer is able to execute queries when its obviously not aware ... to execute somewhat generalized queries and i won't know what classes are in the object model ahead ... need the classes for running ordinary queries. However, if you use user defined methods in queries |
9 | Multiple MEMBER OF query query gets no items: SELECT i FROM Item i WHERE :label1 MEMBER OF item.labels AND :label2 MEMBER OF item.labels Is it a bug or JPQL query is wrong? Best regards, Pablo. Pablo Berra Pablo Berra This seems to be the result of how JPQL queries are converted into SQL like syntax before executing. MEMBER |
9 | NullPointer on query> query = em.createQuery("SELECT m FROM ObjectDbMessagePayload m WHERE m.id = :id", ObjectDbMessagePayload.class); query.setParameter("id", msg.getId()); List<ObjectDbMessagePayload> loaded = query ... the exception is thrown from the find method rather than the query. The application is set to try find |
