ObjectDB Database Search

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

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

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

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

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

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

.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

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

. 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  

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

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

Hi, I struggle with a strange issue. I've embedded ObjectDB in a small application to query cases ... -Jar xyz.jar", I get either empty results or on some cases a "NoResultException" which appears ... is working but once the Jar File is created and moved to a different folder, the query does not

.getResultList(); none of the Folder objects has its fields populated. Running the same query from the Explorer gives the results as expected. Any ideas what I'm doing wrong? This code had worked

Swim Lessons  10-Pack I would like to know if it is possible to have a query return

of the first collection, the result of the overall query is an empty set. To use the example from ... of the query ).   The following query returned results : SELECT c FROM C c LEFT JOIN FETCH c.bList.aList ... include the full nested fetch, it fails, returning an empty result list: SELECT c FROM C c LEFT JOIN

Hi,    I've got a simple JPA2 Criteria query which fails when doing an object equality ... ; .     @Id    private Long id; } and the query :    @Override public ... I get is: Caused by: com.objectdb.o.UserException: Unsupported query operator '@' at com.objectdb.o

Running two different separate queries and merging the results (e.g. into a Java set, maybe ... c2.original.events AS event WHERE c1.id=?1 OR c2.id=?1 Unfortunately this query returns no events at all, removing the SharedCalendar from the query works as expected. How can I achieve this? Thanks

with query option: query .setHint("objectdb. result -fetch", "LAZY"); btc_es BTC EmbeddedSystems The exception ... more information, including details about the query ? The stack trace indicates an unexpected query variable. Are there non entity variables in the query or an entity class with no instances in the database

Jakarta Persistence (JPA) Method in jakarta.persistence. Query CacheRetrieveMode getCacheRetrieveMode() The cache retrieval mode that will be in effect during query execution. Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence. Query CacheStoreMode getCacheStoreMode() The cache storage mode that will be in effect during query execution. Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Integer getTimeout() The query timeout. Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Field in jakarta.persistence.PersistenceConfiguration QUERY _TIMEOUT Default query timeout hint. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Field in jakarta.persistence.QueryTimeoutException query Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Object getParameterValue (    String name ) Return the input value bound to the named parameter. (Note that OUT parameters are unbound.) Parameters: name - parameter name Returns: parameter value. Throws: IllegalStateException

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Object getParameterValue (    int position ) Return the input value bound to the positional parameter. (Note that OUT parameters are unbound.) Parameters: position - position Returns: parameter value. Throws

Jakarta Persistence (JPA) Method in jakarta.persistence. Query boolean isBound (    Parameter param ) Return a boolean indicating whether a value has been bound to the parameter. Parameters: param - parameter object Returns: boolean indicating whether parameter has been bound. Since: Jakarta Persistence (JPA) 2.0

constraints, ObjectDB can use temporary files when processing large amounts of data, such as query results that contain millions of objects. The element specifies temporary file settings: The path

) A map keyed by query name , containing references to every named query whose result type ... , may be obtained by calling getCache , the CriteriaBuilder , used to define criteria queries , may be obtained by ... entityGraph - entity graph Since: Jakarta Persistence (JPA) 2.1 void addNamedQuery ( String name , Query query

, and its result type. The NamedStoredProcedureQuery annotation can be applied to an entity or mapped ... . The resultClasses element refers to the class (or classes) that are used to map the results . The resultSetMappings element names one or more result set mappings, as defined by the SqlResultSetMapping annotation

not cause type conversion: the runtime type is not changed. Warning: may result in a runtime failure ... Expression.as , this method does result in a runtime type conversion. Providers are required ... composing a compound selection. Modifications to the list do not affect the query . Inherited from

. Since: Jakarta Persistence (JPA) 1.0 Class resultClass (Optional) The class of each query result . The result ... . If the result class of a named query is not specified, the persistence implementation is entitled ... : Annotation Target: Type Declares a named query written in the Jakarta Persistence query language

of the query . Inherited from CommonAbstractCriteria Parameters: type - the subquery result type ... a subquery of the query . Inherited from CommonAbstractCriteria Parameters: type - the subquery result ... . The persistence context is not automatically synchronized with the result of the bulk update

the elements of a query result tuple. See Also: TupleElement Since: Jakarta Persistence (JPA) 2.0 Public ... - if tuple element does not correspond to an element in the query result tuple. Since: Jakarta ... does not correspond to an element in the query result tuple or element cannot be assigned

dynamic options that control runtime behavior and allow you to adjust settings per session, query , or ... every operation in that session. Query (definition): Settings applied to a Query object override session defaults for that query . Operation (argument): Settings passed to specific EntityManager operations ( find

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

context is not synchronized with the result of the bulk delete. A CriteriaDelete object ... entityClass ) Create and add a query root corresponding to the entity that is the target of the DELETE ... - the entity class Returns: query root corresponding to the given entity. Since: Jakarta Persistence

cause type conversion: the runtime type is not changed. Warning: may result in a runtime failure ... Expression.as , this method does result in a runtime type conversion. Providers are required to support ... composing a compound selection. Modifications to the list do not affect the query . Inherited from

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

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

are typed differently. Criteria queries are typed according to the query result type. Update ... type ) Create a subquery of the query . Parameters: type - the subquery result type Returns: subquery ... of the query . Parameters: type - the subquery result type Returns: subquery. Since: Jakarta Persistence (JPA) 1.0

