114 | URGENCY, or in query does not report any objects on first operand having no resultsthis query does not return any objects even there are lot of objects to return for the second ... if the query is changed to select a from Action a where (a.state = 3 or a.state = 2) and a.type = 0 and a.transferred = 0 there are all the results for the condition a.state = 3 it seems that the or |
114 | JPA-Query does not lead to any resultHi, we have a database with a Entitiy inside which we want to fetch with a query. Normally that works without a problem, but in case of this database that query does not have any results. Can anyome ... are two databases, one where the query has a result and one where the query does not has any results |
113 | Empty query results after JAR creation but once the Jar File is created and moved to a different folder, the query does not return any results any ... Hi, I struggle with a strange issue. I've embedded ObjectDB in a small application to query cases ... .jar", I get either empty results or on some cases a "NoResultException" which appears to report |
22 | GROUP BY and HAVING clausesThe GROUP BY clause enables grouping of query results. A JPQL query with a GROUP BY clause returns ... clause in the query execution order is after the FROM and WHERE clauses, but before the SELECT clause. When a GROUP BY clause exists in a JPQL query, database objects (or tuples of database objects |
22 | NoResultException: No matching results for a unique query Alexander Adam The stack trace indicates a normal situation of executing a query that has no results ... I am very often getting a "com.objectdb.o._NoResultException: No matching results for a unique query" when modifying my already persisted entities within a transaction. I cannot replicate |
22 | query only reports 1 result2.7.2_01 suddenly some queries do only have 1 result even there are more results (you can use the database that you have from #308): this query gives 1 result even there are a lot more: select o from ... .classIdentifier = '(XX)' if you take away the last condition you can see a lot of fitting results |
22 | getFirstResult()Method javax.persistence.Query int getFirstResult() The position of the first result the query object was set to retrieve. Returns 0 if setFirstResult was not applied to the query object. Returns: position of the first result Since: JPA 2.0 Learn how to define and use JPA/JPQL queries in Chapter 4 of the ObjectDB/JPA manual. |
2 | addSubquery(sub, variableDeclaration, candidateCollectionExpression)Method javax.jdo.Query void addSubquery( Query sub, String variableDeclaration, String candidateCollectionExpression ) Add a subquery to this query. Parameters: sub - the subquery to add to this Query variableDeclaration - the name of the variable in the outer query to bind the results |
2 | setFilter(filter)Method javax.jdo.Query void setFilter( String filter ) Set the filter for the query. The filter ... collection is returned in the result if: it is assignment compatible to the candidate Class of the Query; and for all variables there exists a value for which the filter expression evaluates to true |
2 | setResult(data)Method javax.jdo.Query void setResult( String data ) Specifies what type of data this query should return. If this is unset or set to null, this query returns instances of the query's candidate class. If set, this query will return expressions, including field values (projections) and aggregate |
