About drop

forum_thread

Server vs embedded mode in multi-instance scenario

We are creating a web app that will have multiple different clients, each on their own EC2 instance(s). The clients do not need to share any data, so each could have its own ObjectDB. Clients have a user base of about 2,000 to 60,000 users that could possibly be using their application at any given time (100k absolute maximum). We will probably have multiple instances per client for availability concerns as well as auto scale during peak usage, at least for the benefit of our web application if not for objectdb.... what I can tell, there will be about a 50% performance drop from using Server mode to accommodate the <1% of use scenarios. However ...

 
forum_thread

Mapped (Inverse) LAZY @OneToMany vs. Unmapped LAZY @OneToMany

In the code example below (also attached) I would like to understand why I am able to print to console a lazy @OneToMany mapped field after a finding entity manager closes. There is a switch DO_VIEW_BEFORE_CLOSE, and when it is true the fields are accessed and output before the finding entity manager closes and as expected both a mapped @OneToMany list and an unmapped @OneToMany list are viewable: a.listA_mapped:[{A}[4]"ownedElement1", {A}[5]"ownedElement2"] a.listB_unmapped:[{B}[2]"b1", {B}[3]"b2"] ... $connection = "objectdb:db/TestLazyOneToMany.tmp;drop" ; EntityManagerFactory emf = ...

 
forum_thread

java.sql.Time field off by 30 minutes

Hihi, I'm wondering if this is a bug. I have a simple entity with java.sql.Time field. On writing and readback, the field is found to be 30 minutes off. It is observed on objectdb explorer as well. Timestamp works perfectly fine. Ps. dont think its a UTC issue. My system is set at far off UTC+30min time.   ... "objectdb:$objectdb/db/test-my-entity.tmp;drop" ) ; EntityManager em = emf. ...

 
forum_thread

Performance tuning, best practices

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 subsystem is at maximum 30% of activity under heavy load but database queries are let's say not at the speed we would expect. We have currently 20.000.000 objects in the database, our configuration settings are: ... programs="500" />   <extensions drop="temp,tmp" /> </database> <entities>   ...

 
forum_thread

Issue with orphanRemoval and multiple EntityManagers

Hi, We have a problem where our database size grows over time more than expected. We've traced it down to the following issue: ... ( "objectdb:test.tmp;drop" ) ; long orgId = 0 ;   ...

 
forum_thread

Get multiple entities by Id

I'm trying to fetch a list of entities, by their Id. I Use this query: SELECT c FROM User c WHERE c.id IN :ids This querey works as long as I don't set the property "id" as @Id. If i set @Id to any other member, this query works, if I set id as @Id, it stops working and gives zero results. Is this a known limitation or a bug? Do you have any idea how to solve this problem? ... "objectdb:$objectdb/db/test.tmp;drop" ) ; EntityManager em = emf. ...

 
forum_thread

Remove an entity which attributes were changed - OptimisticLockException

We use an OSGi environment and we have three OSGi plugins.   In plugin A an entity is loaded and the entity is passed to plugin B. Plugin B changes an attribute on the entity. Plugin C removes the entity from the database. After commit the transaction an exception is caused with optimistic lock exception of the removed entity. If this operations on the entity are executed in only one plugin, it works well. ... ( "objectdb:$objectdb/db/test.tmp;drop" ) ;   EntityManager em = emf. ... ( "objectdb:$objectdb/db/test.tmp;drop" ) ;   EntityManager em = emf. ...

 
forum_thread

Activation Issue

Hi, We bought a site license the yesterday. I ran the activation class this morning. That generated the activation key. I took that key as per the instructions, added it to the objectdb.conf inside the jar, and everything was happy. (this was with 2.3.7). However after a reboot I'm now getting the evaluation license restriction message again at compile time (which was I was seeing before putting the activation key in objectdb.conf). I tried upgrading to 2.3.7_02 and updating objectdb.conf with the activation key, but get the same behaviour. ... programs = "500" /> <extensions drop = "temp,tmp" /> <activation code = ...

 
forum_thread

LAZY @ManyToOne field functions as EAGER

In the code example below (also attached) I would like to understand why I am able to print to console a lazy @ManyToOne field after the entity manager closes. There is a switch DO_VIEW_BEFORE_CLOSE, and when it is true the fields are accessed and output before the finding entity manager closes and as expected both a LAZY @ManyToOne field and an EAGER @ManyToOne field are viewable: b.cLazy:{C}[2]"cLazy"
 b.cEager:{C}[3]"cEager" ... $connection = "objectdb:db/TestLazyManyToOne.tmp;drop" ; EntityManagerFactory emf = ...

 
forum_thread

Query for objects persisted within the same transaction

I have a question concerning reading uncommited entities with query, within active transaction. For example, I read data from file. Each line contains value of one of entity's attributes but those values are not unique, so it's possible to have a multiple instances of the same entity. To eliminate duplicates, after reading every line I first check using a query, if an entity with that attribute value already exists. If no - I create one and persist it.... stick with map to check for duplicates, as performance drop is like 20x - just tested. ...