About number

issue

Negative snapshot user count exception

I found the following stack trace in my log files; it's cropped up a number of times: ... stack trace in my log files; it's cropped up a number of times: [2013-08-23 14:05:23 #187 *] [ObjectDB 2.5.2] Unexpected ... 02:44:10 #1 server]), this error shows up a number of times, and today at 10:14 AM PDT we started getting the mismatch ...

 
forum_thread

Pessimistic Lock Timeouts setting

Hi,   I realise that JPA2 doesn't necessarily define a standard API way for Lock Timeouts. However, there is a standardised query 'hint' that can be setup to make the underlying DB lock a record for a specific time. The hint property is: "javax.persistence.lock.timeout" ... and the result is stored in ObjectDB. Due to huge number of stock and updates, I need to use many threads to process this data ... lock is used. Is this exception due to the limited number of supported thread by ObjectDB? (The default number of ...

 
manual

WHERE clause (JPQL / Criteria API)

Explains how to use the WHERE clause in a JPQL query.... to the SELECT. In multi-variable queries the number of tuples for iteration might be very large even if the database is ... The second where method takes a variable number of arguments of Predicate ...

 
release

2.6.7

... Fixed server crash on exceeding maximum number of connections specified in configuration. Fixed ... Improved processing of queries with a large number of variables ( issue #114 ). Improved toString of ...

 
forum_thread

What algorithm in find()

I test the time cost for find(), obtain a linear complexity with the following codes: ... complexity. Why? The cost of insertion is subjected to the number of objects in database?   When the 1,000,000 objects being ... The cache is useful - but not when persisting large number of objects, especially if classes are not enhanced. If the classes are ...

 
issue

EOFException

Not sure if you'll be able to help with this but I've had an application get into a state where it cannot access anything from the database - queries fail with the following exception: ... 27 more Before this error I was getting a large number of EntityNotFoundExceptions: [ObjectDB 2.3.3_06] ... attached the database in question. ObjectDbDoctor finds a number of errors in it (output attached) but I'm not sure if it will be of ...

 
manual

ORDER BY clause (JPQL / Criteria API)

Explains how to use the ORDER BY clause in a JPA/JPQL query.... JavaDoc Reference Page... method takes a variable number of  Order javax.persistence.criteria.Order JPA ...

 
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: ... take much longer than I expect, i.e.: Get the total number of entries Get 25 consecutive entries (i.e. 0-25) Get one ... I haven't managed to figure out: how to get the total number of object in a database without retrieving everything? ...

 
forum_thread

Possible issue with String fields

Hi I'm brand new to objectdb and I'm trying to create an objectdb from a sample db via jdbc. The code all works and for a few thousand records but when I increase the number of records I get the following " ... and for a few thousand records but when I increase the number of records I get the following Exception in thread "main" ... try build 2.3.7_13. When you increase the number of records in a transaction ObjectDB has to use temporary files. Even ...

 
issue

OutOfMemoryError in a query with many variables

Just got this:   ... Can you post the query? Does it have a large number of variables (> 20) ? ObjectDB Support ... fixes this issue and removes the limitation on the number of variables in a query. ObjectDB Support ...