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

Hello, I got a realy strange SELECT problem. In explorer query "select p  from Player p where p.confirmed==false", given me some results with p.confirmed==TRUE. And when I try to do (see image) "select p, p.confirmed  from Player p where p.confirmed==false", I getting p-confirmed-true

When I try to execute the following criteria query CriteriaBuilder builder = em.getCriteriaBuilder(); CriteriaQuery criteria = builder.createQuery(relationshipClass); Root root = criteria.from ... .toArray(new Predicate[predicates.size()])); List results = em.createQuery(criteria).getResultList

We are working with objectDB version 2.5.5.b01. (we also tried to use the latest version 2.6.1) We have several issues with queries that can be seen with the attached database and using ObjectDB explorer: 1.       Using ObjectDB explorer a.    

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

) 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 ... items 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

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

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

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

, 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

: 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

join. Parameters: attribute - target of the join Returns: the resulting fetch join. Since: Jakarta ... attribute - target of the join Returns: the resulting fetch join. Since: Jakarta Persistence (JPA) 1.0 ... attribute using an inner join. Parameters: attribute - target of the join Returns: the resulting join

the SELECT clause of a SQL query to an entity result . If this annotation is used, the SQL statement ... columns to related entities. The results obtained when insufficient data is available are undefined. Example: Query q = em.createNativeQuery( "SELECT o.id, o.quantity, o.item, " + "i.id, i.name, i

of all entities in the persistence context which could potentially affect the result of the query ... Enumerates flush modes recognized by the EntityManager . When queries are executed within a transaction, if AUTO is set on the Query or TypedQuery object, or if the flush mode setting

and the other for checking a persistent field of an entity object. Retrieval by Query The most flexible method for retrieving objects from the database is to use queries . The official query language of JPA is JPQL (Java Persistence Query Language). It enables retrieval of objects from the database by