Interfaces: Annotation Target: Type Specifies a mapping of the columns of a result set of a native SQL query or stored procedure. Example: Query q = em.createNativeQuery( "SELECT o.id AS order_id, " + "o ... = "item_name") }) See Also: Query StoredProcedureQuery NamedNativeQuery NamedStoredProcedureQuery

its persistence context, it returns the existing managed object without querying the database. Otherwise, JPA ... , getReference might return a hollow object instead of querying the database immediately. It never returns null ... an entity and another for checking a persistent field of an entity. Retrieval by query The Query

, TupleElement Type of criteria query parameter expressions. Since: Jakarta Persistence (JPA) 2.0 Public ... . Warning: may result in a runtime failure. Inherited from Expression Parameters: type - intended type ... , returning a new expression object. Unlike Expression.as , this method does result in a runtime type

in the query result . Replaces the previously specified selection(s), if any. The type of the result of the query execution depends on the specification of the type of the criteria query object ... , will be instantiated and returned for each row that results from the query execution. If the type

the query result . Replaces the previously specified selection(s), if any. The type of the result ... the specified order, will be instantiated and returned for each row that results from the query ... to the results to be returned by the query Returns: the modified query . Throws

a query . But there are not any results available. We debugged the problem. Thread B executes the query and prints the results to the console, but there are not results . After that the thread stops ... executing the query , in this case we get always the expected results . The problem does only occur

getSingleResult() Retrieve a single result from the next result set. The provider will call execute on the query ... was registered with the query . Returns: the result or null if the next item is not a result set. Throws ... - if more than one result . PersistenceException - if the query execution exceeds the query timeout value set

on the query if needed. A REF_CURSOR result set, if any, is retrieved in the order the REF_CURSOR parameter was registered with the query . Returns: the result or null if the next item is not a result set or ... - if more than one result . PersistenceException - if the query execution exceeds the query timeout value set

You can start an online backup by executing a special query on an EntityManager ( em ) instance ... ").getSingleResult(); The backup query string is always "objectdb backup" . The backup is created in the backup ... a custom backup root directory by setting the target parameter before you execute the backup query

: the resulting fetch join. Since: Jakarta Persistence (JPA) 1.0 Fetch fetch ( SingularAttribute ... Returns: the resulting fetch join. Since: Jakarta Persistence (JPA) 1.0 Fetch fetch ( PluralAttribute ... . Inherited from FetchParent Parameters: attribute - target of the join Returns: the resulting join