Internal Website Search

51-100 of 200 results

Cache configuration of database file pages, query programs, query results

Are there some possibilities to configure following caches in order to keep cache data for only some important entity types and for the entire life cycle of the EntityManagerFactory. Cache of database file pages. Cache of query programs. Cache of query execution results . btc_es BTC EmbeddedSystems

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

Santos This could be the result of getting query results from the cache. There is no difference between ... that updates by queries bypass the cache and may result in not being seen by queries : "Updating ... When using the CriteriaBuilder to query , the loaded list are not refreshed according to the latest

Query only works correctly when debug printing results

on pc) the query results are only fully read back when debug printing the result contents before ... RequirementLevelEntity l", RequirementLevelEntity.class); List results = query .getResultList(); //Start of debug ... is: query , debug printing query results , then closing entityManager instance. Solutions i tried: Putting

no query result

we are using this query select a from Action a where (a.state = 2 or a.state = 3) and a.type = 0 and a.transferred = 0 and see a very strange query plan, an index scan for an entry that is not used at all in the query , and according to that plan there is no result : Query plan 1/2 description

java.lang.ClassCastException in query results

the "for (Stadium result : results )" line TypedQuery query = em.createQuery( "SELECT Name, Capacity, City FROM Stadium s", Stadium.class); List results = query .getResultList(); for (Stadium result : results ) { System.out.println("Name: " + result .Name + ", Capacity: " + result .Capacity + ", City: " + result

wrong query result

Hi we have a problem with queries , database is returning wrong results . These are the queries we run from ObjectDB explorer. Query 1 - SELECT MAX(e.generisaniID) FROM AktImpl e – returns string ... , Attached are a db repair log and a screenshot of queries and results . We will upload the DB through private

Criteria Query results in a NoResultException instead of returning object

.RuntimeException: com.objectdb.o._NoResultException: No matching results for a unique query at org.jboss.seam ... ._NoResultException: No matching results for a unique query at com.objectdb.o.JPE.g(JPE.java:100 ... ()])); return em.createQuery(criteria).getSingleResult(); which evaluates to the query : SELECT $1 FROM

Query with FETCH JOIN returns multiple results instead of one.

with two services, it's returned twice (both results contain the same instance). I believe that such query ... specified on the right-hand side of the join operation are not returned in the query result or ... ") .setParameter("demand", demand).getResultList(); I want this query to find one and only Demand object

@ElementCollection query returning extra result per element in collection

. The issue is that, I'm getting repeated results of the owning entity of an '@ElementCollection ... ($1.name) LIKE :p1) AND (($1.conditionOne=:p2))) Got: 1 results - correct   ... .branches.branch=:p2) OR ($1.conditionOne=:p3)))) Only expected one result , but got: 2  

URGENCY, or in query does not report any objects on first operand having no results

hgzpincher Hans-Georg Zwicker Checked with 2.8.9 and both queries return 1421 results , so hopefully ... this 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

JPA-Query does not lead to any result

Hi, 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

Query.getSingleResult() - JPA Method

JPA Method in javax.persistence. Query Object getSingleResult () Execute a SELECT query that returns a single untyped result . Return: the result Throws: NoResultException - if there is no result NonUniqueResultException - if more than one result IllegalStateException - if called for a Java

SimpleCase.otherwise(result) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder$SimpleCase Expression otherwise (   R  result ) Add an "else" clause to the case expression. Parameters: result - "else" result Return: expression Since: JPA 2.0

SimpleCase.otherwise(result) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder$SimpleCase Expression otherwise (    Expression   result ) Add an "else" clause to the case expression. Parameters: result - "else" result expression Return: expression Since: JPA 2.0

SimpleCase.when(condition,result) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder$SimpleCase CriteriaBuilder.SimpleCase when (   C condition,     Expression   result ) Add a when/then clause to the case expression. Parameters: condition - "when" condition result - "then" result expression Return: simple case expression Since: JPA 2.0

SimpleCase.when(condition,result) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder$SimpleCase CriteriaBuilder.SimpleCase when (   C condition,    R  result ) Add a when/then clause to the case expression. Parameters: condition - "when" condition result - "then" result value Return: simple case expression Since: JPA 2.0

