About Explorer

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: #1 2016-11-15 08:07 we have a system where we serve from a host process around 200 clients connected via webSockets (Jetty). The core ...

 
issue

Schema-Update: Deactivation of automatic entity class removing and introduction of a new class remove in the schema config

Hello, in our application we use ObjectDB in embedded mode as part of the Profile that can be stored and opened by our customers. Our application is an eclipse RCP application with a domain-driven design. The product can be installed in different configurations (in other words with more or less PlugIns). This presents us with further challenges when we have made changes to DB schema for new versions. ... using the stored schema (e.g. this is how the Explorer works). ObjectDB Support ObjectDB - Fast ...

 
issue

Unexpected Query Token / Casting in Query

Hi! Please find the attached database. Doing a simple query with casting SELECT COUNT(DISTINCT $1) FROM com.quasado.foundation.contact.individual.IndividualContact $1 WHERE UPPER(((com.quasado.foundation.warehouse.api.model.account.contact.IndividualContactDebitorAccountFragment) $1.qubletFRAGMENTMAP.get('com.quasado.foundation.warehouse.api.model.account.contact.IndividualContactDebitorAccountFragment')).debitorAccount.bankAccounts.routingNumber) LIKE UPPER('%28%') results in the error ... type of the field when the model classes are missing (in Explorer and Server). I fixed it. But the navigation from the ...

 
forum_thread

How force always recreate database on redeployment.

Is there some easy way to force recreation/deletion of the current database on deployment of a web application (to Glassfish). My web application uses a @Singleton @Startup bean to create and persist a test model each run. I keep getting models on top of each other on rerunning my web application. Currently, to avoid multiple models in the database, I have to undeploy from Glassfish, stop the server, delete the database file, re-start the objectdb server, re-run the web app, which is tedious. ... database file is in use, including if it is open in the Explorer, drop will not work. ObjectDB Support ...

 
forum_thread

Memory Leaks after COMMIT operation (checked on versions 2.6.5 & 2.6.6.b01)

During import big logs we are observed some memory leaks inside of ObjectDb, so, could you explain what we did incorrectly or investigate how to fix it ASAP. Source code which causing memory leaks: #1 2016-02-04 09:54 During import big logs we are observed some memory leaks inside of ObjectDb, so, could you explain what we did in ...

 
forum_thread

Drop the entire database, Change the schema

I am trying to port and example app to ObjectDb. As part of the tests I drop the database and reload it with the new schema automatically between test cycles. Is there a simple way to do this with ObjectDb, or is the only way to delete the database file everytime? Thanks ... be enough safety, and keeping the .odb allows the explorer to find the database more easily.     ...

 
forum_thread

Performance issues on aggregate query

we are using this aggregate query to collect some data: ... (you can see query plans when running queries in the Explorer). The SELECT clause in your post seems to be cut at the middle ...

 
forum_thread

Field not persisted in abstract class with two level of nesting

Hi, I have a field (embedded TZ1) which is not persisted in class MHD1 (TZ1  extends AS and AS extends ATT). But it seems to work fine when I skip the AS and make TZ2 extend directly from ATT. Here is an example code MHD1 #1 2014-06-18 12:52 Hi, I have a field (embedded TZ1) which is not persisted in class MHD1 (TZ1  extends AS and AS  ...

 
forum_thread

How to resolve 404 errors with Eclipse/Maven Spring MVC

I have created a project as guided by www.objectdb.com/tutorial/jpa/eclipse/spring/run. When I abandon eclipse and use the maven command line to deploy this Spring MVC web app to jetty and point my browser to localhost:8080/Guestbook/ it works as your tutorial says! ... Juno (eclipse-jee-juno-SR1-win32-x86_64), but the project explorer is closed and cannot be opened. Where is the project directory? ...

 
forum_thread

alter table

Hi: After a table built by real data, how to alter table structure, such as: alter table add column ... alter table add index ... TIA ... has, but how objectdb do the same thing? In the Explorer of ObjectDB 2.3 (not released yet) you will be able to see the ...