Internal Website Search

51-100 of 200 results

no query result

at all in the query, and according to that plan there is no result : Query plan 1/2 description ... all the Action (a) instances. [Step 2] Retrieve fields in Action (a) instances. [Step 3] Filter the results of step 2 retaining only results that satisfy: (a.transferred=0). [Step 4] Filter the results of step

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 ... part commented out, the result doesnt contain all the data. The field requirementList is read back as null ... RequirementLevelEntity l", RequirementLevelEntity.class); List results = query.getResultList(); //Start of debug

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

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 ... results , if: You are using a new EntityManager (i.e. with no old cache), and The 2nd level data

Empty query results after JAR creation

-Jar xyz.jar", I get either empty results or on some cases a "NoResultException" which appears ... return any results any more. What do I wrong? Do I need any additional configuration to deploy ObjectDB ... Hansen Empty results or  NoResultException may be caused by accessing an empty database. In

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 should return only one result , with fetched service sub-elements, shouldn't it? I am almost sure (but I did not bother to check, sorry!) that JPA+Hibernate would return only one result . Am I wrong

LEFT JOIN FETCH over empty embedded collection returns no results

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

@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

and a.transferred = 0 there are all the results for the condition a.state = 3 it seems that the or ... )),(a.type=0)),(a.transferred=0)). [Step 2] Apply selection and prepare final results . 3:notNull ... hgzpincher Hans-Georg Zwicker Checked with 2.8.9 and both queries return 1421 results , so hopefully

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

wrong query result

Hi we have a problem with queries, database is returning wrong results . These are the queries ... correct results We had this problem on records created on 13 and 14 January, problem was detected ... , 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

Multiple joins did not return expected result

OR c2.id=?1 instead? There is no error at all, just an empty result . Thats why I thought ... Running two different separate queries and merging the results (e.g. into a Java set, maybe

Indexing a field results in internal Exception

annotation.  Is there anything I can look for that might result in this exception? sjzlondon Steve Zara

Bug with unique constraint exception not resulting in transaction roll back

does result in a transaction rollback as expected.   However, this same method

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

Fields in objects not populated in query result.

the Explorer gives the results as expected. Any ideas what I'm doing wrong? This code had worked

Wrong select results

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

An InternalException occurs when gets an result list

with query option: query.setHint("objectdb. result -fetch", "LAZY"); btc_es BTC EmbeddedSystems The exception

CriteriaQuery using isNotNull with other conditions results in InternalException

.toArray(new Predicate[predicates.size()])); List results = em.createQuery(criteria).getResultList

Unexpected COUNT Results

Unexpected COUNT Results

Iterating over large result set

Iterating over large result set

String Contains Query Result - Possible?

String Contains Query Result - Possible?

Object as parameter results in exception

Object as parameter results in exception

ObjectDB 2.6.9_06 (embedded): Cascading merge resulting in duplicate objects

ObjectDB 2.6.9_06 (embedded): Cascading merge resulting in duplicate objects

Database Doctor

to the database file (e.g. my.odb as shown above). Diagnosis results are printed to the standard output

Is ObjectDB better than Object Relational Mapping (ORM)?

As noted above, using ObjectDB instead of a relational database and ORM combination is easier and leads to better performance. ORM tools, however, are very useful where the use of a relational database is mandatory (e.g. as a result of a customer request or when a new application

Shared (L2) Entity Cache

side: Cache of database file pages . Cache of query programs . Cache of query execution results

Chapter 6 - Configuration

the parent directory is considered to be the ObjectDB home directory ( $objectdb) . As a result

Online Backup

. As a result , the backup query returns a Thread instance that represents the backup run. This thread

Paths and Types in JPQL and Criteria API

Instances of user defined persistable classes (entity classes, mapped super classes and embeddable classes) are represented in JPQL by the following types of expressions: Variables - FROM identification variables and SELECT result variables. Parameters - when instances of these classes

Working with JPA Entity Objects

EntityManager should always result in the same in-memory entity object. Another way of looking

ObjectDB Website - Terms and Conditions of Use

representations concerning the accuracy, likely results , or reliability of the use of the materials

Database Server

, which is much more efficient. As a result , embedded mode should be preferred when possible. For example

JPA Primary Key

in an efficient way. This is especially useful when using queries that return large result sets. As

javax.persistence.StoredProcedureQuery

getUpdateCount . The results of executeUpdate will be those of getUpdateCount . The execute method supports both the simple case where scalar results are passed back only via INOUT and OUT parameters as well as the most general case (multiple result sets and/or update counts, possibly also in combination

DB persist operation results are not available for another Thread/EntityManager immdiately

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 ... again. And we get the expected results . Why? It is also possible to insert a Thread.sleep(1000) before

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

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 WHERE condition. But than we get another (wrong) result .   We used Version 2.6.5 and the BUG

NoResultException: No matching results for a unique query

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 ... Adam The stack trace indicates a normal situation of executing a query that has no results

javax.persistence.criteria.CriteriaQuery

JPA Interface CriteriaQuery Type Parameters: - the type of the defined result Super Interfaces ... whether duplicate query results will be eliminated. A true value will cause duplicates to be eliminated. A false value will cause duplicates to be retained. If distinct has not been specified, duplicate results

javax.persistence.criteria.From

-valued attribute using an inner join. Parameters: attribute - target of the join Return: the resulting ... the given join type. Parameters: attribute - target of the join jt - join type Return: the resulting join ... - target of the join Return: the resulting fetch join Inherited from: FetchParent Since: JPA 2.0 Fetch

javax.persistence.criteria.Join

() Whether the From object has been obtained as a result of correlation (use of a Subquery correlate ... Return: the resulting join Inherited from: From Since: JPA 2.0 CollectionJoin join ( CollectionAttribute ... : the resulting join Inherited from: From Since: JPA 2.0 ListJoin join ( ListAttribute  list) Create

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 ... before the stored procedure can be executed. If the stored procedure returns one or more result sets

javax.persistence.criteria.Subquery

is not changed. Warning: may result in a runtime failure. Parameters: type - intended type ... distinct (boolean distinct) Specify whether duplicate query results will be eliminated. A true ... . If distinct has not been specified, duplicate results must be retained. This method only overrides

Getting Started with JPA - Maven Project

The Getting Started with JPA tutorial provides step by step instructions on how to build a simple JPA database driven application in Eclipse or NetBeans . Building a new application step by step is an effective way to learn - but if you prefer, you may download and run the result

[ODB1] Chapter 3 - Persistent Classes

the byte code of these classes, and the result is classes that do implement the PersistenceCapable

[ODB1] Chapter 1 - About ObjectDB

database (for example, as a result of special customer needs or requests) can be done without modifying

javax.jdo.Query

. There are three required elements in a Query : the class of the results , the candidate collection ... , import statements, ordering and grouping specifications, result and result class, the range of results , and flags indicating whether the query result is unique and whether the query can be modified

Query.setResultClass(cls) - JDO Method

of object in which to return each element of the result of invoking execute or one of its siblings. If the result is not set or set to null, the result class defaults to the candidate class of the query. If the result consists of one expression, the result class defaults to the type