Home » Search

About query

191-200 of 200Refresh
Forum
10

Query in JPA2 with LEFT JOIN on INNER JOIN

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
Forum
10

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
Forum
10

"where in" query

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
Forum
10

Entity Type is not found (error 301) in Query

, 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
Issue
10

Error 990 when querying a class with persistence-capable-superclass

: 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
Forum
10

Explorer query functionality

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
Forum
10

how explorer queries work

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
Forum
10

How to query for list of lists ?

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
Forum
10

IMK Stall with certain query

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
Forum
10

JPQL query to get entities that does not have a child entity in their child entities

_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