About HAVING

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: #1 2014-05-28 13:05 Hi, I have a 12GB database with 787603 entries. It is much larger than usual and there are performanc ...

 
forum_thread

Handling deleted references

Hi support team, I have a problem when using DELETE query to delete Entity instances. We use the following hierarchy: #1 2016-11-18 14:34 Hi support team, I have a problem when using DELETE query to delete Entity instances. We use the foll ...

 
forum_thread

Is it ok to put list or map of embeddable objects in entity ?

Hi, Is it ok to put list or map of embeddable objects in entity? I mean, for example : @Entity public class Entity_A {     (...)     @Embedded     List<Class_B> bList;     @Embedded     Map<String, Class_C> cMap; (...) } where Class_B and Class_C are annotated as @Embeddable ? In the examples, there is only situation where there is one single instance of embeddable class in entity. And what happens if I do operation like : #1 2011-04-05 08:33 Hi, Is it ok to put list or map of embeddable objects in entity? I mean, for example : @ En ...

 
forum_thread

lockfiles in client/server mode

i have an objectdb server running on localhost as user "objectdb", spawned like so: java -server -cp /usr/local/share/objectdb/objectdb.jar: com.objectdb.Server -conf /etc/objectdb/objectdb.conf start it has naturally created and taken ownership of /tmp/ObjectDB. #1 2012-04-05 21:36 i have an objectdb server running on localhost as user "objectdb", spawned like so: java -server ...

 
forum_thread

Embedded in JDO metadata not working in objectDB 2.x ?

Hi, I am using JDO access to the database with the persistence defined in package.jdo XML metadata files. In those metadata files I have few persistence-capable classes which had extents in ObjectDB 1 (with an OID for every instance) and all other classes were embedded (so without extent and own OID) in those few peristence-capable ones. Example of JDO metadata: #1 2014-07-04 16:48 Hi, I am using JDO access to the database with the persistence defined in package.jdo XML metadata files. ...

 
forum_thread

Guestbook EE ear app please

Using Eclipse I have no problems running the Guestbook app as a web app on an EE 6 server. However, I would like to call the ejb from a remote client. I have tried various ways in creating different projects for ejb, web and client, with and without an ear, and bump into queer problems. Of course I have a remote (and local) interface, but I can't get anything to run unless I do EXACTLY one web project as in your tutorial. Can you please put together another tutorial illustrating remote client access along with web access. #1 2014-10-19 18:24 Using Eclipse I have no problems running the Guestbook app as a web app on an EE 6 server. However, I wou ...

 
forum_thread

To open source, or not to open source

Hi, We are currently using db4o with a commercial licence, but finds it very frustrating after they have been taken over by Versant. The development of db4o is going very slow and major bugfixes are not been backported to stable releases, but only put into bleeding edge branches.   Therefore we do the bugfix backporting ourself. This would not have be possible if db4o was close source.  #1 2012-02-01 09:59 Hi, We are currently using db4o with a commercial licence, but finds it very frustrating after they have ...

 
forum_thread

Eclipse plugin problem (using ObjectDB as a separate bundle)

Hello support, I have seen multiple attempts to correct similar errors as in the title above - the latest in the 2.2.8.01 release of objectDb. However I still get this error.   Here is my scenario (Groovy 1.8 and Eclipse 3.6) used. I have a com.epimss.lab.data.toxicology.TherapeauticDrugScreenRqst. Nested in this class are the following two classes: com.epimss.lab.data.misc.OtherRqst and com.epimss.lab.data.misc.RequestDateAndNumber. #1 2011-07-11 15:49 Hello support, I have seen multiple attempts to correct similar errors as in the title above - the latest ...

 
forum_thread

Changing from client server to embedded mode

Hi, I have created a java web application and used ObjectDB in client Server mmode. It worked as per my expection. In Client server mode I used Persistence.createEntityManagerFactory("objectdb://localhost/myDB.odb;user=admin;password=admin"); Now to switch to embedded mode, I have tried following things #1 2013-03-26 08:13 Hi, I have created a java web application and used ObjectDB in client Server mmode. It worked as per my e ...

 
forum_thread

Indexing a field results in internal Exception

I have an application that I have been converting from JPA/MySQL to JDO/ObjectDB and I have hit a problem with indexing. An index on a String field is required to give good performance but if I add the @Index annotation to the field I eventually end up with an ObjectDB internal exception.  This is reproducible, as is the program running to completion (slowly) if I remove the @Index annotation.  Is there anything I can look for that might result in this exception? #1 2013-04-21 20:40 I have an application that I have been converting from JPA/MySQL to JDO/ObjectDB and I have hit a problem with in ...