Case.when(condition,result) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder$Case CriteriaBuilder.Case when (    Expression  condition,    R  result ) Add a when/then clause to the case expression. Parameters: condition - "when" condition result - "then" result value Return: general case expression Since: JPA 2.0

Case.otherwise(result) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder$Case Expression otherwise (    Expression   result ) Add an "else" clause to the case expression. Parameters: result - "else" result expression Return: expression Since: JPA 2.0

Case.otherwise(result) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder$Case Expression otherwise (   R  result ) Add an "else" clause to the case expression. Parameters: result - "else" result Return: expression Since: JPA 2.0

Case.when(condition,result) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder$Case CriteriaBuilder.Case when (    Expression  condition,     Expression   result ) Add a when/then clause to the case expression. Parameters: condition - "when" condition result - "then" result expression Return: general case expression Since: JPA 2.0

Query.getResultStream() - JPA Method

JPA Method in javax.persistence. Query Stream getResultStream () Execute a SELECT query and return the query results as an untyped java.util.stream.Stream . By default this method delegates ... additional capabilities. Return: a stream of the results Throws: IllegalStateException - if called

Query.getResultList() - JPA Method

JPA Method in javax.persistence. Query List getResultList () Execute a SELECT query and return the query results as an untyped List. Return: a list of the results Throws: IllegalStateException - if called for a Java Persistence query language UPDATE or DELETE statement QueryTimeoutException

javax.persistence.StoredProcedureQuery

if first result corresponds to result set Throws: QueryTimeoutException - if the query execution ... result is not an update count. The provider will call execute on the query if needed. Return ... () The position of the first result the query object was set to retrieve. Returns 0

Query.getFirstResult() - JPA Method

JPA Method in 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. Return: position of the first result Since: JPA 2.0 The Running JPA Queries article explains how to use getFirstResult .

Query.setFirstResult(startPosition) - JPA Method

JPA Method in javax.persistence. Query Query setFirstResult (   int startPosition ) Set the position of the first result to retrieve. Parameters: startPosition - position of the first result , numbered from 0 Return: the same query instance Throws: IllegalArgumentException - if the argument is negative Since: JPA 1.0

Query.getMaxResults() - JPA Method

JPA Method in javax.persistence. Query int getMaxResults () The maximum number of results the query object was set to retrieve. Returns Integer.MAX_VALUE if setMaxResults was not applied to the query object. Return: maximum number of results Since: JPA 2.0

Query.setMaxResults(maxResult) - JPA Method

JPA Method in javax.persistence. Query Query setMaxResults (   int maxResult ) Set the maximum number of results to retrieve. Parameters: maxResult - maximum number of results to retrieve Return: the same query instance Throws: IllegalArgumentException - if the argument is negative Since: JPA 1.0

javax.persistence.criteria.CriteriaQuery

whether duplicate query results will be eliminated. A true value will cause duplicates to be eliminated. A false ... the query result or whether they must be retained Return: the modified query . Since: JPA 2.0 Root from ... the result type of the query or subquery. If a result type was specified as an argument

javax.persistence.TypedQuery

JPA Interface TypedQuery Type Parameters: - query result type Super Interfaces: Query Interface ... Since: JPA 1.0 int getFirstResult () The position of the first result the query object was set ... result Inherited from: Query Since: JPA 2.0 The Running JPA Queries article explains how to use

javax.persistence.EntityManager

