About results

forum_thread

Queries are slow on a large database

Hi, I have a 12GB database with 787603 entries. It is much larger than usual and there are performances issues. I am doing small queries and they take much longer than I expect, i.e.: Get the total number of entries Get 25 consecutive entries (i.e. 0-25) Get one specific entry On average each query needs 4 to 5 minutes to return a result. I have been adviced to use indexes but they are already used through the JDO Metadata file. For instance I use this class: ... same requested  logTestRunId , then ordering the results may be the problem, since to return the first 25 objects, all the ... Id can be the solution for this specific query, because results can be ordered by the index rather than by accessing the data. If you ...

 
forum_thread

java.sql.Date equals comparison not working with CriteriaAPI

Hello, Using ODB 2.4.5 and the Criteria API, doing a simple equals comparison with java.sql.Date value doesn't match any results in the database. Our code looks like this: ... comparison with java.sql.Date value doesn't match any results in the database. Our code looks like this: CriteriaBuilder ... a query string and the same data yields in correctly two results. Calling the toString method of the created predicate yields in ...

 
release

2.7.2

... in handling large objects with long primary keys as query results ( issue #260 ). Fixed detachment of embedded objects to ... Fixed a bug of returning managed hollow objects in query results. Fixed an error message for invalid DELETE query ( issue ...

 
forum_thread

Possible issue with timestamps

Hi, If I query doing something like: select c from CDI c where c.creationDate > {ts '2012-03-29 11:00:00} and c.creationDate < {ts '2012-03-29 12:00:00'} the test fails. Its ONLY for 12:00:00. When I started digging I found that if I queried 00:00:00 to 00:25:00 and then did 12:00:00 to 12:25:00 I got IDENTICAL results. For some reason 12:00:00 is being treated the same as 00:00:00. All other hours seem to be fine. ... 00:25:00 and then did 12:00:00 to 12:25:00 I got IDENTICAL results. For some reason 12:00:00 is being treated the same as 00:00:00. All ... , CDI. class ) ; List<CDI> results = query2. getResultList ( ) ; ...

 
manual

Database Management Settings

Explains settings and performance tuning of the ObjectDB Java object database for JPA/JDO.... priority = "40" /> <query-cache results = "32mb" programs = "500" /> <extensions ... <query-cache> element <query-cache results = "32mb" programs = "500" /> The ...

 
forum_thread

EntityManagerFactory Fails To Swtich Over To Slave When Master Is Unavailable

I have a simple task to validate the sample code will switch over to the slave database when the master is unavailable. I simulate the master unavailable by stopping the master server; which generates the following exception below. What am I doing wrong? It appears the connection manager fails to try the second URL in the list: objectdb://10.9.2.15:9998//10.9.2.15:9999/test.odb;user=admin;password=password Thank you in advance. ... = "10" / > <query - cache results = "32mb" programs = "500" / > ... = "10" / > <query - cache results = "32mb" programs = "500" / > ...

 
forum_thread

Fantom

  Hi, so far I've been able to get ObjectDb to persist objects from many JVM languages, eg.: Java/Groovy/Scala/Kotlin. However, I can't seem to get Fantom to work. Anyone tried this yet? Dave     ... Running the class results in "ERROR: sys::UnknownSlotErr: OdbTest::OdbTest.main" The ...

 
release

2.6.5

... in handling large objects with long primary keys as query results ( issue #260 ). Fixed detachment of embedded objects to ... Fixed a bug of returning managed hollow objects in query results. Fixed an error message for invalid DELETE query ( issue ...

 
forum_thread

First query takes 4+ minutes to complete

Hi, we are evaluating ObjectDB 2.5.1_04 in embedded mode hoping to replace SQLite in our application. We observed that in our case it takes on average more than 4 minutes to complete the first SELECT query that we run on the DB which contains about 320,000 records of a single type of object. SQLite in comparison responds within few seconds on average with the same number of records. We hope to receive your recommendation on how to improve this result with this post.   Test System ... max-threads = "10" /> <query-cache results = "64mb" programs = "50" /> <extensions ... to complete on average when run for the first time. We get results back in less than as second on subsequent executions. Note that we have ...

 
issue

Strange Error with Criteria API and Sorting

We're creating a simple selection (distinct) including an order clause. When watching the created criteria in debugger we get the correct expression: SELECT DISTINCT $1 FROM MyEntity $1 WHERE ((TYPE($1)=class test.MyEntity)) ORDER BY UPPER($1.name) DESC You can see that in the order by there's correctly a "$1" var. Running this (without the type thing before) in the explorer correctly returns the sorted results. However, running this with the criteria API produces this error: ... thing before) in the explorer correctly returns the sorted results. However, running this with the criteria API produces this ... Invalid order expression '$2' for distinct results at com.objectdb.o.MSG.d(MSG.java:61) [objectdb-2.4.4_05.jar:] at ...