About jpql

81-90 of 145Refresh
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
Issue
1

[ObjectDB 2.5.5_03] Unexpected exception (Error 990)

if this should be the case with queries (in JPQL or SQL) because expressions are reordered as part of the query optimization. I did some research on this topic. The NULL handling of JPQL or SQL queries