metadata resultClass - the type of the query result Return: the new query instance Throws ... to be invalid or if the query result is found to not be assignable to the specified type Since: JPA ... of the resulting instance(s) Return: the new query instance Since: JPA 1.0 Query createNativeQuery (String 

Query execution creates a wrong result

Hello, we analysed an unexpected behavior and find out that the result of an Query are wrong ... returns an expected result (one Entity). The second Query is the first Query with an additional ... is fixed with Version 2.6.6.  But we report the BUG, because a wrong Query result

NoResultException: No matching results for a unique query

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

query only reports 1 result

2.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 ... results , a number of them fit with the complete condition hgzwicker Hans-Georg Zwicker This is fixed now

javax.jdo.annotations.Query

default "" Whether the query returns a single unique result . Since: JDO 2.1 String unmodifiable ... JDO Annotation Query Target: ElementType.TYPE Implemented Interfaces: Annotation Annotation for a named query . Corresponds to the xml element " query ". Since: JDO 2.1 Public Annotation Attributes

Query.setRange(fromInclToExcl) - JDO Method

setRange("50, :to"); . The execution of the query is modified to return only a subset of results ... and the remaining 30 results are ignored. An implementation should execute the query such that the range ... JDO Method in javax.jdo. Query void setRange (   String fromInclToExcl ) Set

Query.setRange(fromIncl,toExcl) - JDO Method

JDO Method in javax.jdo. Query void setRange (   long fromIncl,    long toExcl ) Set the range of results to return. The execution of the query is modified to return only a subset of results . If the filter would normally return 100 instances, and fromIncl is set

Query.closeAll() - JDO Method

JDO Method in javax.jdo. Query void closeAll () Close all query results associated with this Query instance, and release all resources associated with them. The query results might have iterators open on them. Iterators associated with the query results are invalidated: they return false to hasNext

Query.close(queryResult) - JDO Method

(...) and might have iterators open on it. Iterators associated with the query result are invalidated ... - the result of execute(...) on this Query instance. Since: JDO 1.0 ... JDO Method in javax.jdo. Query void close (   Object queryResult ) Close a query

Query.addSubquery(sub,variableDeclaration,candidateCollectionExpression) - JDO Method

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 of the subquery ... JDO Method in javax.jdo. Query void addSubquery (    Query  sub,    

Query.setFilter(filter) - JDO Method

JDO Method in javax.jdo. Query void setFilter (   String filter ) Set the filter for the query . The filter specification is a String containing a Boolean expression ... . An element of the candidate collection is returned in the result if: it is assignment compatible

Query.setResult(data) - JDO Method

JDO Method in 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

Query.setUnique(unique) - JDO Method

JDO Method in javax.jdo. Query void setUnique (   boolean unique ) Specify that only the first result of the query should be returned, rather than a collection. The execute method will return null if the query result size is 0. Parameters: unique - if true, only one element is returned Since: JDO 2.0

Query.setClass(cls) - JDO Method

JDO Method in javax.jdo. Query void setClass (   Class cls ) Set the class of the candidate instances of the query . The class specifies the class of the candidates of the query ... the result Collection . Parameters: cls - the Class of the candidate instances. Since: JDO 1.0

Query.setOrdering(ordering) - JDO Method

JDO Method in javax.jdo. Query void setOrdering (   String ordering ) Set the ordering specification for the result Collection . The ordering specification is a String containing ... on which to order the results followed by one of the following words: " ascending " or " descending

javax.jdo.annotations.Query.resultClass

JDO Annotation Attribute in javax.jdo.annotations. Query Class resultClass default void.class Result class into which to put the results . Since: JDO 2.1

Query.isUnmodifiable() - JDO Method

JDO Method in javax.jdo. Query boolean isUnmodifiable () The unmodifiable flag, when set, disallows further modification of the query , except for specifying the range, result class, and ignoreCache option. Return: the current setting of the flag Since: JDO 2.0

Query.setUnmodifiable() - JDO Method

JDO Method in javax.jdo. Query void setUnmodifiable () The unmodifiable flag, when set, disallows further modification of the query , except for specifying the range, result class, and ignoreCache option. The unmodifiable flag can also be set in metadata. Since: JDO 2.0

javax.jdo.annotations.Query.unique

JDO Annotation Attribute in javax.jdo.annotations. Query String unique default "" Whether the query returns a single unique result . Since: JDO 2.1

Query.setGrouping(group) - JDO Method

JDO Method in javax.jdo. Query void setGrouping (   String group ) Set the grouping expressions, optionally including a "having" clause. When grouping is specified, each result expression must either be an expression contained in the grouping, or an aggregate evaluated once per group

Query.deletePersistentAll() - JDO Method

JDO Method in javax.jdo. Query long deletePersistentAll () Deletes all the instances of the candidate class that pass the filter. Returns the number of instances of the candidate class ... into the cache as a result of executing one of the deletePersistentAll methods undergo life cycle