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 ...

 
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 ...

 
issue

File lock exception on odb$

Not sure if this is an objectdb issue or not but I thought I'd raise it just in case. We had a server failure which caused an unexpected reboot. As a result, the application services which use objectdb were not shutdown properly which in turn meant we had several odb$ files left behind. I had assumed that objectdb would reprocess these when the services restarted but instead we got the exception below. ... When I copy them locally and try to open using objectdb explorer I continue to get the same problem. I've tried to upload ...

 
forum_thread

Updating existing persistence entries

I have stored some instances of MyObject via em.persist(myObjectInstance); I can fetch them and bind them to a kind of property editor in my app (it simply calls the setters to reflect gui editing actions). When I try to persist a object later on, I get an error like com.objectdb.o.UserException: Attempt to reuse an existing primary key value which makes sense to me but I'm missing a em.update() method. ... objects and merge is not required. This is how ObjectDB Explorer (which is also a GUI object editor) works. ...

 
issue

Issue with DISTINCT Select

It is getting more and more frustrating :( We've introduced distinct select instead of regular selection in our code (no changes else) and suddenly receive invalid identifiers in queries exceptions in various queries. Here's the stacktrace: ... the TYPE($1)..() check as this causes more issues in explorer because the generated code from criteriaquery is NOT valid JPQL) -> ...

 
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 ...

 
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

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

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? ...

 
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 ...