About jpql

71-80 of 136Refresh
Forum
2

Explorer in 2.3

to do ad-hoc JPQL queries and navigate through the results and even make small changes to primitive ... that could be extended and may be also supported during editing. Only expressions that are valid in queries (JPQL ... , not a JPQL expression in a query. For example, I double click on a String field in an entity. Right
Forum
2

Query in JPA2 with LEFT JOIN on INNER JOIN

in JPQL. Instead of ON you may  include all the variables in the FROM clause: FROM action ... ) between entity objects, and then you would be able to use ordinary JOIN of JPQL. Hi ... join ? You cannot specify multiple conditions on left join in JPQL. The syntax of JPQL is different
Forum
2

IN expression in a Criteria Query

, it is written that ObjectDB is 100% compatible with JPA. However, I have problem with this JPQL query ... API. The problem I was getting, was a syntax error when the "IN (:bindVar)" was used within a JPQL ... was on criteria queries, but it is the same with JPQL, since criteria queries are converted into JPQL query
Forum
2

Criteria Query results in a NoResultException instead of returning object

to the following JPQL query: SELECT $1 FROM IdentityObject $1 WHERE $1.name='demo' You have to use ... ?   identityNameProp.getName() does return "name."  Also, the JPQL equivalent of the criteria query ... anything while the JPQL version returns the object.   Here are more runnable versions
Forum
2

Join performance in Objectdb

: JPQL> select count(e.id) from Page e 1 java.lang.Long: 161143 Time : 23.889999 JPQL> select count(e.sUrl) from Page e 1 java.lang.Long: 161143 Time : 96.968002 JPQL> select count(e.iSize) from Page e 1 java.lang.Long: 161143 Time : 10.359000 JPQL> The command tool is from the book
Forum
2

Query results are not up to date for entities, not primitives

updates. But, when using the JPQL Query, the list are refreshed, and, when I querying for primitive ... CriteriaBuilder to JPQL or from Entity to Primitive. What´s now? This could be the result of getting query results from the cache. There is no difference between criteria queries and string based JPQL queries
Forum
2

Explorer query functionality

Is there a way in the Explorer to associate JPQL queries with query result windows?  I would really ... of any other JPA + JPQL workbench tools, commercial or otherwise that would support this? Following ... result windows. We don't know about other general JPA/JPQL tools that are better than the ObjectDB
Forum
2

First query takes 4+ minutes to complete

the queries (JPQL SELECT statements) shown next.  Query We test with the following query: SELECT r from ... in the WHERE part of the SQL/JPQL. In our case the fields are in the ORDER part. So, I do not think ... that appear in the WHERE part of the SQL/JPQL. In our case the fields are in the ORDER part. So, I
Issue
2

Issue with DISTINCT Select

because the generated code from criteriaquery is NOT valid JPQL) -> you get the same issue.   thanks ... ? this is really confusing, I so much often wish to have a better interface than JPQL :( Thanks, Alex Why not ... .lastName) (which I think is not valid in JPQL but works with ObjectDB). You can also use: SELECT
Issue
1

@Enumerated(EnumType.STRING) annotation inhibits proper execution of IN expressions.

When the following annotation is present on an enum type entity field: @Enumerated(EnumType.STRING) Queries using JPQL IN expressions on this field won't work correctly anymore. This issue has been described in forum post 681 (JPA JPQL WHERE clause for IN :variable not working if variable is a list