ObjectDB Database Search

Hello All, I am getting the constraint violation exception whil deleting the entries I ... need to delete   records in both tables (TransportationEvent and Conclusion) here i am trying to delete conclusion table records like bellow: removeConclusions(conclusion.getId()); public void

to Parent, so that when the parent is deleted all children are removed as well. Unfortunately, in ... the following case not all children are deleted : ... Parent parent = new Parent(); parentRepository ... is persisted parentRepository. delete (parent); // Here trying to delete the parent

; common.model.UserSession$_ delete _closure1     mr.model.MRAuction$_ delete _closure2     mr.model.MRAuction$_ delete _closure3     mr.model.MRAuction$_ delete _closure4     mr.model.MRAuction$_ delete _closure5     mr.model.MRAuction

. They were present before and also saved in the DB, but are deleted for some time now. When I open the DB ...  ? jakab Gergely Jakab You can delete old classes using the Explorer of version 2.8.3_05 (right click - Delete , or from the Edit menu). Please check if this solves the issue. support Support I

that there are no already deleted objects in the graph to delete but it still didn't work. As you can see my testcase does ... because, in the same transaction, I gather an Extent, delete an object, then try to gather the same ... that was deleted . The fix was to do a PersistenceManager.flush() before trying to gather the Extent

. - If it's an update to an existing track, delete the entire previous entry and then add in the new ... more embedded objects whenever possible. Delaying the delete operations to time with less or no activity (and if you can use one transaction for deletion of many updates it can also improve performance

erase the DB and start all over. But that's a problem. I have discovered it when I had to delete and set the new database in production. It just didn't want to respect the restrictions. I had to delete ... . Otherwise I can't do it. What is it to be done? zmirc Mircea Chirac will not delete classes

to null except the primary key. The same behavior is when we  delete with a query use entityManager ... ;explicitly, in addition to deleting it. However, if the set is defined as mapped by , it will be updated automatically after committing the delete operation and then reloading of the object that contains

;     private boolean deleted ;     private Date modificationTS ... ------------------- [1] Page #19753 entry 0 has unexpected field count (7 instead of 5) 0. oid = '567651' 1. deleted ... #33279 entry 1 has unexpected field count (7 instead of 5) 0. oid = '559770' 1. deleted = false 2

.AbstractCallSite.callGetProperty(AbstractCallSite.java:296) at app.database.ObjectDbDatabase. delete _all_entities(ObjectDbDatabase.groovy:69) at app.framework.Database$ delete _all_entities$0 ... (AbstractCallSite.java:296) at app.database.ObjectDbDatabase. delete _all_entities(ObjectDbDatabase.groovy:69) at app

