ObjectDB Database Search

These are questions asked in the context of the proposed architecture described in the forum thread titled, "Sample JDO Architecture for Follow Up Questions".   In the objectdb.conf file (attached to forum thread mentioned above), I set Database max -threads.  In the documentation

Error using query with MAX() function

Exceeding max connections and crashing

file on separate storage devices, such as different disks, can improve performance. The max attribute ... to use for caching database file pages. The max -threads attribute specifies the maximum number

the connection URL string, as explained in the JPA Overview section. The max attribute specifies

, LOWER, MAX , MEMBER, MIN, MOD, NEW, NOT, NULL, NULLIF, OBJECT, OF, OR, ORDER, OUTER, POSITION, SELECT

do not support aggregate queries ( max , min, count, sum and avg). ObjectDB supports rich queries

, max , ...) Criteria ORDER BY ( orderBy , Order , asc , desc )

: less-than predicate. Since: Jakarta Persistence (JPA) 1.0 Expression max ( Expression x ) Create an aggregate expression applying the numerical max operation. Parameters: x - expression representing input value to max operation Returns: max expression. Since: Jakarta Persistence (JPA) 1.0 Expression min

. This includes configuration information such as max results, hints, flush mode, lock mode, result set

. Returns Integer.java.lang.Integer/ MAX _VALUE if Query.setMaxResults was not applied to the query object

-8553-cc5688ba142d') ORDER BY MAX ($1.createDate) DESC   but this query returns an exception ... JOIN $1.recipient $2 WHERE ($2.id='22afeafe-363f-4397-8553-cc5688ba142d') ORDER BY MAX ($1.createDate ... $1 JOIN $1.recipient $2 WHERE $2.id='22afeafe-363f-4397-8553-cc5688ba142d' ORDER BY MAX ($1

is retained as part of the named query definition. This includes configuration information such as max

The application works fine with only 256MB heap size with objectdb 1.0  But on 2.0 even with max heap ... more than 64mb at a time. In this application my odb file that needs to be generated can be a max ... that is being generated reaches a size of around 700mb to 800mb (which is close to max heap size of 1012mb

with max results limit. Viewing all the objects of a class without a query and max result limit is not

servers one running JBOSS and other running ObjectDB. - CPU utilization of JBOSS server is max 5-10 ... are unclear. For example: - CPU utilization of JBOSS server is max 5-10% (per core) - CPU

and indices needs only more ram memory, but not more and more memory. And if the max heap memory is big ... . What happens when you run the program with a smaller max heap size?   support Support If I

(because it is stored on an Amazon EBS disk which has max performance at that size and reduces monetary fees by having ... on an Amazon EBS disk which has max performance at that size and reduces monetary fees by having fewer

= new String[2] ;   test[0] = "connection port=6136 max =100" ;   test[1] = "start";   ... command or argument: connection port=6136 max =100 (error 531) Am not sure this is the right place to ask

questions regarding the configuration entry: ... ... max -threads we have 16 processor cores and around 400 clients communicating to our core process, each accessing objectdb. What is the best ... -Georg Zwicker With 16 processor cores the optimum could be around max -threads="16

);   try {    long l = (Long) q.getSingleResult();    if(l Integer. MAX

of the $ file check the recovery max setting. support Support thanks, that helps hgzpincher Hans-Georg Zwicker

chapter 3).     The max attribute specifies the maximum number of simultaneous connections

collection option and explicitly set the min and max heap sizes.  Another option that affects soft

when trying to execute in explorer ( max heap size 1GByte) delete from LogEntry l it comes up with a Java heap error after 20 minutes of executing. How to empty such a table ?     hgzwicker Hans-Georg Zwicker This may be because the transaction size is limited by the heap size

I have a Max OSX Lion and am running Netbeans 7.2 with Glassfish 3.1.2. I download the tutorial and run it. The moment I type something in the sign in block and click add, I get the following error trace: (Does anyone know a fix?)   WARNING: EJB5184:A system exception occurred

the JVM takes the entire 8GB for the heap + additional RAM for other elements, so for example, if the max

;  enabled     CPU(s) scaling MHz:   58%     CPU max MHz:    

to have configuration settings to control the connection pool (min/ max connections, etc...). Thanks, Carl

example, I want to get the object with the highest Id. I tried a query like "count(this.Id)" or " max

The default is 256M  what is the recommended settings based on?  It is the size of the DB? number of connections?  If the DB has over 200GB of data and max connection of 400 then will I need to make this settings higher?  Thanks. Trianglehead Json Error There is no magic

) q.getSingleResult(); if (l Integer. MAX _VALUE) return -1; int i = (int) l; return i; } catch (javax

, go the MyEntity class and remove "mapped-by". You obtain 1 second max of query fetch. So my performance

.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720) What can I do to fix it? pril Max Mustermann

find the config file in my project? pril Max Mustermann You can specify an absolute path. support Support

Integer. MAX _VALUE) {     System.err.println("Can't add any more");    

an object by persisting it again with [id, max -revision + 1]. Add another indexed boolean field

My hosting provider recently had a very brief 'scheduled down time'. After which I was getting objectdb exceptions due to max persistent types in database ( 10). Turns out that hosting provider had migrated machines. Luckily I was able to deal with it quickly. I continue to believe

have been fixed since build 2.4.3_06. You can also try changing the value of  max -threads in

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 (from field e.brojAkta) although field generisaniID is of type long. Query 2 - select e.idRecord, e

cache size Query results cache size support Support Upping the max heap size to 256M has solved this problem. Thank you! banglo mohammad haroon

we have a system where we serve from a host process around 200 clients connected via webSockets (Jetty). The core process is running on a dedicated Windows 2012 server with 16 GByte RAM and 8 processor cores.  What is strange for us is that max 20% of the cpu resources are used and the IO

There seems to be a bug in the JDOQL processor in recent versions of ObjectDB. I've uploaded a "laptop" example to demonstrate the problem. The query in Test1.main should return "ThinkMachine MAX SX ... ) correctly return "ThinkMachine MAX SX 20". Regards. kk8yukawa Keitaro Yukawa Thank you for this report

ObjectDB 2.8.7.b08 Our entities are not enhanced and we execute a query "select max (uid) from ModelElementImpl". In the objectdb.conf the reflection is set to error. ...   We got following ... ;    "select max (uid) from MyEntity").getResultList();      

= "$objectdb/log/odb" max = "8mb" stdout = "false" stderr = "false" / path = "$objectdb/log/odb/archive ... " max = "8mb" stdout = "false" stderr = "false" /              

widthPxSideBarLeft = 250;     @Min(150)     @ Max (400)    

error shown - ojectdb.conf is (we tried max -threads with 24, 40, 80, more or less the same result

, so it should be possible. Could you please try setting the  max -threads attribute in your configuration to 0