About query

forum_thread

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, similar to what you can do in Benthic Golden or Toad in the SQL world. Alternatively are you aware of any other JPA + JPQL workbench tools, commercial or otherwise that would support this? ... 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, similar to what ...

 
issue

Different behavior for two equal queries

Hi, I've got two equal queries though they behave differently: SELECT FROM com.quasado.foundation.communication.contact.individual.IndividualContact $1 WHERE (($1.organisation.name LIKE '%Q%')) This correctly returns one entry from my database ... plans from the explorer if that helps: First query (which works): Query Plan Description ====================== Step 1: Process ... selection and prepare final results. Second query (which fails): Query Plan Description ====================== Step ...

 
forum_thread

Query in JPA2 with LEFT JOIN on INNER JOIN

select a.description, a.id, p1.description, p2.description,p3.description from action a left join action_profile ap1 on ap1.id_action=a.id inner join profile p1 on  ap1.id_profile=p1.id  and p1.name='?' left join action_profile ap2 on ap2.id_action=a.id inner join profile p2 on  ap2.id_profile=p2.id  and p2.name='?' where a.id =?;   Thanks   ... 13:29 How write a query in JPA2 with LEFT JOIN on INNER JOIN? SELECT a . description ... in the WHERE clause. But actually your query may indicate that you model is not optimized for JPA. Instead of ...

 
forum_thread

IMK Stall with certain query

Hello, I am experiencing constant IMK Stall notifications from Java when using certain query: 2015-09-01 16:53:15.785 java[3678:5217999] IMK Stall detected, *please Report* your user scenario in <rdar://problem/16792073> - (imkxpc_deadKeyStateWithReply:) block performed very slowly (4.63 secs) i am sure it is linked with objectdb as these are thrown each time one particular query is used: ... Stall notifications from Java when using certain query: 2015 - 09 - 01 16 : 53 : 15.785 java ... with objectdb as these are thrown each time one particular query is used: String param = "%" + begining + "%" ...

 
forum_thread

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

I have 2 tables as shown below. Job Table ID JobId Name StartTime    FinishTime    .... 01 001   A  2105:12:10 14:00:00  2105:12:10 14:00:10 02    002  A  2105:12:10 14:00:00  2105:12:10 14:00:00 03    003  A  2105:12:10 14:00:00  2105:12:10 14:00:00 04    004  A  2105:12:10 14:00:00  2105:12:10 14:00:00 And ... 00 : 00 004 From these 2 tables I have to query for Jobs having states FINISHED, CANCELED, FAILED and ACTIVE. ... = "findFinishedJobsBetweenTimeIntervals" , query = "SELECT J FROM JobEntity J, IN(J.statuses) JS WHERE " + ...

 
forum_thread

Criteria Query results in a NoResultException instead of returning object

When I run the following code    ... ( ) ; which evaluates to the query: SELECT $1 FROM IdentityObject $1 WHERE $1 . name = ... No matching results for a unique query at ... No matching results for a unique query at com.objectdb.o.JPE.g(JPE.java:100) at ...

 
forum_thread

Sorting problem

Hi, I was rewriting our DAO to support pagging in large dataset and I think I have found a problem with sorting. I send you a test case - sorry for using the same project as previous, but it was faster to write this test case. As usual, you can load data with DataLoader and then check problem with QueryData. There is a simple query with "order by" sentence: ... check problem with QueryData. There is a simple query with "order by" sentence: List<Branch> prodList = ... ( 1 , "br.id" ) ; This query should return all the branches sorted descending, but I get this result: ...

 
forum_thread

Several parallel threads to speed up query on one DB

Hi, I have an application: producer (from a DB) to a consumer. The current bottleneck is the producer from DB (based on a query) and I would like to speed it up. I have tried using several entity managers (same DB instance) to benefit from the parallelisation - but it looks like I don't get much benefit from doing that.  ... The current bottleneck is the producer from DB (based on a query) and I would like to speed it up. I have tried using several ... - and it looks like there are some benefits - i.e. each query in a thread is running simultaneously - but it looks sometimes the "query ...

 
forum_thread

Order in WHERE Clause affects behaviour on DATE/DATETIME columns

Quick example:  public class MyClass { @Column(name = "myText") String myText; @Temporal(TemporalType.TIMESTAMP) @Column(name = "myDate") Date myDate; } Now, when querying the db with: ... Now, when querying the db with: Query q = JPA. em ( ) . createQuery ( "SELECT m FROM MyClass m WHERE m.myDate LIKE :query OR m.myText LIKE :query" ) ; q. setParameter ( ...

 
forum_thread

Entity Type is not found (error 301) in Query

Overall test OpenJPA, HibernateJAP, EclipseLink and ObjectDB. No Problem with OpenJPA, HibernateJAP, EclipseLink For ObjectDB there is one query in following method, where the full qualified class name is necessary. See method code - red part Otherwise an error will occure. ... EclipseLink For ObjectDB there is one query in following method, where the full qualified class name is necessary. ... at.sciencesoft.db.jpa.DAOjpa.query(DAOjpa.java:326) at ... strange, because in the same method - other workflow - the query works with the simple class name. Breaking down the code for simple ...