; } } private static EntityManager createEntityManager(String dbFileName, boolean delete ) {   EntityManagerFactory emf = null;   if ( delete ) {    new File(dbFileName). delete ();    new File(dbFileName + "$"). delete ();   }   emf = Persistence

createEntityManager(String dbFileName, boolean delete ) {   EntityManagerFactory emf = null;   if ( delete ) {    new File(dbFileName). delete ();    new File(dbFileName + "$"). delete ();  

. so we can control deleted items. We can store deleted items on seperate disk or server so , deleted items wont effect performance. We can also annotate them to delete with some time , some timeout. Or

Is there some easy way to force recreation/ deletion of the current database on deployment of a web ... the server, delete the database file, re-start the objectdb server, re-run the web app, which is tedious ... to force ObjectDB to always delete or empty the database file on startup ? webel Dr Darren Kelly

You could delete this post? I'll create a new one with this issue properly. Not close. Delete . flavioreboucassantos Flávio Rebouças Santos We usually do not delete forum threads. But you may abandon this thread ... another post. This post may be closed or deleted . Very thanks! flavioreboucassantos Flávio Rebouças

to do this with ObjectDb, or is the only way to delete the database file everytime? Thanks JFK John Francis You can delete  the database file (and associated files if any) using your code, e.g.     new File(path). delete (); However, this could be a useful ObjectDB feature. Maybe adding

during query execution, where it seems that the temporary file is deleted while the query is executed. The temporary file is deleted only when the database is closed. Is it possible that in your test ... ? Another system property to check (in case the directory was created and deleted

when the JdoBlob2 gets deleted . I use JavaVirtualVm to look at my application heap to see the references to the byte ... to rid the cache of older JdoBlob2s, leaving the newer ones in the cache, such as delete 1/2 ... that legitimately implicitly is telling ObjectDB to keep strong references?)  Recall that if I delete

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 ... . You can try deleting these objects in batches, using several transactions, each transaction will delete

. ObjectDB does not purge old recording files. However, you can delete old odr files manually or from ... #3500781. If you want to delete all the odr files except the last one, 9123744.odr, you should first ... ,and which can be deletes . When you run the replayer it takes one parameter, the database file.  

them. Check that new embedded objects are created and then delete all the unwanted entity objects ... delete now the unwanted entity objects? Since I upgraded the schema where these objects are declared as ... running the delete query from a small console application. If it doesn't work you may have to set

recording? I suppose that we can harmlessly delete all recordings when ODB Server is offline ... transactions are written to the basepoint and deleted later to save disk space?   thamal Tomas Hamal ... , so I would rather delete all transactions and create new base file. But I would like to know if I

and one entry for the Person in the db - as expected. When I try to delete my Person object (pm ... cascading updates and deletes in JDO? There seems to exist a @ForeignKey annotation in JDO ... deleting an object but keeping a reference to it). Regarding cascading operations, even if you use JDO

- Update queries are not supported yet. Used with this code: " DELETE l FROM License l WHERE l.id = ?1 ... ); em.getTransaction().commit(); Another option is to run a JDO DELETE query, e.g. em.getTransaction ... .getTransaction().commit(); JPA DELETE queries are expected to be supported soon. You may subscribe to this issue . support Support

;but when i delete Agent ,it is removed from db but in AgentGroup it is not removed properly. Agent ... ; Thanks Manoj Manoj Kumar Maharana You have to remove it from the collection and then delete ... ;with the agent as the owner side and the agent group as the mapped by side, you just have to delete the owner

it. If it doesn't help - you may have to delete that specific entity object to make the database ... and immediately after a create, update or delete operation the DB throws these errors again. I tried to run ... the same behavior was experienced.   I then tried to delete the DB and create it from scratch

and delete wua Andreas Wurm It may be a good idea to log queries as strings in TRACE logging level. ObjectDB (unlike ORM JPA implementation) does not use queries to implement Insert, Update and Delete operations (except delete / update queries). You may log these operations by setting a JPA lifecycle

-file is enabled. In the new build (2.6.8_08) the temporary file is deleted when the database file ... today. Still, ObjectDB deletes all unused temporary files periodically (also in 2.6.8_06). This happens when a new temporary file is created if the last "all unused temporary files deletion

to objects for deletion to a special "queue" list and delete objects in the background in a low ... / inverse and in that case in practice you can only delete objects and the lists will be updated

Something to check that maybe could help. Log out from the website. Delete all the browser cookies. Log in again. support Support I deleted the cookies and tried to log in again many times. I've also tried in ... delete all cookies / open incognito I go to log in I log in, which redirects me to the home page

.MetaClass [2020-09-03 22:03:33 #10 query.compiler] [2020-09-03 22:03:33 #11 query.manager] Query " DELETE ... :34 #17 query.manager] Query "SELECT a FROM common.model.Site a WHERE a. deleted =false" = 0 results in ... .manager] Query "SELECT a FROM common.model.Person a WHERE a. deleted =false AND a.username='dummy_3'" = 0

.getResultList(JpaQuery.java:719) at schemaupdate. delete .UpdateDB.main(UpdateDB.java:32) Exception in thread ... ) at schemaupdate. delete .UpdateDB.main(UpdateDB.java:32) btc_es BTC EmbeddedSystems Thank

Hello, we can't understand why the performance of queries is not the best and the execution requires so much memory. In the implementation of our UnitTests we have used " DELETE FROM Object" to delete the database. That did not work because we often get an "out of memory" exception

Hi, I have deleted an instance of ClassA . However, if I try to access ClassB , which has a field of type ClassA , ClassB.classA , then, rather than getting a null pointer for classB.classA , I ... are removed/ deleted from the databases - it is the application responsibility to clear any references

; em.createQuery(" delete from Street s").executeUpdate();         em.createQuery(" delete from Location l").executeUpdate();        

Hello, we have questions about the file size of ObjectDB database on disk. Can you tell us something about how the deleting of entities affects the size of *.odb files on disk? -Will the released ... ; We have created a small test, in which we create and delete entities. It looks like that the released memory

Let's say I no longer need some entity in my project and after deleting all the objects ... I found a description that the DB Explorer should be capable to delete classes? But it seems not ... of deleting classes in the Explorer. An obsolete class can be selected in the Schema / Managed

at this point is performing a delete query for all entity objects that the database contains: EntityManager em = _emf.createEntityManager(); em.getTransaction().begin(); try { Query query = em.createQuery(" DELETE FROM ExecutionGraph g"); query.executeUpdate(); query = em.createQuery(" DELETE FROM

Hi. It would be very useful to be able to delete an entire entity class from ObjectDB ... .8.2 adds support of deleting classes in the Explorer. An obsolete class can be selected in the Schema / Managed Types list and then deleted  by using [Edit Delete ] from the menu bar or right click (context menu) and Delete . support Support

with FetchType.LAZY. If I now delete a root entity using EntityManager.remove all leaf nodes will not be deleted . This only applies to the leaf nodes. If I add an additional the behaviour changes so that these new leafes will not be deleted . I created a small test case which can be downloaded at 

.ObjectCacheDB.deleteInOpenTransaction(ObjectCacheDB.java:361) at com.ysoft.cache.objectdb.ObjectCacheDB. delete (ObjectCacheDB.java:356) at com.ysoft.cache.objectdb.ObjectCacheDB. delete (ObjectCacheDB.java:347) at eu.ysoft.safeq.ors.CacheDBWrapper. delete (CacheDBWrapper.java:73) at ysoft.sqcore.job.CacheJobManager

.cache.objectdb.ObjectCacheDB. delete (ObjectCacheDB.java:356) at com.ysoft.cache.objectdb.ObjectCacheDB. delete (ObjectCacheDB.java:347) at eu.ysoft.safeq.ors.CacheDBWrapper. delete (CacheDBWrapper.java:73

can happen when using DELETE or UPDATE queries in a multithreaded application. A transaction ... String DELETE _QUERY =         " DELETE FROM MyEntity WHERE id = :id

indicates a missing (or empty) FROM clause in a DELETE query. Could you please post the query ... with invalid DELETE query: import javax.persistence.*; public class T825 {     public static ... ();         em.createQuery(" DELETE o").executeUpdate();   

Hi, When deleting an entity "Mitglied" - everything works fine. Trying to delete another one (in a separate transaction) always causes a NullPointer Exception in __odbGetNumMember line 1 of the enhanced Mitglied class. I am unable to replicate it in a simple testcase but it always happens in

and the os allowed us to delete the files in question without any problem. In this case we weren't ... ? support Support It was repeatable at the time but we ended up deleting the odb$ to get the app started

? What combination of DELETE / INSERT / UPDATE operations are in that huge transaction? Can we assume ... ; What combination of DELETE / INSERT / UPDATE operations are in that huge transaction? Possible

Currently ObjectDB doesn't prevent deletion of entity objects that are in use and referenced by other entity objects, and it is the application responsibility to avoid such deletion . During development and testing it is recommended to use the ObjectDB Doctor to verify

) . delete ( ) ;          new File ( dbName + "$" ) . delete ( ) ;  

) - some of these references are broken when we delete objects - there is a mechanism in our application ... on deleting are very high. is there a problem to have this kind of broken references ? hgzwicker Hans-Georg