 9 | How write a query in JPA2 with LEFT JOIN on INNER JOIN?
select a.description, a.id, p1 ... a, action_profile ap1, profile p1, ... and add the constraints in the WHERE clause. But actually your query ... , this is my critera query:
CriteriaBuilder cb = entityManager.getCriteriaBuilder();
CriteriaQuery |
9 | 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 |
9 | Is it possible to run a query selecting values that exist in a provided list? e.g. something like ... below). The only similar examples I can find in the docs involve a join query - but my list isn't in the database ... : Unexpected query token 'IN'
at com.objectdb.o.MSG.d(MSG.java:61)
at com.objectdb.o.TKN.J(TKN.java:755 |
9 | , EclipseLink For ObjectDB there is one query in following method, where the full qualified class ... :695)
at at.sciencesoft.db.jpa.DAOjpa.query(DAOjpa.java:326)
at at.sciencesoft.user.User ... - the query works with the simple class name. Breaking down the code for simple example would be little |
9 | :
Query query = pm.newQuery();
query.setResult("count(this)");
query.setClass(myClass);
return (Long) query.execute(); All queries (eg ones with parameters) on the same class fail with the same ... , and the cause is unknown. It happens during cleanup of query execution in a finally block. Maybe |
9 | Is there a way in the Explorer to associate JPQL queries with query result windows? I would really like to be able to open multiple query / result tabbed panes and be able to save out my queries ... of Explorer query result windows show the query string. This is a small quick fix. It is not perfect (e.g |
9 | i'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 ... the classes for running ordinary queries. However, if you use user defined methods in queries (ObjectDB |
9 | Hi, I have a problem with constructing query, that gets only embedded list of integers from Entity. Here's the example :
Query query = em.createQuery("SELECT i.filterDescription FROM Inspiration i");
List> result = query.getResultList(); where Inspiration is like this :
@Entity |
9 | Hello, I am experiencing constant IMK Stall notifications from Java when using certain query ... am sure it is linked with objectdb as these are thrown each time one particular query is used ... query = cb.createQuery(OrderData.class);
Root order = query.from |
9 | _Started 2105:12:10 14:00:00 004
From these 2 tables I have to query for Jobs having ... entity and using TomEE for deployment. I am using following queries.
FINISHED Jobs between a time interval:
@NamedQuery( name = "findFinishedJobsBetweenTimeIntervals",
query = "SELECT J FROM |
