ObjectDB Database Search

for all classes TypedQuery query = em.createQuery(tmpQuery, Athlete.class); // I want to avoid this List results = query.getResultList(); for(Athlete result : results ) { System.out.println( result .Code + ", " + result .Name + ", " + result .Surname + ", " + result .CountryOfOrigin + ", " + result .Genre

", username);         TrackerUser result = null;         result = (TrackerUser) q.getSingleResult();         em.detach( result );         return result ;  

; ORDER BY lastname, firstname, middleName I may end up with the result list of... Jane K Doe ... ()); alphabetizeList(list); //lastName, firstName, middleName The results in list will be... Jane K Doe John - Doe Jacob B Smith Can this same result list be constructed purely using an ObjectDB Query? Thank

when ordering the results of some projection when the order by expression is different (though logically ... results (error 745) (position 85) at com.objectdb.jpa.JpaQuery.getResultList(JpaQuery.java:728 ... expression 's_location' for distinct results at com.objectdb.o.MSG.d(MSG.java:62) at com.objectdb.o

value doesn't match any results in the database. Our code looks like this: CriteriaBuilder builder ... via a query string and the same data yields in correctly two results . Calling the toString method ... greaterEqual or lessEqual with Criteria API will yield in correct results except if the given date

of Health Sri Lanka You should be able to get the results in milliseconds rather than 3 seconds ... to get the results in milliseconds rather than 3 seconds" was that the execution time should be much faster ... and post the results :     support Support In addition, you should try (for diagnosis): The same

which looks like this: @Entity(name=" RESULT ") public class EBResult extends Pojo implements ... " RESULT " due to class annotation @Entity(name=" RESULT ").  2.1. Why? Is the @Entity(name=" RESULT ") ignored by ObjectDB? 2.2. Is the annotation @Entity(name=" RESULT ") relevant for ObjectDB in any

; EntityManager em = null;   String result = "OK";   try {    emf = Persistence ... (Exception e) {   e.printStackTrace();    result = "FAIL";   } finally {   ... database without any problems. The code runs, result is "OK", but no files are created in ObjectDB

side). Therefore, the server can return all the results in that round trip, bypassing the L2 cache, usually without performance penalty. You can change this behavior by setting the  "objectdb. result -fetch" query hint ... results in the query execution round trip. However, in that case, if not all the results are cached

is often the result . So ObjectDB users must use a configuration that will keep sufficient reserve ... limiting the number of result objects . If you must support very large query result sets, check the temp ... query is run on the server, results are sent to the client and deleted there. This enables

) it may be the result of different JVM configuration. Selecting Data instances in the Java VisualVM heap dump after commit, clicking right and selecting "Show nearest GC root" results with a VisualVM ... results (closer to the ones I saw) when using these JVM startup parameters for the test: -server

http request) before stopping the web-app. Trying to close the entityManager afterwards result in ... ; getServletContext returns null, which result in a NullPointerException when calling getAttribute("emf ... returns null, which result in a NullPointerException when calling getAttribute("emf

. by adding or removing new Chapters), merging the Book class on the server side should result in ... the error case scenario work as that would result in much easier development for me. Thanks ... flawlessly, however it might result in more complicated code for some use-cases. Running it is same as

it prepares all the results , regardless the cache. So the cache is mainly useful for retrieval by ... hint and check if it helps:  query.setHint("objectdb. result -fetch", "lazy"); This is an instruction to the ObjectDB server to return references rather than entity objects as results , which can help

.       harald77 Harald The null and 0 values may be the result of lazy loading. If you see them in the debugger before accessing the result object then this is normal. If you access objects ... reflection. Or is there an easier way to do the whole operation?   The result

;   this.getChildren().parallelStream().forEach(planElement - result .addAll(planElement.getAllCostObjects())); to this.getChildren().stream().forEach(planElement - result .addAll ... welll if I use this: result .addAll(this.getChildren().parallelStream().flatMap(planElement

to database.entity.Player From just fetching a single result : TypedQuery query = em ... the result type (Player) and its class loader. Check also the class loader of Player.class . support ... ("$$$$$"); With results : $$$$$ class com.objectdb.jpa.JpaQuery class com.objectdb.Activator class

) is set to unknown. Both are defined as Boolean in Java code. As a result , update operations ... an Explorer behavior of specifying null results as Unknown type, even when static field type ... the same result : UPDATE RecordingMetaData AS r SET r.emergency=false WHERE r.emergency=null Updates

Hi, can you shed some light on why we cannot delete data from the attached DB file. A delete attempt with DB explorer results in the following exception: [ObjectDB 2.6.3] Unexpected exception (Error ... results if we are successful. As for the use of the DB, our use is very basic, simple (I guess

query needs 4 to 5 minutes to return a result . I have been adviced to use indexes ... ; logTestRunId , then ordering the results may be the problem, since to return the first 25 objects ... can be the solution for this specific query, because results can be ordered by the index rather than by

anyway. Query cache (query-cache results ="256mb" programs="500") 54,283 query results are in the cache. Results have to be removed from the cache on every change to the data that may affect them. Query

is executed by a ThreadPoolExecuter and the result is stored in ObjectDB. Due to huge number ... a result , the processor bean was processing the unlocked stock object. Any other thread which could lock

"), surname)); List allPersons = query.getResultList(); The results will contain records where name ... .close(); } return person; } ThreaT Ashton Hogan Yes, it looks fine. You may also check the result query

demands we flush transaction to db if we wish to see its results   q.setFlushMode(FlushModeType.AUTO ... ", cachedKey.toString());//ObjectDb demands we flush transaction to db if we wish to see its results q

FROM " + RenamedSuperClass.class.getName() + " c", RenamedSuperClass.class); List result = q.getResultList(); System.out.println("size: " + result .size()); We get an exception: [2016-11-14 10:48:56 #1

Tsichevski Done as you suggested. Now the query result is always empty :-(   Regards, Vladimir ... would be needed in order to understand the empty results . Does it happen also with a new database file

and then each Reading separately but still no result . I am guessing this must be an issue ... ", Document.class).getResultList() and then loop through the result . Hope you can help. Thanks @Entity public

transactional, but the spring repository methods are. anyway, the expected result is in the database ... that EntityManager is closed and the result object becomes detached. Since the relationship between Foo And Bar

to the object A and its __odbTracker of type com.objectdb.o.ENT. As a result the instances of A can not ... well. support Support The new build resulted in a failing makeTransient(). Here is the mistake I get: com

) with version 2.8.9_06 returns with immediate results (although zero results ), so are you sure

= "team" are removed from Team the query returns the expected result . TypedQuery query7 = em.createQuery ... = query7.getResultList(); assertEquals(1, q7results.size()); It looks like the result is not filtered

Support I found this is a weird thing, the same codes run the different results in my office pc and home ... as a Java Agent?   Please read the first Google result for "Error opening zip file or JAR

:719) btc_es BTC EmbeddedSystems The stack trace indicates an unexpected state of the query result ... ("objectdb. result -fetch", "LAZY");     return q.getResultList(); } btc_es BTC

(ObjectContext.java:809) at com.objectdb.query. result .SimpleResultBuilder.buildResult(SimpleResultBuilder.java ... Yes, the same exception without enhancement. lwalkowski Lukasz Walkowski The problem is the result

? Results with identical 2nd element will not be filtered anyway if the first element is different. Only results in which all the elements are identical are filtered.   support Support aaahh.. okay

, different POJO classes in one APP would result in DB schema change. Actually, we have tried ... , except SQL queries that are also valid in JPQL), and then iterating over a result sets, as in ordinary

other member, this query works, if I set id as @Id, it stops working and gives zero results ... 2.4.3_01 (as a result of fixing another problem ). Please try build 2.4.3_04 that should fix the new problem. support Support

.Skill.Campaign.Id=: campid And agsk.Skill.Queue.Channel=:chan" for this query am getting empty result ... , and it is unclear if this has anything to do with the reported issue of no results in a query (post #3

.dateCreated = :date I get the correct result (1 Tag). You find a test case at  . Please start the Tester.main(), both queries should return the same results . I use the latest ObjectDB 2.7.2_05 ... Markus Ritter Can you confirm that the query that returns 0 should actually return no results as

the sorted results . However, running this with the criteria API produces this error: Caused by: com.objectdb.o.UserException: Invalid order expression '$2' for distinct results at com.objectdb.o.MSG.d ... .get("name"))));   query.select(root).distinct(true);   List result = em.createQuery(query

')).contracts.active=true)))) results in "Query Execution Error===null" in Explorer and Internal Exception ... front and after that make the check for debitor=true still results in null pointer: SELECT DISTINCT $1 ... // do return false?? Alex quasado Alexander Adam This is the result of a change done today. Try 2.3.6_11. support Support

; creating a new mapped class, e.g. new Employee, won't result in this object being available in ... FlushModeType.AUTO in the EntityManager resulted in a huge exception message. dmoshal David Moshal Hmm, I ... FlushModeType.AUTO in the EntityManager resulted in a huge exception message. Please post it (or send

Support We are not able to reproduce the problem. Result from ObjectDB Doctor check is attached ... to the "processing cache", increasing it to 256mb may result in getting these exception less often, and on the other hand, decreasing it to 8mb may result in getting these exception

the original post that this is a query result collection rather than an entity object with a large ... result paging to retrieve results in smaller chunks of less than 2GB.     support Support

Hello, we found another query bug: SELECT a FROM ArtifactImpl a LEFT OUTER JOIN a.tcSignal s  WHERE a.startStep.stepNumber = 0  AND (s.name IN ('In1') OR a.tcSignal IS NULL) With 2.7.6_b6 we get the expected three result objects. But with 2.8.0 we get only two result objects

both are result of a change in your system or upgrading an ObjectDB version? support Support The connection ... after eliminating the memory and index issues? Update: Apparently this exception is the result

results ), currently the size of a transaction (i.e. the total size of database pages ... classes? support Support Just we have tested by usage of enhanced classes. But the result

ObjectDB to return correct results for the second query (even though there are broken references ... this parameters: latitude and longitude = 0.001 unit = Unit#1974 receiveTime = 0 The result is this error: Query

());   Expected Result ,   account.getProjects() is not null and should contain a project   ... to reproduce your report. Please adjust it to a program that produces different results

large in another page. Maybe this is the result of switching between the two states when the object ... on the database and send the result report? Could you reproduce this exception on a new database